Contents


Description

Contents table, a super table to be extended by all the content related tables.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
Attachments.ContentId Attachments_ContentId_fkey C
Attachments.id Attachments_id_fkey C
BlackListedContents.ContentId BlackListedContents_ContentId_fkey C
Bookmarks.ContentId Bookmarks_ContentId_fkey C
CMSContentOverallScores.ContentId CMSContentOverallScores_ContentId_fkey C
ContentScores.ContentId ContentScores_ContentId_fkey C
Posts.id Posts_id_fkey C
Reactions.ContentId Reactions_ContentId_fkey C
Replies.id Replies_id_fkey C
Replies.RootContentId Replies_RootContentId_fkey C
ReportedUsers.ContentId ReportedUsers_ContentId_fkey C

Primary Key, also being PK and FK of sub tables.
type "gcud"."enum_Contents_type" 2147483647 null

Sub table type.

Indexes

Constraint Name Type Sort Column(s)
Contents_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation