alert

31 rows


Description

Create by KenG (2020/03/17), Alert to page of front-end

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
alert_user.alert_id fk_alert_user_alert_id C
alert_type t_alert_type 2147483647 null

This alert command from where this value, data type enum(followup)
alert_date date 13 √ null
alert_page_id int4 10 null
alert_page.id fk_alert_alert_page_id R

Indexes

Constraint Name Type Sort Column(s)
pk_alert Primary key Asc id
idx_alert_alert_date Performance Asc alert_date
idx_alert_alert_page_id Performance Asc alert_page_id
idx_alert_alert_type Performance Asc alert_type

Relationships

Close relationships within degrees of separation