0 rows


type, status, and workflow additions to messages


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


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

Diagram producer might be missing

No diagrams were produced please see application output for any errors