spotlights


Description

Information about which submissions to the press are spotlighted.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
spotlight_id BIGINT 19 √ null
spotlight_settings.spotlight_id spotlight_settings_spotlight_id_foreignR
assoc_type SMALLINT 5 null
assoc_id SMALLINT 5 null
press_id BIGINT 19 null
presses.press_id spotlights_press_id_foreignC

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc spotlight_id
spotlights_assoc Performance Asc/Asc assoc_type + assoc_id
spotlights_press_id Performance Asc press_id

Relationships

Close relationships within degrees of separation