features


Description

Information about which submissions are featured in the press.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
feature_id BIGINT UNSIGNED 20 null
submission_id BIGINT 19 null
submissions.submission_id features_submission_id_foreignC
assoc_type BIGINT 19 null
assoc_id BIGINT 19 null
seq BIGINT 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc feature_id
features_submission_id Performance Asc submission_id
press_features_unique Must be unique Asc/Asc/Asc assoc_type + assoc_id + submission_id

Relationships