per_formcomponent

51 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('per_formcomponent_id_seq'::regclass)
per_formcomponent_question_responses.formcomponent_id per_formcomponent_qu_formcomponent_id_2f3fb925_fk_per_formcR
per_formcomponentresponse.component_id per_formcomponentres_component_id_5fda4f05_fk_per_formcR
per_formprioritizationcomponent.component_id per_formprioritizati_component_id_9ed47a91_fk_per_formcR
per_formquestion.component_id per_formquestion_component_id_67a7e356_fk_per_formcomponent_idR
per_formquestiongroup.component_id per_formquestiongrou_component_id_2cb3d55f_fk_per_formcR
per_opslearning_per_component.formcomponent_id per_opslearning_per__formcomponent_id_4ba7b9db_fk_per_formcR
per_opslearning_per_component_validated.formcomponent_id per_opslearning_per__formcomponent_id_354b1858_fk_per_formcR
per_opslearningcomponentcacheresponse.component_id per_opslearningcompo_component_id_92c00dd4_fk_per_formcR
per_perworkplancomponent.component_id per_perworkplancompo_component_id_b6481828_fk_per_formcR
title varchar 250 null
component_num int4 10 null
description text 2147483647 √ null
area_id int4 10 null
per_formarea.id per_formcomponent_area_id_e95ba298_fk_per_formarea_idR
component_letter varchar 3 √ null
description_ar text 2147483647 √ null
description_en text 2147483647 √ null
description_es text 2147483647 √ null
description_fr text 2147483647 √ null
title_ar varchar 250 √ null
title_en varchar 250 √ null
title_es varchar 250 √ null
title_fr varchar 250 √ null
translation_module_original_language varchar 2 null
translation_module_skip_auto_translation bool 1 null
status varchar 100 √ null
is_parent bool 1 √ null
has_question_group bool 1 √ null
climate_environmental_considerations_guidance text 2147483647 null
climate_environmental_considerations_guidance_ar text 2147483647 √ null
climate_environmental_considerations_guidance_en text 2147483647 √ null
climate_environmental_considerations_guidance_es text 2147483647 √ null
climate_environmental_considerations_guidance_fr text 2147483647 √ null
epi_considerations_guidance text 2147483647 null
epi_considerations_guidance_ar text 2147483647 √ null
epi_considerations_guidance_en text 2147483647 √ null
epi_considerations_guidance_es text 2147483647 √ null
epi_considerations_guidance_fr text 2147483647 √ null
urban_considerations_guidance text 2147483647 null
urban_considerations_guidance_ar text 2147483647 √ null
urban_considerations_guidance_en text 2147483647 √ null
urban_considerations_guidance_es text 2147483647 √ null
urban_considerations_guidance_fr text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
per_formcomponent_pkey Primary key Asc id
per_formcomponent_area_id_e95ba298 Performance Asc area_id

Relationships

Close relationships within degrees of separation