Prog Messagelog Table Schema (prog_messagelog)


Description

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

prog_messagelog table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
messageid BIGINT 19 0
prog_message.id progmess_mes3_fk R
userid BIGINT 19 0
user.id progmess_use3_fk R
coursesetid BIGINT 19 0
prog_courseset.id progmess_cou3_fk R
timeissued BIGINT 19 0

Table contained -1 rows

prog_messagelog table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
progmess_cou2_ix Performance Asc coursesetid
progmess_cou_ix Performance Asc coursesetid
progmess_mes2_ix Performance Asc messageid
progmess_mes_ix Performance Asc messageid
progmess_use2_ix Performance Asc userid
progmess_use_ix Performance Asc userid

prog_messagelog table relationships

Close relationships within degrees of separation