Prog Message Table Schema (prog_message)


Description

Stores details of the messages defined within a program

prog_message table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
prog_messagelog.messageid progmess_mes3_fk R
programid BIGINT 19 0
prog.id progmess_pro3_fk R
messagetype SMALLINT 5 0
sortorder BIGINT 19 0
messagesubject VARCHAR 255
mainmessage LONGTEXT 2147483647 null
notifymanager BIT 0 0
managersubject VARCHAR 255
managermessage LONGTEXT 2147483647 null
triggertime BIGINT 19 0

Table contained -1 rows

prog_message table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
progmess_pro2_ix Performance Asc programid
progmess_pro_ix Performance Asc programid

prog_message table relationships