notification_template


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
notification.footer_id FK_j8g0fcd5tw3dckw7tsovwgfeb R
notification.header_id FK_hr7dbrrvix0i7jd8ifyaqr01t R
notification_scheduled.footer_id FK_ctg40om1eemknmfvieoe4quc9 R
notification_scheduled.header_id FK_6ehdtpn8lajfu5bgssnpxu1o3 R
active BIT 1 b'1'
created_by_id INT 10 √ null
sys_users.user_id FK_1h5yj7tft18qlxff1s3wxs2vx R
date_created DATETIME 19 null
description VARCHAR 255 √ null
last_updated DATETIME 19 null
name VARCHAR 100 null
rtf_body LONGTEXT 2147483647 null
txt_body LONGTEXT 2147483647 null
type INT 10 null
sys_monitor_types.type Implied Constraint R
updated_by_id INT 10 √ null
sys_users.user_id FK_9jm491wa0asv8i9ol6wywq3b2 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_1h5yj7tft18qlxff1s3wxs2vx Performance Asc created_by_id
FK_9jm491wa0asv8i9ol6wywq3b2 Performance Asc updated_by_id
UK_2hkvijod8b8id26qum26cstr Must be unique Asc name

Relationships

Close relationships within degrees of separation