app_prog_message

0 rows


Description

Stores details of the messages defined within a program

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_prog_message_id_seq'::regclass)
app_prog_messagelog.messageid Defined in XMLR
programid int8 19 0
app_prog.id Defined in XMLR
messagetype int2 5 0
sortorder int8 19 0
messagesubject varchar 255 ''::character varying
mainmessage text 2147483647 null
notifymanager int2 5 0
managermessage text 2147483647 null
triggertime int8 19 0

Indexes

Constraint Name Type Sort Column(s)
app_progmess_id_pk Primary key Asc id
app_progmess_pro2_ix Performance Asc programid
app_progmess_pro_ix Performance Asc programid

Relationships