cbc_data_change_reason

-1 rows


Description

Table containing the reasons for changes to cbc_data

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('ccbc_public.cbc_data_change_reason_id_seq'::regclass)

Unique ID for the cbc_data_change_reason
cbc_data_id int4 10 null
cbc_data.id cbc_data_change_reason_cbc_data_id_fkey R

ID of the cbc_data this cbc_data_change_reason belongs to
description text 2147483647 √ null

The reason for the change to the cbc_data
created_by int4 10 √ null
ccbc_user.id cbc_data_change_reason_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_data_change_reason_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_data_change_reason_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_data_change_reason_pkey Primary key Asc id
ccbc_public_cbc_data_change_reason_archived_by_foreign_key Performance Asc archived_by
ccbc_public_cbc_data_change_reason_created_by_foreign_key Performance Asc created_by
ccbc_public_cbc_data_change_reason_updated_by_foreign_key Performance Asc updated_by

Relationships

Close relationships within degrees of separation