notification

446 rows


Description

Create by KenG (2020/03/17), Notify to user, Base on user

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
notify_type t_notify_type 2147483647 null

This notify command from where this value, data type enum(followup,general,booking)

notify_date timestamptz 35,6 null
notify_user text 2147483647 null
notify_titile text 2147483647 null
notify_message text 2147483647 null
ref_id int4 10 null
create_user text 2147483647 null
profile_user text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
pk_notification Primary key Asc id
idx_notification_notify_date Performance Asc notify_date
idx_notification_notify_type Performance Asc notify_type
idx_notification_notify_user Performance Asc notify_user

Relationships