announcements


Description

Announcements are messages that can be presented to users e.g. on the homepage.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
announcement_id BIGINT 19 √ null
announcement_settings.announcement_id announcement_settings_announcement_id_foreignC
assoc_type SMALLINT 5 √ NULL
assoc_id BIGINT 19 null
type_id BIGINT 19 √ NULL
announcement_types.type_id announcements_type_id_foreignN
date_expire DATE 10 √ NULL
date_posted DATETIME 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc announcement_id
announcements_assoc Performance Asc/Asc assoc_type + assoc_id
announcements_type_id Performance Asc type_id

Relationships

Close relationships within degrees of separation