il_adn_notifications

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
title VARCHAR 256 √ null
body LONGTEXT 2147483647 √ null
type TINYINT 3 √ null
type_during_event TINYINT 3 √ null
dismissable TINYINT 3 √ null
permanent TINYINT 3 √ null
allowed_users VARCHAR 256 √ null
parent_id BIGINT 19 √ null
created_by BIGINT 19 √ null
last_update_by BIGINT 19 √ null
active TINYINT 3 √ null
limited_to_role_ids VARCHAR 256 √ null
limit_to_roles TINYINT 3 √ null
interruptive TINYINT 3 √ null
link VARCHAR 256 √ null
link_type TINYINT 3 √ null
link_target VARCHAR 256 √ null
event_start BIGINT 19 √ 0
event_end BIGINT 19 √ 0
display_start BIGINT 19 √ 0
display_end BIGINT 19 √ 0
create_date BIGINT 19 √ 0
last_update BIGINT 19 √ 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Diagram producer might be missing

No diagrams were produced please see application output for any errors