app_approval

0 rows


Description

mod_approval; Table to store workflow assignments and assignment overrides

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_approval_id_seq'::regclass)
app_approval_application.approval_id Defined in XML R
app_approval_approver.approval_id Defined in XML R
app_approval_dashboard_application_any.approval_id Defined in XML R
app_approval_dashboard_application_applicant.approval_id Defined in XML R
app_approval_dashboard_draft_application_any.approval_id Defined in XML R
app_approval_dashboard_draft_application_applicant.approval_id Defined in XML R
app_approval_dashboard_pending_application_any.approval_id Defined in XML R
course int8 19 0
app_course.id Defined in XML R
name varchar 1024 ''::character varying
id_number varchar 100 ''::character varying
is_default int2 5 1
assignment_type int2 5 null
assignment_identifier int8 19 null
status int2 5 null
created int8 19 null
updated int8 19 null
to_be_deleted int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_appr_id_pk Primary key Asc id
app_appr_assass_ix Performance Asc/Asc assignment_type + assignment_identifier
app_appr_cou_ix Performance Asc course
app_appr_is__ix Performance Asc is_default
app_appr_sta_ix Performance Asc status

Relationships

Close relationships within degrees of separation