app_prog_messagelog

0 rows


Description

Stores details of program-related messages that have been issued to a user

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_prog_messagelog_id_seq'::regclass)
messageid int8 19 0
app_prog_message.id Defined in XMLR
userid int8 19 0
app_user.id Defined in XMLR
coursesetid int8 19 0
app_prog_courseset.id Defined in XMLR
timeissued int8 19 0

Indexes

Constraint Name Type Sort Column(s)
app_progmess_id3_pk Primary key Asc id
app_progmess_cou2_ix Performance Asc coursesetid
app_progmess_cou_ix Performance Asc coursesetid
app_progmess_mes2_ix Performance Asc messageid
app_progmess_mes_ix Performance Asc messageid
app_progmess_use2_ix Performance Asc userid
app_progmess_use_ix Performance Asc userid

Relationships

Close relationships within degrees of separation