Notifications


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
AfterCompanyProductSubscriptionPurchaseNotifications.NotificationId AfterCompanyProductSubscriptionPurchaseNoti_NotificationId_fkey C
AfterCreditProductPurchaseOrderNotifications.NotificationId AfterCreditProductPurchaseOrderNotification_NotificationId_fkey C
AfterCreditPurchaseOrderNotifications.NotificationId AfterCreditPurchaseOrderNotifications_NotificationId_fkey C
PreviousLearnerPromotionNotifications.NotificationId PreviousLearnerPromotionNotifications_NotificationId_fkey C
DeletedPostNotifications.NotificationId DeletedPostNotifications_NotificationId_fkey C
GroupDeletionNotifications.NotificationId GroupDeletionNotifications_NotificationId_fkey C
GroupRenameNotifications.NotificationId GroupRenameNotifications_NotificationId_fkey C
MyGroupNewPostsNotifications.NotificationId MyGroupNewPostsNotifications_NotificationId_fkey C
ReactionNotifications.NotificationId ReactionNotifications_NotificationId_fkey C
ReplyNotifications.NotificationId ReplyNotifications_NotificationId_fkey C
ReportNotifications.NotificationId ReportNotifications_NotificationId_fkey C
AfterOrderPaidNotifications.NotificationId AfterOrderPaidNotifications_NotificationId_fkey C
ApplicationStatusNotifications.NotificationId ApplicationStatusNotifications_NotificationId_fkey R
CustomNotifications.NotificationId CustomNotificationContents_NotificationId_fkey C
ExpertApplicationStatusNotifications.NotificationId ExpertApplicationStatusNotifications_NotificationId_fkey C
ExpertClassCertificateGeneratedNotifications.NotificationId ExpertClassCertificateGeneratedNotifications_NotificationId_fke C
ExpertClassReminderNotifications.NotificationId ExpertClassReminderNotifications_NotificationId_fkey C
FollowingNewFollowerNotifications.NotificationId FollowingNewFollowerNotifications_NotificationId_fkey C
NoRecentApplicationStatusNotifications.NotificationId NoRecentApplicationStatusNotifications_NotificationId_fkey C
OdysseyBadgeNotifications.NotificationId OdysseyBadgeNotifications_NotificationId_fkey C
OdysseyMaxApplicationsNotifications.NotificationId OdysseyMaxApplicationsNotifications_NotificationId_fkey C
OdysseyProfileCompletionNotifications.NotificationId OdysseyProfileCompletionNotifications_NotificationId_fkey R
OdysseyWeeklyTargetNotifications.NotificationId OdysseyWeeklyTargetNotifications_NotificationId_fkey C
TalentHuntCandidateApplicationStatusNotifications.NotificationId TalentHuntCandidateApplicationStatusNotific_NotificationId_fkey R
UserJobAlertNotifications.NotificationId UserJobAlertNotifications_NotificationId_fkey C
AnswerNotifications.NotificationId AnswerNotifications_NotificationId_fkey C
AnswerUpvoteNotifications.NotificationId AnswerUpvoteNotifications_NotificationId_fkey C
CommentNotifications.NotificationId CommentNotifications_NotificationId_fkey C
CommentUpvoteNotifications.NotificationId CommentUpvoteNotifications_NotificationId_fkey C
PollVoteNotifications.NotificationId PollVoteNotifications_NotificationId_fkey C
QuestionUpvoteNotifications.NotificationId QuestionUpvoteNotifications_NotificationId_fkey C
RecipientId uuid 2147483647 null
Users.id Notifications_RecipientId_fkey R
type enum_Notification_type 2147483647 null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 √ null
isRead bool 1 false
isNew bool 1 true

Indexes

Constraint Name Type Sort Column(s)
Notifications_pkey Primary key Asc id
Notifications_createdAt_idx Performance Asc createdAt
Notifications_isRead_idx Performance Asc isRead
Notifications_RecipientId_idx Performance Asc RecipientId
Notifications_type_idx Performance Asc type

Relationships

Close relationships within degrees of separation