Constraints

74 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fk_id_accion
accion_dom_tipo_intervencion_ecologica.id_accion_fk
accion.id
Restrict delete
fk_id_dom_tipo_intervencion_ecologica
accion_dom_tipo_intervencion_ecologica.id_dom_tipo_intervencion_ecologica_fk
dom_tipo_intervencion_ecologica.id
Restrict delete
fk_id_usuario
usuario_rol.id_usuario_fk
usuario.id
Restrict delete
fk_id_rol
usuario_rol.id_rol_fk
rol.id
Restrict delete
fk_medida_eje
medida.id_eje_fk
eje.id
Restrict delete
fk_mdle_dom_lineaestrategica
medida_dom_lineaestrategica_pncc.id_dom_lineaestrategica_pncc_fk
dom_lineaestrategica_pncc.id
Restrict delete
fk_mdle_medida
medida_dom_lineaestrategica_pncc.id_medida_fk
medida.id
Cascade on delete
fk_id_accion
evento.id_accion_fk
accion.id
Restrict delete
fk_id_usuario
evento.id_usuario_fk
usuario.id
Restrict delete
fk_id_seguimiento
evento.id_seguimiento_fk
seguimiento.id
Restrict delete
fk_id_accion
metrica_accion.id_accion_fk
accion.id
Restrict delete
fk_id_metrica
metrica_accion.id_metrica_fk
metrica.id
Restrict delete
fk_id_municipio
metrica_accion.id_municipio_fk
municipio.id
Restrict delete
fk_id_departamento
entidad.id_departamento_fk
departamento.id
Restrict delete
fk_id_accion
accion_dom_enfoque_productivo.id_accion_fk
accion.id
Restrict delete
fk_dom_enfoque_productivo
accion_dom_enfoque_productivo.id_dom_enfoque_productivo_fk
dom_enfoque_productivo.id
Restrict delete
fk_mdo_medida
medida_dom_ods.id_medida_fk
medida.id
Cascade on delete
fk_mdo_dom_ods
medida_dom_ods.id_dom_ods_fk
dom_ods.id
Restrict delete
fk_id_accion
accion_dom_tipo_solucion_adaptacion.id_accion_fk
accion.id
Restrict delete
fk_id_dom_tipo_solucion_adaptacion
accion_dom_tipo_solucion_adaptacion.id_dom_tipo_solucion_adaptacion_fk
dom_tipo_solucion_adaptacion.id
Restrict delete
fk_id_indicador_accion
seguimiento.id_indicador_accion_fk
indicador_accion.id
Restrict delete
fk_municipio_departamento
municipio.id_departamento_fk
departamento.id
Restrict delete
fk_id_accion
observacion_accion.id_accion_fk
accion.id
Restrict delete
fk_id_usuario
observacion_accion.id_usuario_fk
usuario.id
Restrict delete
fk_id_dom_instrumento_planificacion
accion_dom_instrumento_planificacion.id_dom_instrumento_planificacion_fk
dom_instrumento_planificacion.id
Restrict delete
fk_id_accion
accion_dom_instrumento_planificacion.id_accion_fk
accion.id
Restrict delete
fk_id_accion
grupo_poblacional_accion.id_accion_fk
accion.id
Restrict delete
fk_id_municipio
grupo_poblacional_accion.id_municipio_fk
municipio.id
Restrict delete
fk_id_accion
ecosistema_accion.id_accion_fk
accion.id
Restrict delete
fk_id_ecosistema
ecosistema_accion.id_ecosistema_fk
ecosistema.id
Restrict delete
fk_mdm_dom_medio
medida_dom_medio_implem.id_dom_medio_implem_fk
dom_medio_implem.id
Restrict delete
fk_mdm_medida
medida_dom_medio_implem.id_medida_fk
medida.id
Cascade on delete
fk_eje_pigcct
eje.id_pigcct_fk
pigcct.id
Restrict delete
fk_id_permiso
rol_permiso.id_permiso_fk
permiso.id
Restrict delete
fk_id_rol
rol_permiso.id_rol_fk
rol.id
Restrict delete
fk_mdli_medida
medida_dom_lineainstrumental_pncc.id_medida_fk
medida.id
Cascade on delete
fk_mdli_dom_lineainstrumental
medida_dom_lineainstrumental_pncc.id_dom_lineainstrumental_pncc_fk
dom_lineainstrumental_pncc.id
Restrict delete
fk_id_accion
beneficiario_accion.id_accion_fk
accion.id
Restrict delete
fk_id_municipio
beneficiario_accion.id_municipio_fk
municipio.id
Restrict delete
fk_id_accion
accion_dom_subzona_hidrografica.id_accion_fk
accion.id
Restrict delete
fk_id_dom_subzona_hidrografica
accion_dom_subzona_hidrografica.id_dom_subzona_hidrografica_fk
dom_subzona_hidrografica.id
Restrict delete
fk_id_dom_area_protegida
accion_dom_area_protegida.id_dom_area_protegida_fk
dom_area_protegida.id
Restrict delete
fk_id_accion
accion_dom_area_protegida.id_accion_fk
accion.id
Restrict delete
fk_mdd_dom_dimension
medida_dom_dimension.id_dom_dimension_fk
dom_dimension.id
Restrict delete
fk_mdd_medida
medida_dom_dimension.id_medida_fk
medida.id
Cascade on delete
fk_id_dom_ecosistema
ecosistema.id_dom_ecosistema_fk
dom_ecosistema.id
Restrict delete
fk_id_medida
metrica.id_medida_fk
medida.id
Restrict delete
fk_id_accion
fuente_financiacion_accion.id_accion_fk
accion.id
Restrict delete
fk_id_municipio
fuente_financiacion_accion.id_municipio_fk
municipio.id
Restrict delete
fk_id_dom_tipo_fuente_recursos
fuente_financiacion_accion.id_dom_tipo_fuente_recursos_fk
dom_tipo_fuente_recursos.id
Restrict delete
fk_id_pigcct
usuario_pigcct.id_pigcct_fk
pigcct.id
Restrict delete
fk_id_usuario
usuario_pigcct.id_usuario_fk
usuario.id
Restrict delete
fk_id_usuario
accion.id_usuario_fk
usuario.id
Restrict delete
fk_id_usuario_validador
accion.id_usuario_validador_fk
usuario.id
Restrict delete
fk_id_accion
accion_dom_mitigacion_gei.id_accion_fk
accion.id
Restrict delete
fk_dom_mitigacion_gei
accion_dom_mitigacion_gei.id_dom_mitigacion_gei_fk
dom_mitigacion_gei.id
Restrict delete
fk_mde_medida
medida_dom_enfoque.id_medida_fk
medida.id
Cascade on delete
fk_mde_dom_enfoque
medida_dom_enfoque.id_dom_enfoque_fk
dom_enfoque.id
Restrict delete
fk_municipio_accion_accion
municipio_accion.id_accion_fk
accion.id
Cascade on delete
fk_municipio_accion_municipio
municipio_accion.id_municipio_fk
municipio.id
Cascade on delete
fk_id_dom_tecnologia
accion_dom_tecnologia.id_dom_tecnologia_fk
dom_tecnologia.id
Restrict delete
fk_id_accion
accion_dom_tecnologia.id_accion_fk
accion.id
Restrict delete
fk_id_entidad
usuario.id_entidad_fk
entidad.id
Restrict delete
fk_pigcct_departamento
pigcct.id_departamento_fk
departamento.id
Restrict delete
fk_indicador_accion_accion
indicador_accion.id_accion_fk
accion.id
Cascade on delete
fk_indicador_accion_indicador
indicador_accion.id_indicador_fk
indicador.id
Cascade on delete
fk_id_accion
accion_dom_ecosistema.id_accion_fk
accion.id
Restrict delete
fk_id_dom_ecosistema
accion_dom_ecosistema.id_dom_ecosistema_fk
dom_ecosistema.id
Restrict delete
fk_id_accion
accion_dom_servicios_eco_sbn.id_accion_fk
accion.id
Restrict delete
fk_id_dom_servicios_eco_sbn
accion_dom_servicios_eco_sbn.id_dom_servicios_eco_sbn_fk
dom_servicios_eco_sbn.id
Restrict delete
fk_indicador_medida
indicador.id_medida_fk
medida.id
Restrict delete
fk_dom_unidad
indicador.id_dom_unidad_fk
dom_unidad.id
Cascade on delete
fk_id_medida
medida_dom_siivra.id_medida_fk
medida.id
Restrict delete
fk_id_dom_siivra
medida_dom_siivra.id_dom_siivra_fk
dom_siivra.id
Restrict delete

Check Constraints

Table Constraint Name Constraint
dom_lineainstrumental_pncc chk_dom_lineainstrumental_pncc_nombre_len ((char_length((nombre)::text) >= 3) AND (char_length((nombre)::text) <= 100))
dom_unidad chk_dom_unidad_len ((char_length((nombre)::text) >= 3) AND (char_length((nombre)::text) <= 100))
dom_medio_implem chk_dom_medio_implem_nombre_len ((char_length((nombre)::text) >= 3) AND (char_length((nombre)::text) <= 100))
dom_dimension chk_dom_dimension_nombre_len ((char_length((nombre)::text) >= 3) AND (char_length((nombre)::text) <= 100))
dom_enfoque chk_dom_enfoque_nombre_len ((char_length((nombre)::text) >= 3) AND (char_length((nombre)::text) <= 100))
dom_lineaestrategica_pncc chk_dom_lineaestrategica_pncc_nombre_len ((char_length((nombre)::text) >= 3) AND (char_length((nombre)::text) <= 100))
eje chk_eje_nombre_len ((char_length((nombre)::text) >= 3) AND (char_length((nombre)::text) <= 100))
spatial_ref_sys spatial_ref_sys_srid_check ((srid > 0) AND (srid <= 998999))
accion chk_accion_nombre_proyecto_len ((char_length((nombre_proyecto)::text) >= 3) AND (char_length((nombre_proyecto)::text) <= 100))
dom_ods chk_dom_ods_nombre_len ((char_length((nombre)::text) >= 3) AND (char_length((nombre)::text) <= 100))
adjunto chk_adjunto_createdat (createdat <= CURRENT_DATE)
adjunto chk_adjunto_createdat_updatedat (createdat <= updatedat)
adjunto chk_adjunto_filename_len ((char_length((filename)::text) >= 3) AND (char_length((filename)::text) <= 100))
adjunto chk_adjunto_mimetype_len ((char_length((mimetype)::text) >= 3) AND (char_length((mimetype)::text) <= 100))
adjunto chk_adjunto_originalname_len ((char_length((originalname)::text) >= 3) AND (char_length((originalname)::text) <= 100))
adjunto chk_adjunto_size (size >= 50)
adjunto chk_adjunto_updatedat (updatedat <= CURRENT_DATE)
pigcct chk_pigcct_nombre_len ((char_length((nombre)::text) >= 3) AND (char_length((nombre)::text) <= 100))