application_project_type

-1 rows


Description

Table containing the project type of the application

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null

Unique ID for the application_project_type
application_id int4 10 √ null
application.id application_project_type_application_id_fkey R

ID of the application this application_project_type belongs to
project_type varchar 20 √ null

Column containing the project type of the application
created_by int4 10 √ null
ccbc_user.id application_project_type_created_by_fkey R

created by user id
created_at timestamptz 35,6 now()

created at timestamp
updated_by int4 10 √ null
ccbc_user.id application_project_type_updated_by_fkey R

updated by user id
updated_at timestamptz 35,6 now()

updated at timestamp
archived_by int4 10 √ null
ccbc_user.id application_project_type_archived_by_fkey R

archived by user id
archived_at timestamptz 35,6 √ null

archived at timestamp

Indexes

Constraint Name Type Sort Column(s)
application_project_type_pkey Primary key Asc id
ccbc_public_application_project_type_archived_by_foreign_key Performance Asc archived_by
ccbc_public_application_project_type_created_by_foreign_key Performance Asc created_by
ccbc_public_application_project_type_updated_by_foreign_key Performance Asc updated_by

Check Constraints

Constraint Name Constraint
application_project_type_project_type_check ((((project_type)::text = ANY ((ARRAY['lastMile'::character varying, 'lastMileAndTransport'::character varying])::text[])) OR (project_type IS NULL)))

Relationships

Close relationships within degrees of separation