sow_tab_2

-1 rows


Description

Table containing the detailed budget data for the given SoW

Columns

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

Unique ID for the SoW detailed budget record
sow_id int4 10 √ null
application_sow_data.id sow_tab_2_sow_id_fkey R

ID of the SoW
json_data jsonb 2147483647 '{}'::jsonb

The data imported from the Excel filled by the respondent. See schema
created_by int4 10 √ null
ccbc_user.id sow_tab_2_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 sow_tab_2_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 sow_tab_2_archived_by_fkey R

archived by user id
archived_at timestamptz 35,6 √ null

archived at timestamp

Indexes

Constraint Name Type Sort Column(s)
sow_tab_2_pkey Primary key Asc id
ccbc_public_sow_tab_2_archived_by_foreign_key Performance Asc archived_by
ccbc_public_sow_tab_2_created_by_foreign_key Performance Asc created_by
ccbc_public_sow_tab_2_updated_by_foreign_key Performance Asc updated_by
sow_tab_2_sow_id_index Performance Asc sow_id

Relationships

Close relationships within degrees of separation