per_opslearning

13584 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('per_opslearning_id_seq'::regclass)
per_opslearning_organization.opslearning_id per_opslearning_orga_opslearning_id_59c00afe_fk_per_opsleR
per_opslearning_organization_validated.opslearning_id per_opslearning_orga_opslearning_id_e9b81989_fk_per_opsleR
per_opslearning_per_component.opslearning_id per_opslearning_per__opslearning_id_f868250c_fk_per_opsleR
per_opslearning_per_component_validated.opslearning_id per_opslearning_per__opslearning_id_1ff7f10d_fk_per_opsleR
per_opslearning_sector.opslearning_id per_opslearning_sect_opslearning_id_d7e1f753_fk_per_opsleR
per_opslearning_sector_validated.opslearning_id per_opslearning_sect_opslearning_id_0817580e_fk_per_opsleR
per_opslearningcacheresponse_used_ops_learning.opslearning_id per_opslearningcache_opslearning_id_2909a1b5_fk_per_opsleR
per_opslearningcomponentcacheresponse_used_ops_learning.opslearning_id per_opslearningcompo_opslearning_id_ccea5493_fk_per_opsleR
per_opslearningsectorcacheresponse_used_ops_learning.opslearning_id per_opslearningsecto_opslearning_id_5f4bccec_fk_per_opsleR
learning text 2147483647 √ null
learning_validated text 2147483647 √ null
appeal_code varchar 20 √ null
api_appeal.code per_opslearning_appeal_code_9a170029_fk_api_appeal_codeR
type int4 10 null
type_validated int4 10 null
is_validated bool 1 null
modified_at timestamptz 35,6 null
created_at timestamptz 35,6 null
appeal_document_id int4 10 √ null
learning_ar text 2147483647 √ null
learning_en text 2147483647 √ null
learning_es text 2147483647 √ null
learning_fr text 2147483647 √ null
learning_validated_ar text 2147483647 √ null
learning_validated_en text 2147483647 √ null
learning_validated_es text 2147483647 √ null
learning_validated_fr text 2147483647 √ null
translation_module_original_language varchar 2 null
translation_module_skip_auto_translation bool 1 null

Indexes

Constraint Name Type Sort Column(s)
per_opslearning_pkey Primary key Asc id
per_opslearning_appeal_code_id_0bf6fc9d Performance Asc appeal_code
per_opslearning_appeal_code_id_0bf6fc9d_like Performance Asc appeal_code

Relationships

Close relationships within degrees of separation