notification


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
activity_log_action.notification_id FK7AF596C1801340C3 R
notification_action.notification_id FK2770240A801340C3 R
notification_attachment.notification_id FK808F4F7801340C3 R
notification_data_classification.notification_id FK_8wb6bp7s880a7ooyqk99ccvw3 R
notification_owner.notification_id FKA73D425F801340C3 R
notification_sent_action.notification_id FK_7hr775by2ha5k2ykco652ub2f R
program_message.notification_id FK_6wniwfjpewmvourdrllhvldby R
project_message.notification_id FKAA3EC8E1801340C3 R
v_all_actions.notificationId Implied Constraint R
version BIGINT 19 null
active BIT 1 null
body LONGTEXT 2147483647 null
cc_addresses TEXT 65535 √ null
cc_roles VARCHAR 1000 √ null
date_created DATETIME 19 null
description VARCHAR 255 √ null
last_updated DATETIME 19 null
name VARCHAR 100 null
subject VARCHAR 255 null
to_addresses TEXT 65535 √ null
to_roles VARCHAR 1000 √ null
exclude_addresses LONGTEXT 2147483647 √ null
from VARCHAR 255 √ null
rich_text BIT 1 null
bcc_addresses LONGTEXT 2147483647 √ null
bcc_roles VARCHAR 1000 √ null
complete_on_send_id INT 10 √ null
milestone_tasks.task_id FK237A88EB1EE1B683 R
query_addresses LONGTEXT 2147483647 √ null
error_code INT 10 √ null
footer_id BIGINT 19 √ null
notification_template.id FK_j8g0fcd5tw3dckw7tsovwgfeb R
header_id BIGINT 19 √ null
notification_template.id FK_hr7dbrrvix0i7jd8ifyaqr01t R
project_field_ids LONGTEXT 2147483647 √ null
last_scheduled_run DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK237A88EB1EE1B683 Performance Asc complete_on_send_id
FK_hr7dbrrvix0i7jd8ifyaqr01t Performance Asc header_id
FK_j8g0fcd5tw3dckw7tsovwgfeb Performance Asc footer_id

Relationships

Close relationships within degrees of separation