app_prog_exception

0 rows


Description

Stores details of any exceptions raised relating to a program

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_prog_exception_id_seq'::regclass)
programid int8 19 0
app_prog.id Defined in XMLR
exceptiontype int2 5 0
userid int8 19 0
app_user.id Defined in XMLR
timeraised int8 19 0
assignmentid int8 19 0

Indexes

Constraint Name Type Sort Column(s)
app_progexce_id_pk Primary key Asc id
app_progexce_exc_ix Performance Asc exceptiontype
app_progexce_pro2_ix Performance Asc programid
app_progexce_pro_ix Performance Asc programid
app_progexce_use2_ix Performance Asc userid
app_progexce_use_ix Performance Asc userid

Relationships

Close relationships within degrees of separation