PreviousLearnerPromotionNotifications


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NotificationId uuid 2147483647 null
Notifications.id PreviousLearnerPromotionNotifications_NotificationId_fkey C
expertClassId uuid 2147483647 null
ExpertClasses.id PreviousLearnerPromotionNotifications_expertClassId_fkey R
matchingExpertUserId uuid 2147483647 √ null
Users.id PreviousLearnerPromotionNotifications_matchingExpertUserId_fkey R
matchingCategoryId uuid 2147483647 √ null
ExpertClassCategories.id PreviousLearnerPromotionNotifications_matchingCategoryId_fkey R
daysBeforeClassStart int4 10 null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
PreviousLearnerPromotionNotifications_pkey Primary key Asc NotificationId

Check Constraints

Constraint Name Constraint
PreviousLearnerPromotionNotification_daysBeforeClassStart_check ((("daysBeforeClassStart" = 2) OR ("daysBeforeClassStart" = 4) OR ("daysBeforeClassStart" = 8)))
expert_class_PreviousLearnerPromotionNotifications_matchingExpe (((("matchingExpertUserId" = NULL::uuid) AND ("matchingCategoryId" IS NOT NULL)) OR (("matchingCategoryId" = NULL::uuid) AND ("matchingExpertUserId" IS NOT NULL))))

Relationships

Close relationships within degrees of separation