app_approval_application_submission

0 rows


Description

Table to store application form submissions

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_approval_application_submission_id_seq'::regclass)
application_id int8 19 null
app_approval_application.id Defined in XML R
user_id int8 19 null
app_user.id Defined in XML R
workflow_stage_id int8 19 null
app_approval_workflow_stage.id Defined in XML R
created int8 19 null
updated int8 19 null
submitted int8 19 √ null
superseded int2 5 0
form_data text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
app_apprapplsubm_id_pk Primary key Asc id
app_apprapplsubm_app_ix Performance Asc application_id
app_apprapplsubm_sup_ix Performance Asc superseded
app_apprapplsubm_use_ix Performance Asc user_id
app_apprapplsubm_wor_ix Performance Asc workflow_stage_id

Relationships

Close relationships within degrees of separation