application

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('application_id_seq'::regclass)
application_response.application_id application_response_application_id_fkeyR
application_section.application_id application_section_application_id_fkeyR
application_stage_history.application_id application_stage_history_application_id_fkeyR
notification.application_id notification_application_id_fkeyR
review.application_id review_application_id_fkeyR
review_assignment.application_id review_assignment_application_id_fkeyR
verification.application_id verification_application_id_fkeyR
template_id int4 10 √ null
template.id application_template_id_fkeyR
user_id int4 10 √ null
user.id application_user_id_fkeyR
org_id int4 10 √ null
organisation.id application_org_id_fkeyR
session_id varchar 2147483647 √ null
serial varchar 2147483647 √ null
file.application_serial file_application_serial_fkeyR
name varchar 2147483647 √ null
outcome application_outcome 2147483647 √ null
is_active bool 1 √ null
trigger trigger 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
application_pkey Primary key Asc id
application_serial_key Must be unique Asc serial

Relationships

Close relationships within degrees of separation