cbc_application_pending_change_request

-1 rows


Description

Table containing the pending change request details of the application

Columns

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

Unique ID for the cbc_application_pending_change_request
cbc_id int4 10 √ null
cbc.id cbc_application_pending_change_request_cbc_id_fkey R

ID of the cbc application this cbc_application_pending_change_request belongs to
is_pending bool 1 √ false

Column defining if the change request pending or not
comment varchar 100 √ null

Column containing the comment for the change request or completion of the change request
created_by int4 10 √ null
ccbc_user.id cbc_application_pending_change_request_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 cbc_application_pending_change_request_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 cbc_application_pending_change_request_archived_by_fkey R

archived by user id
archived_at timestamptz 35,6 √ null

archived at timestamp

Indexes

Constraint Name Type Sort Column(s)
cbc_application_pending_change_request_pkey Primary key Asc id
ccbc_public_cbc_application_pending_change_request_archived_by_ Performance Asc archived_by
ccbc_public_cbc_application_pending_change_request_created_by_f Performance Asc created_by
ccbc_public_cbc_application_pending_change_request_updated_by_f Performance Asc updated_by

Relationships

Close relationships within degrees of separation