announcements


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
announcement_attachments.announcement_id fk_announcement_attachments_announcement C
announcement_recipients.announcement_id fk_announcement_recipients_announcement C
announcement_targets.announcement_id fk_announcement_targets_announcement C
title VARCHAR 200 null
message LONGTEXT 2147483647 null
priority INT 10 null
audience_type VARCHAR 50 √ null
start_datetime DATETIME 19 null
end_datetime DATETIME 19 √ null
is_active BIT 1 1
created_at TIMESTAMP 19 √ CURRENT_TIMESTAMP
updated_at TIMESTAMP 19 √ CURRENT_TIMESTAMP
created_by VARCHAR 100 null
updated_by VARCHAR 100 √ null
location_business_line_id VARCHAR 36 √ null
channel_email BIT 1 0
channel_sms BIT 1 0
channel_notification BIT 1 0
status VARCHAR 30 DRAFT
scheduled_for DATETIME 26 √ null
sent_at DATETIME 26 √ null
recipient_count INT 10 0
success_count INT 10 0
failure_count INT 10 0
sent_by VARCHAR 255 √ null
duplicated_from_id VARCHAR 36 √ null
audience_summary VARCHAR 500 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_announcements_active Performance Asc is_active
idx_announcements_dates Performance Asc/Asc start_datetime + end_datetime
idx_announcements_scheduled Performance Asc scheduled_for
idx_announcements_status Performance Asc status

Relationships

Close relationships within degrees of separation