app_prog_extension

0 rows


Description

Stores extension requests for programs

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_prog_extension_id_seq'::regclass)
programid int8 19 0
app_prog.id Defined in XMLR
userid int8 19 0
app_user.id Defined in XMLR
extensiondate int8 19 0
extensionreason text 2147483647 null
status int2 5 0
reasonfordecision text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
app_progexte_id_pk Primary key Asc id
app_progexte_pro2_ix Performance Asc programid
app_progexte_pro_ix Performance Asc programid
app_progexte_use2_ix Performance Asc userid
app_progexte_use_ix Performance Asc userid

Relationships