CMSContentOverallScores


Description

This table is used to store the CMS overall score of each content.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()

Primary Key.

ContentId uuid 2147483647 null
Contents.id CMSContentOverallScores_ContentId_fkey C

Foreign Key to the Content table.

overallScore float8 17,17 √ null

Overall score. Is calculated based on the individual parameter scores and the method setting.

createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
CMSContentOverallScores_pkey Primary key Asc id
gcud_CMSContentOverallScores_ContentId_idx Performance Asc ContentId

Relationships