per_formcomponentresponse

21821 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('per_formcomponentresponse_id_seq'::regclass)
per_arearesponse_component_response.formcomponentresponse_id per_arearesponse_com_formcomponentrespons_60d67ee4_fk_per_formcR
per_formcomponentresponse_question_responses.formcomponentresponse_id per_formcomponentres_formcomponentrespons_5ed1af43_fk_per_formcR
component_id int4 10 null
per_formcomponent.id per_formcomponentres_component_id_5fda4f05_fk_per_formcR
rating_id int4 10 √ null
per_percomponentrating.id per_formcomponentres_rating_id_0d5fc76e_fk_per_percoR
climate_environmental_considerations text 2147483647 √ null
epi_considerations text 2147483647 √ null
urban_considerations text 2147483647 √ null
notes text 2147483647 √ null
climate_environmental_considerations_ar text 2147483647 √ null
climate_environmental_considerations_en text 2147483647 √ null
climate_environmental_considerations_es text 2147483647 √ null
climate_environmental_considerations_fr text 2147483647 √ null
epi_considerations_ar text 2147483647 √ null
epi_considerations_en text 2147483647 √ null
epi_considerations_es text 2147483647 √ null
epi_considerations_fr text 2147483647 √ null
notes_ar text 2147483647 √ null
notes_en text 2147483647 √ null
notes_es text 2147483647 √ null
notes_fr text 2147483647 √ null
translation_module_original_language varchar 2 null
translation_module_skip_auto_translation bool 1 null
urban_considerations_ar text 2147483647 √ null
urban_considerations_en text 2147483647 √ null
urban_considerations_es text 2147483647 √ null
urban_considerations_fr text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
per_formcomponentresponse_pkey Primary key Asc id
per_formcomponentresponse_component_id_5fda4f05 Performance Asc component_id
per_formcomponentresponse_rating_id_0d5fc76e Performance Asc rating_id

Relationships

Close relationships within degrees of separation