sys_alert


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
notification_user_message.system_alert_id FK_2nxvx0pkde0ut7gowyqw0c31r R
sys_alert_attachment.system_alert_id FK_lk24wpdh9m31rbg8yfap0wgjm R
version BIGINT 19 null
create_date DATETIME 23 null
created_by_user_id INT 10 null
sys_users.user_id FK_idn65a84bh2xkulh8glvqlvni R
expiration_date DATETIME 19 √ null
has_body BIT 1 null
message_id BIGINT 19 √ null
message.id FK_1coo2tnsi3751ojc76c7ggi1 R
subject VARCHAR 128 null
total_sent INT 10 √ null
total_dismissed INT 10 √ null
body MEDIUMTEXT 16777215 √ null
publish_date DATETIME 19 √ null
status_id INT 10 null
to_roles LONGTEXT 2147483647 √ null
total_read INT 10 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_1coo2tnsi3751ojc76c7ggi1 Performance Asc message_id
FK_idn65a84bh2xkulh8glvqlvni Performance Asc created_by_user_id

Relationships

Close relationships within degrees of separation