new_releases


Description

Information about which submissions in the press are considered new releases.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
new_release_id BIGINT UNSIGNED 20 null
submission_id BIGINT 19 null
submissions.submission_id new_releases_submission_idC
assoc_type BIGINT 19 null
assoc_id BIGINT 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc new_release_id
new_releases_submission_id Performance Asc submission_id
new_releases_unique Must be unique Asc/Asc/Asc assoc_type + assoc_id + submission_id

Relationships