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