Constraints

17 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fk_paat_planos_acao_ted
planos_acao_analises_ted.id_plano_acao
planos_acao_ted.id_plano_acao
Cascade on delete
fk_pat_programas_ted
planos_acao_ted.id_programa
programas_ted.id_programa
Cascade on delete
fk_teft_termos_execucao_ted
termos_execucao_formalizacao_ted.id_termo
termos_execucao_ted.id_termo
Cascade on delete
fk_et_esferas_orcamentarias_ted
eventos_ted.id_esfera_orcamentaria
esferas_orcamentarias_ted.id_esfera_orcamentaria
Cascade on delete
fk_et_naturezas_despesa_ted
eventos_ted.id_natureza
naturezas_despesa_ted.id_natureza
Cascade on delete
fk_et_notas_credito_ted
eventos_ted.id_nota
notas_credito_ted.id_nota
Cascade on delete
fk_ptct_planos_acao_ted
planos_trabalho_cronogramas_ted.id_plano_acao
planos_acao_ted.id_plano_acao
Cascade on delete
fk_pftt_programacoes_financeiras_ted
programacoes_financeiras_trfs_ted.id_programacao
programacoes_financeiras_ted.id_programacao
Cascade on delete
fk_pamt_planos_acao_ted
planos_acao_metas_ted.id_plano_acao
planos_acao_ted.id_plano_acao
Cascade on delete
fk_nct_planos_acao_ted
notas_credito_ted.id_plano_acao
planos_acao_ted.id_plano_acao
Cascade on delete
fk_telt_termos_execucao_ted
termos_execucao_links_ted.id_termo
termos_execucao_ted.id_termo
Cascade on delete
fk_papt_planos_acao_ted
planos_acao_pareceres_ted.id_plano_acao
planos_acao_ted.id_plano_acao
Cascade on delete
fk_pft_planos_acao_ted
programacoes_financeiras_ted.id_plano_acao
planos_acao_ted.id_plano_acao
Cascade on delete
fk_pbt_programas_ted
programas_beneficiarios_ted.id_programa
programas_ted.id_programa
Cascade on delete
fk_pamet_planos_acao_metas_ted
planos_acao_metas_etapas_ted.id_meta
planos_acao_metas_ted.id_meta
Cascade on delete
fk_paot_programas_ted
programas_acao_orcamentaria_ted.id_programa
programas_ted.id_programa
Cascade on delete
fk_tet_planos_acao_ted
termos_execucao_ted.id_plano_acao
planos_acao_ted.id_plano_acao
Cascade on delete

Check Constraints

Table Constraint Name Constraint