Prog Completion Log Table Schema (prog_completion_log)


Record of changes made to program completion records

prog_completion_log table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
programid BIGINT 19 null progcomplog_pro2_fk R

Program ID

userid BIGINT 19 null progcomplog_use2_fk R

Users id

changeuserid BIGINT 19 null progcomplog_cha2_fk R

User id of the person who caused the change

description LONGTEXT 2147483647 null

Description of what changed, English only

timemodified BIGINT 19 null

Table contained -1 rows

prog_completion_log table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
progcomplog_cha_ix Performance Asc changeuserid
progcomplog_pro_ix Performance Asc programid
progcomplog_use_ix Performance Asc userid

prog_completion_log table relationships