Prog Completion Log Table Schema (prog_completion_log)


Description

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
prog.id progcomplog_pro2_fk R

Program ID
userid BIGINT 19 √ null
user.id progcomplog_use2_fk R

Users id
changeuserid BIGINT 19 √ null
user.id 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

Close relationships within degrees of separation