app_message_metadata

0 rows


Description

type, status, and workflow additions to messages

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_message_metadata_id_seq'::regclass)
messageid int8 19 null
msgtype int2 5 null
msgstatus int2 5 null
processorid int2 5 null
urgency int2 5 null
icon varchar 255 null
onaccept text 2147483647 null
onreject text 2147483647 null
oninfo text 2147483647 null
messagereadid int8 19 null
notificationid int8 19 null
timeread int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_messmeta_id_pk Primary key Asc id
app_messmeta_notpro_uix Must be unique Asc/Asc notificationid + processorid

Relationships