Prog Extension Table Schema (prog_extension)


Description

Stores extension requests for programs

prog_extension table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
programid BIGINT 19 0
prog.id progexte_pro3_fk R
userid BIGINT 19 0
user.id progexte_use3_fk R
extensiondate BIGINT 19 0
extensionreason LONGTEXT 2147483647 √ null
status SMALLINT 5 0
reasonfordecision LONGTEXT 2147483647 √ null

Table contained -1 rows

prog_extension table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
progexte_pro2_ix Performance Asc programid
progexte_pro_ix Performance Asc programid
progexte_use2_ix Performance Asc userid
progexte_use_ix Performance Asc userid

prog_extension table relationships

Close relationships within degrees of separation