application_gis_assessment_hh

-1 rows


Description

Table containing data for the gis assessment hh numbers

Columns

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

Primary key and unique identifier
application_id int4 10 null
application.id application_gis_assessment_hh_application_id_fkey R

The application_id of the application this record is associated with
eligible float4 8,8 √ null

The number of eligible households
eligible_indigenous float4 8,8 √ null

The number of eligible indigenous households
created_by int4 10 √ null
ccbc_user.id application_gis_assessment_hh_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_gis_assessment_hh_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_gis_assessment_hh_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_gis_assessment_hh_pkey Primary key Asc id
ccbc_public_application_gis_assessment_hh_archived_by_foreign_k Performance Asc archived_by
ccbc_public_application_gis_assessment_hh_created_by_foreign_ke Performance Asc created_by
ccbc_public_application_gis_assessment_hh_updated_by_foreign_ke Performance Asc updated_by

Relationships

Close relationships within degrees of separation