Constraints

50 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
pol_aud_rev_fk
ss_poligonos_aud.rev
revinfo.rev
Restrict delete
doc_aud_rev_fk
ss_documentos_aud.rev
revinfo.rev
Restrict delete
fil_poligono_fk
ss_filas.fil_poligono_fk
ss_poligonos.pol_id
Restrict delete
fil_fuente_metadato_fk
ss_filas.fil_fuente_metadato_fk
ss_fuentes_metadatos.fum_id
Restrict delete
ss_zad_aud_rev_fk
ss_zonas_administrativas_aud.rev
revinfo.rev
Restrict delete
gei_archivo_fk
ss_informaciones.gei_archivo_fk
ss_archivos.arch_id
Restrict delete
gei_cai_fk
ss_informaciones.gei_cai_id
ss_categorias_informacion.ss_id
Restrict delete
cron_ej_fuente_fum_fk
ss_cron_ejecucion_fuente.cro_fuente_externa_id
ss_fuentes_externas.fue_id
Restrict delete
cron_ej_fuente_fuente_externa_fk
ss_cron_ejecucion_fuente.cro_fuente_externa_id
ss_fuentes_externas.fue_id
Restrict delete
cron_ej_fuente_metadato_fk
ss_cron_ejecucion_fuente.cro_metadato_id
ss_fuentes_metadatos.fum_id
Restrict delete
conf_revinfo_fk
ss_configuraciones_aud.rev
revinfo.rev
Restrict delete
dim_aud_rev_fk
ss_dimensiones_aud.rev
revinfo.rev
Restrict delete
val_fila_fk
ss_valores.val_fila_fk
ss_filas.fil_id
Restrict delete
val_fuente_metadato_fk
ss_valores.val_fuente_metadato_fk
ss_fuentes_metadatos.fum_id
Restrict delete
val_atributo_fk
ss_valores.val_atributo_fk
ss_atributos.atr_id
Restrict delete
val_aud_rev_fk
ss_valores_aud.rev
revinfo.rev
Restrict delete
ger_aud_rev_fk
ss_reportes_aud.rev
revinfo.rev
Restrict delete
ss_caf_aud_rev_fk
ss_categorias_fuente_externa_aud.rev
revinfo.rev
Restrict delete
com_aud_rev_fk
ss_comentarios_aud.rev
revinfo.rev
Restrict delete
fue_institucion_fk
ss_fuentes_externas.fue_institucion_fk
ss_instituciones.ins_id
Restrict delete
fue_categoria_fk
ss_fuentes_externas.fue_categoria_fk
ss_categorias_fuente_externa.ss_id
Restrict delete
atr_fuente_metadato_fk
ss_atributos.atr_fuente_metadato_fk
ss_fuentes_metadatos.fum_id
Restrict delete
com_usuario_aprobador_fk
ss_comentarios.com_usuario_aprobador_fk
ss_usuarios.usu_id
Restrict delete
fil_aud_rev_fk
ss_filas_aud.rev
revinfo.rev
Restrict delete
fum_aud_rev_fk
ss_fuentes_metadatos_aud.rev
revinfo.rev
Restrict delete
gei_aud_rev_fk
ss_informaciones_aud.rev
revinfo.rev
Restrict delete
conf_arch_fk
ss_configuraciones.conf_archivo_fk
ss_archivos.arch_id
Restrict delete
fk_info_indicadores_gestion_info
ss_info_indicadores.ini_gei_id
ss_informaciones.gei_id
Restrict delete
fk_info_indicadores_indicador
ss_info_indicadores.ini_ind_id
ss_indicadores.ind_id
Restrict delete
info_indicadores_gei_fk
ss_info_indicadores.ini_gei_id
ss_informaciones.gei_id
Cascade on delete
info_indicadores_ind_fk
ss_info_indicadores.ini_ind_id
ss_indicadores.ind_id
Cascade on delete
dim_archivo_fk
ss_dimensiones.dim_archivo_fk
ss_archivos.arch_id
Restrict delete
ger_dim_fk
ss_reportes.ger_dim_id
ss_dimensiones.dim_id
Restrict delete
ger_ind_fk
ss_reportes.ger_ind_id
ss_indicadores.ind_id
Restrict delete
fum_metadato_fuente_externa_fk
ss_fuentes_metadatos.fum_fuente_externa_fk
ss_fuentes_externas.fue_id
Restrict delete
fum_archivos_auxiliares_fk
ss_fuentes_metadatos.fum_archivos_auxiliares_fk
ss_archivos.arch_id
Restrict delete
fum_reporte_fk
ss_fuentes_metadatos.fum_reporte_fk
ss_reportes.ger_id
Restrict delete
fum_metadato_indicador_fk
ss_fuentes_metadatos.fum_indicador_fk
ss_indicadores.ind_id
Restrict delete
atr_aud_rev_fk
ss_atributos_aud.rev
revinfo.rev
Restrict delete
ind_dim_fk
ss_indicadores.ind_dim_id
ss_dimensiones.dim_id
Restrict delete
ind_archivo_fk
ss_indicadores.ind_archivo_fk
ss_archivos.arch_id
Restrict delete
ss_cai_aud_rev_fk
ss_categorias_informacion_aud.rev
revinfo.rev
Restrict delete
doc_ind_fk
ss_documentos.doc_ind_id
ss_indicadores.ind_id
Restrict delete
doc_gei_fk
ss_documentos.doc_gei_id
ss_informaciones.gei_id
Restrict delete
doc_archivo_fk
ss_documentos.doc_archivo_fk
ss_archivos.arch_id
Restrict delete
pol_zona_administrativa_zad_fk
ss_poligonos.pol_zona_administrativa_fk
ss_zonas_administrativas.zad_id
Restrict delete
ss_info_indicadores_aud_rev_fk
ss_info_indicadores_aud.rev
revinfo.rev
Restrict delete
FK_ss_cron_ejecucion_fuente_aud_rev
ss_cron_ejecucion_fuente_aud.rev
revinfo.rev
Restrict delete
ind_aud_rev_fk
ss_indicadores_aud.rev
revinfo.rev
Restrict delete
ins_aud_rev_fk
ss_instituciones_aud.rev
revinfo.rev
Restrict delete

Check Constraints

Table Constraint Name Constraint