Prog Exception Table Schema (prog_exception)


Description

Stores details of any exceptions raised relating to a program

prog_exception table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
programid BIGINT 19 0
prog.id progexce_pro3_fk R
exceptiontype SMALLINT 5 0
userid BIGINT 19 0
user.id progexce_use3_fk R
timeraised BIGINT 19 0
assignmentid BIGINT 19 0

Table contained -1 rows

prog_exception table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
progexce_exc_ix Performance Asc exceptiontype
progexce_pro2_ix Performance Asc programid
progexce_pro_ix Performance Asc programid
progexce_use2_ix Performance Asc userid
progexce_use_ix Performance Asc userid

prog_exception table relationships

Close relationships within degrees of separation