ExpertClasses


Description

Career Building Events Offered to Candidates.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
PreviousLearnerPromotionNotifications.expertClassId PreviousLearnerPromotionNotifications_expertClassId_fkey R
ExpertClassActionLogs.ExpertClassId EventActionLogs_ExpertClassId_fkey R
ExpertClassApplications.publishedExpertClassId ExpertClassApplications_publishedExpertClassId_fkey R
ExpertClassCertificates.ExpertClassId ExpertClassCertificates_ExpertClassId_fkey R
ExpertClassCertificateTokens.ExpertClassId ExpertClassCertificateTokens_ExpertClassId_fkey R
ExpertClassClassCategories.ExpertClassId ExpertClassClassCategories_ExpertClassId_fkey R
ExpertClassExpertClassPromotionCodes.ExpertClassId ExpertClassExpertClassPromotionCodes_ExpertClassId_fkey C
ExpertClassExpertClassWhatYouGetOptions.expertClassId ExpertClasses_fkey R
ExpertClassPlatforms.ExpertClassId ExpertClassPlatforms_ExpertClassId_fkey R
ExpertClassShares.ExpertClassId ExpertClassShares_ExpertClassId_fkey R
ExpertClassSkills.ExpertClassId EventSkills_ExpertClassId_fkey R
ExpertClassSpeakers.ExpertClassId ExpertClassSpeakers_ExpertClassId_fkey R
ExpertClassTicketTypes.ExpertClassId ExpertClassTicketTypes_ExpertClassId_fkey R

Primary Key.
title varchar 255 null

Name of the event.
bannerPic text 2147483647 null

File name linking to their resumes in s3 bucket glints-dashboard/event-banner-pic.
descriptionRaw jsonb 2147483647 null

Event Description.
location text 2147483647 √ null

Location of the event in string.
locationURL text 2147483647 √ null
CreatorId uuid 2147483647 null
Users.id Events_CreatorId_fkey R
startDate timestamptz 35,6 null

Start Date of event.
endDate timestamptz 35,6 null

End Date of event.
createdAt timestamptz 35,6 now()

Entry creation date
updatedAt timestamptz 35,6 now()

Datetime of last modification to any attribute
isOnline bool 1 false

Boolean on whether event is online.
platform enum_ExpertClasses_platform 2147483647 null
platformURL text 2147483647 √ null

Set to a loket URL if the platform is LOKET, a webinar registration URL if the platform is GLINTS, or null if the platform is ZOOM.
shortId bpchar 8 null

this is for shortening url
deletedAt timestamptz 35,6 √ null
ClassTypeId uuid 2147483647 √ null
ExpertClassClassTypes.id ExpertClasses_ClassTypeId_fkey R

Foreign key, relating to the primary key of ExpertClassClassTypes Table.
languageId uuid 2147483647 null
ExpertClassLanguages.id expertclass_language_fkey R
numberOfSessions int4 10 √ null
promotionalBannerPic varchar 255 √ null
showSpeakerRating bool 1 null

If true show the speaker rating on the clients
showCheaperAppPriceOnWeb bool 1 false

If true show the cheaper app price on web

Indexes

Constraint Name Type Sort Column(s)
Events_pkey Primary key Asc id
Events_updatedAt_idx Performance Asc updatedAt
ExpertClasses_ClassTypeId_idx Performance Asc ClassTypeId
ExpertClasses_createdAt_idx Performance Asc createdAt
ExpertClasses_endDate_idx Performance Asc endDate
ExpertClasses_shortId_key Must be unique Asc shortId
ExpertClasses_startDate_idx Performance Asc startDate
ExpertClasses_title_idx Performance Asc title

Relationships

Close relationships within degrees of separation