app_prog_message

0 rows

Description

Stores details of the messages defined within a program

Columns

Related columns Constraint Comments

Search:

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 XML

R

programid

int8

19

0

Defined in XML

R

messagetype

int2

5

0

sortorder

int8

19

0

messagesubject

varchar

255

√

''::character varying

mainmessage

text

2147483647

null

notifymanager

int2

5

0

managersubject

varchar

255

√

''::character varying

managermessage

text

2147483647

√

null

triggertime

int8

19

0

Showing 1 to 10 of 10 entries

Indexes

Search:

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

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
Two degrees