BlackListedContents


Description

Monitored contents table, contains all the flagged contents which is reported by CMS moderation system or user.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
BlackListedContentBlackListedWords.BlackListedContentId BlackListedContentBlackListedWords_BlackListedContentId_fkey C

Primary Key.
reportedBy enum_BlackListedContents_reportedBy 2147483647 null

Reported by user or system.
ContentId uuid 2147483647 null
Contents.id BlackListedContents_ContentId_fkey C

Foreign key, reference to gcud.“Contents”.
ReporterId uuid 2147483647 √ null
Users.id BlackListedContents_ReporterId_fkey N

Foreign key, reference to “Users” table, the user who reported the content.
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
BlackListedContents_pkey Primary key Asc id
gcud_BlackListedContents_ContentId_idx Performance Asc ContentId
gcud_BlackListedContents_createdAt_idx Performance Asc createdAt
gcud_BlackListedContents_reportedBy_idx Performance Asc reportedBy

Relationships

Close relationships within degrees of separation