215 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| FK_INS_PRO_ITE_ANA_INS_ITE_ANA |
|
|
Restrict delete | ||||||||
| FK_COB_RAST |
|
|
Restrict delete | ||||||||
| FK_CON_REC_CON_REC_PAR |
|
|
Restrict delete | ||||||||
| FK_CTA_CON_REC_PAR |
|
|
Restrict delete | ||||||||
| FK_T_ORC_ITEM_ERRO_1 |
|
|
Cascade on delete | ||||||||
| FK_USU_USU_CON |
|
|
Restrict delete | ||||||||
| FK_IMP_FIS_USU_CON |
|
|
Restrict delete | ||||||||
| FK_COM_USU_CON |
|
|
Restrict delete | ||||||||
| FK_USO_FUN |
|
|
Restrict delete | ||||||||
| FK_PRODUTO_CQ_REAG_PRO_CQ |
|
|
Restrict delete | ||||||||
| FK_REAGENTE_CQ_REAG_PRO_CQ |
|
|
Restrict delete | ||||||||
| FK_HOMEOPATIA_DINAMIZACAO_PROD |
|
|
Restrict delete | ||||||||
| FK_PRO_FOR_BULA |
|
|
Restrict delete | ||||||||
| FK_PRO_LOT_LIV_QUI |
|
|
Restrict delete | ||||||||
| FK_INS_PRO_FLO_TIP_FLO |
|
|
Restrict delete | ||||||||
| FK_INS_PRO_FLO_INS_PRO |
|
|
Restrict delete | ||||||||
| FK_INS_PRO_MAT_INS_MAT_EXC_EXC |
|
|
Restrict delete | ||||||||
| FK_INS_PRO_MAT_INS_MAT_EXC_PRO |
|
|
Restrict delete | ||||||||
| FK_T_LOCALIZACAO_LOTE_1 |
|
|
Restrict delete | ||||||||
| FK_CLI_MED |
|
|
Restrict delete | ||||||||
| FK_MED_CLI |
|
|
Restrict delete | ||||||||
| FK_HOMEOPATIA_VEICULO_PAS_PROD |
|
|
Restrict delete | ||||||||
| FK_T_PACIENTE_SEGMENTO_1 |
|
|
Cascade on delete | ||||||||
| FK_ATE_WHATS_MSG |
|
|
Restrict delete | ||||||||
| FK_PRO_RECIP_PRO |
|
|
Restrict delete | ||||||||
| FK_PRO_REC_ROT |
|
|
Restrict delete | ||||||||
| FK_ALIQUOTA_IMP_FISCAL_RZ |
|
|
Restrict delete | ||||||||
| FK_LOC_LOT_PRO_LOT |
|
|
Restrict delete | ||||||||
| FK_PRO_PRO_LOT |
|
|
Restrict delete | ||||||||
| FK_FOR_PRO_LOT |
|
|
Restrict delete | ||||||||
| FK_PRO_ENT_PRO |
|
|
Restrict delete | ||||||||
| FK_FLO_VEI_DU_PRO |
|
|
Restrict delete | ||||||||
| FK_T_PRODUTO_INTERACAO_MED_2 |
|
|
Restrict delete | ||||||||
| FK_T_PRODUTO_INTERACAO_MED_1 |
|
|
Restrict delete | ||||||||
| FK_T_PRODUTO_INTERACAO_MED_3 |
|
|
Restrict delete | ||||||||
| FK_RZ_IMPRESSORA_FISCAL |
|
|
Restrict delete | ||||||||
| FK_CON_GRU_SUB |
|
|
Restrict delete | ||||||||
| FK_CON_DESC_CON |
|
|
Restrict delete | ||||||||
| FK_CLI_CLI_DEP |
|
|
Restrict delete | ||||||||
| FK_CLI_CON_REC |
|
|
Restrict delete | ||||||||
| FK_CND_PAG_CON_REC |
|
|
Restrict delete | ||||||||
| FK_MED_PRO_ASS2 |
|
|
Restrict delete | ||||||||
| FK_MED_PRO_ASS |
|
|
Restrict delete | ||||||||
| FK_PRO_MAT_PRI_MAT_PRI_PRE |
|
|
Restrict delete | ||||||||
| FK_USU_USU_APL |
|
|
Restrict delete | ||||||||
| FK_APL_USU_APL |
|
|
Restrict delete | ||||||||
| FK_PRO_GRA_PRO |
|
|
Restrict delete | ||||||||
| FK_PRO_GRA_REC |
|
|
Restrict delete | ||||||||
| FK_CLI_WHATS |
|
|
Restrict delete | ||||||||
| FK_PAC_PRO_PRO |
|
|
Restrict delete | ||||||||
| FK_GRU_SUB |
|
|
Restrict delete | ||||||||
| FK_T_PRODUTO_FORMA_FARM_DILUIDO |
|
|
Restrict delete | ||||||||
| FK_T_TIPO_FORMA_FARMACEUTICA_RE |
|
|
Restrict delete | ||||||||
| FK_CRE_COB |
|
|
Restrict delete | ||||||||
| FK_CLI_COB |
|
|
Restrict delete | ||||||||
| FK_SUB_GRU_COM |
|
|
Restrict delete | ||||||||
| FK_FUN_COM |
|
|
Restrict delete | ||||||||
| FK_MED_FUN_VIS |
|
|
Restrict delete | ||||||||
| FK_FOR_REC |
|
|
Restrict delete | ||||||||
| FK_PRO_CRE_PRO |
|
|
Restrict delete | ||||||||
| FK_CRE_CRE_PRO |
|
|
Restrict delete | ||||||||
| FK_PROD_CONJ_PRO |
|
|
Restrict delete | ||||||||
| FK_PROD_CONJ_PRO2 |
|
|
Restrict delete | ||||||||
| FK_PRO_BUL_BIB_PRO |
|
|
Restrict delete | ||||||||
| FK_ACE_USU |
|
|
Restrict delete | ||||||||
| FK_ACE_APL |
|
|
Restrict delete | ||||||||
| FK_T_COBRANCA_ONLINE_PARC |
|
|
Restrict delete | ||||||||
| FK_T_CADASTRO_EXCIPIENTE_2 |
|
|
Restrict delete | ||||||||
| FK_T_CADASTRO_EXCIPIENTE_1 |
|
|
Restrict delete | ||||||||
| FK_MAT_PRI_FUNC |
|
|
Restrict delete | ||||||||
| FK_ORC_ITE_ORC_MAT_PRI |
|
|
Restrict delete | ||||||||
| FK_T_ORC_MATERIA_PRIMA_1 |
|
|
Restrict delete | ||||||||
| FK_TRI_DET_TRI |
|
|
Restrict delete | ||||||||
| FK_REC_REC_PRO |
|
|
Cascade on delete | ||||||||
| FK_T_APONTAMENTO_MOVIMENTACAO_1 |
|
|
Restrict delete | ||||||||
| FK_T_APONTAMENTO_MOVIMENTACAO_2 |
|
|
Restrict delete | ||||||||
| FK_T_APONTAMENTO_MOVIMENTACAO_3 |
|
|
Restrict delete | ||||||||
| FK_T_APONTAMENTO_MOVIMENTACAO_4 |
|
|
Restrict delete | ||||||||
| FK_ORC_ITE_PRO_ORC_ITE |
|
|
Restrict delete | ||||||||
| FK_ORC_ITE_PRO_PRO |
|
|
Restrict delete | ||||||||
| FK_INS_PRO_INS_PRO_MAT_PRI |
|
|
Restrict delete | ||||||||
| FK_ORC_ITE_ORC_ITE_PRO_LOT |
|
|
Cascade on delete | ||||||||
| FK_PRO_LOT_ORC_ITE_PRO_LOT |
|
|
Restrict delete | ||||||||
| FK_MAT_PRI_DOS_PES_PRO_MAT_PRI |
|
|
Restrict delete | ||||||||
| FK_CLI_DESC_SUB |
|
|
Restrict delete | ||||||||
| FK_CLI_DESC_CLI |
|
|
Restrict delete | ||||||||
| FK_CLI_DESC_GRU |
|
|
Restrict delete | ||||||||
| FK_T_PRODUTO_NFE_IDENT |
|
|
Restrict delete | ||||||||
| FK_T_PRODUTO_LOTE_LOC_ESTOQUE |
|
|
Restrict delete | ||||||||
| FK_FLO_VEI_DU_PROD |
|
|
Restrict delete | ||||||||
| FK_T_ORCAMENTO_RECIPIENTE |
|
|
Restrict delete | ||||||||
| FK_T_ORCAMENTO_RECIPIENTE_EMB |
|
|
Restrict delete | ||||||||
| FK_ANA_CQ_ITEM_ANA_CQ |
|
|
Restrict delete | ||||||||
| FK_ITEM_ANA_ITEM_ANA_CQ |
|
|
Restrict delete | ||||||||
| FK_CTA_CON_PAG_PAR |
|
|
Restrict delete | ||||||||
| FK_CON_PAG_CON_PAG_PAR |
|
|
Restrict delete | ||||||||
| FK_T_TOTAL_NFE_1 |
|
|
Restrict delete | ||||||||
| FK_IN_PRO_SIN_INS_PRO |
|
|
Restrict delete | ||||||||
| FK_ORC_ITE_PRO |
|
|
Restrict delete | ||||||||
| FK_ORC_ITE_MED |
|
|
Restrict delete | ||||||||
| FK_PRO_ORC_ITE_EMB |
|
|
Restrict delete | ||||||||
| FK_PRO_ORC_ITE |
|
|
Restrict delete | ||||||||
| FK_PRO_ORC_ITE_REC |
|
|
Restrict delete | ||||||||
| FK_PRO_MAT_PRI_MAT_PRI_EXC |
|
|
Restrict delete | ||||||||
| FK_PRO_MAT_PRI_MAT_PRO_EXC_EXC |
|
|
Restrict delete | ||||||||
| FK_T_DENSIDADE_PRODUTO_1 |
|
|
Restrict delete | ||||||||
| FK_CLI_PAR_DEV_CLI |
|
|
Restrict delete | ||||||||
| FK_PRO_PAR |
|
|
Restrict delete | ||||||||
| FK_FOR_PAR_DEV_FOR |
|
|
Restrict delete | ||||||||
| FK_FOR_PAR |
|
|
Restrict delete | ||||||||
| FK_CND_PAG_PAR |
|
|
Restrict delete | ||||||||
| FK_CON_PAG_PAR_DEV_CON_REC |
|
|
Restrict delete | ||||||||
| FK_CLI_PAR |
|
|
Restrict delete | ||||||||
| FK_CON_PAG_PAR_DEV_CON_PAG |
|
|
Restrict delete | ||||||||
| FK_FUN_PAR |
|
|
Restrict delete | ||||||||
| FK_PRE_MAN_DOS_PRO_MAT_PRI |
|
|
Restrict delete | ||||||||
| FK_PRO_LOT_LIV_CIV |
|
|
Restrict delete | ||||||||
| FK_PAC_CLI |
|
|
Restrict delete | ||||||||
| FK_COBRANCA_ONLINE |
|
|
Restrict delete | ||||||||
| FK_ETI_PRO |
|
|
Restrict delete | ||||||||
| FK_USU_INV |
|
|
Restrict delete | ||||||||
| FK_INV_LOC_LOT |
|
|
Restrict delete | ||||||||
| FK_COM_APL_CON |
|
|
Restrict delete | ||||||||
| FK_CND_PAG_PED |
|
|
Restrict delete | ||||||||
| FK_FOR_PED |
|
|
Restrict delete | ||||||||
| FK_COBRANCA_ONLINE_I |
|
|
Restrict delete | ||||||||
| FK_COBRANCA_ONLINE_ITENS |
|
|
Restrict delete | ||||||||
| FK_LOC_LOT_REC_PRO_LOT |
|
|
Restrict delete | ||||||||
| FK_PAC_ENT_PAC |
|
|
Restrict delete | ||||||||
| FK_HOM_VEI_PRO |
|
|
Restrict delete | ||||||||
| FK_MAT_PRI_PRO |
|
|
Restrict delete | ||||||||
| FK_T_INS_INTERACAO_MEDICAMENTOS |
|
|
Restrict delete | ||||||||
| FK_SAI_SAI_PRO |
|
|
Restrict delete | ||||||||
| FK_CON_DESC_CLI |
|
|
Restrict delete | ||||||||
| FK_CON_DESC_SUB |
|
|
Restrict delete | ||||||||
| FK_CON_DESC_GRU |
|
|
Restrict delete | ||||||||
| FK_T_APONTAMENTO_FORMA_FARM_1 |
|
|
Restrict delete | ||||||||
| FK_ORC_FUN |
|
|
Restrict delete | ||||||||
| FK_CLI_ORC |
|
|
Restrict delete | ||||||||
| FK_MED_ORC |
|
|
Restrict delete | ||||||||
| FK_ORC_PAC |
|
|
Restrict delete | ||||||||
| FK_DCI_PRO |
|
|
Restrict delete | ||||||||
| FK_SUB_PRO |
|
|
Restrict delete | ||||||||
| FK_TRI_PRO |
|
|
Restrict delete | ||||||||
| FK_PRO_PRO_FRAC |
|
|
Restrict delete | ||||||||
| FK_FOR_PRO |
|
|
Restrict delete | ||||||||
| FK_PRO_PSI_PRO |
|
|
Restrict delete | ||||||||
| FK_CLI_CRE |
|
|
Restrict delete | ||||||||
| FK_PRO_EMB_REC_EMB |
|
|
Restrict delete | ||||||||
| FK_PRO_EMB_REC_CAP |
|
|
Restrict delete | ||||||||
| FK_INS_PRO_INS_PRO_REC |
|
|
Restrict delete | ||||||||
| FK_CTA_MOV_CON |
|
|
Restrict delete | ||||||||
| FK_PRO_LOTE_ANALISE_CQ |
|
|
Restrict delete | ||||||||
| FK_T_ORCAMENTO_RECIP |
|
|
Restrict delete | ||||||||
| FK_T_ORCAMENTO_REC_MAT_PRI |
|
|
Restrict delete | ||||||||
| FK_INS_PRO_MAT_INS_MAT_SIN_PRO |
|
|
Restrict delete | ||||||||
| FK_REC_REC_DET_IMG |
|
|
Restrict delete | ||||||||
| FK_MAT_PRI_DOS_PRO_MAT_PRI |
|
|
Restrict delete | ||||||||
| FK_T_KIT_OUTROS_PRODUTO_1 |
|
|
Restrict delete | ||||||||
| FK_T_KIT_OUTROS_PRODUTO_2 |
|
|
Restrict delete | ||||||||
| FK_COM_BLO_SUB |
|
|
Restrict delete | ||||||||
| FK_SUB_BLO_SUB |
|
|
Restrict delete | ||||||||
| FK_CRE_CRE_ENC |
|
|
Restrict delete | ||||||||
| FK_T_PRODUTO_DETALHE_1 |
|
|
Restrict delete | ||||||||
| FK_USU_INV_ABER |
|
|
Restrict delete | ||||||||
| FK_CLI_CLI_PES_JUR |
|
|
Restrict delete | ||||||||
| FK_CD_PRO_PRO_ABC |
|
|
Restrict delete | ||||||||
| FK_PRO_MAT_PRI_PRO_CNF |
|
|
Restrict delete | ||||||||
| FK_PRO_MAT_PRI_PRO_CNF_MAT_PRI |
|
|
Restrict delete | ||||||||
| FK_PRO_PMC |
|
|
Restrict delete | ||||||||
| FK_T_MOV_HIST_VENDAS_1 |
|
|
Cascade on delete | ||||||||
| FK_PRO_LIV_PSI |
|
|
Restrict delete | ||||||||
| FK_CLI_CON_CLI |
|
|
Restrict delete | ||||||||
| FK_COM_CON_CLI |
|
|
Restrict delete | ||||||||
| FK_USO_EMP_USU |
|
|
Restrict delete | ||||||||
| FK_USO_EMP_EMP |
|
|
Restrict delete | ||||||||
| FK_CLI_CLI_PES_FIS |
|
|
Restrict delete | ||||||||
| FK_HOM_VEI_DOS_UNI_PRO |
|
|
Restrict delete | ||||||||
| FK_T_TIPO_RECIPIENTE_CONJUGADO_ |
|
|
Restrict delete | ||||||||
| FK_PRO_LOT_LIV_MAN |
|
|
Restrict delete | ||||||||
| FK_INS_PRO_INS_FOR |
|
|
Restrict delete | ||||||||
| FK_CON_CHE |
|
|
Restrict delete | ||||||||
| FK_CLI_CHE |
|
|
Restrict delete | ||||||||
| FK_BANCO_CHE |
|
|
Restrict delete | ||||||||
| FK_CLI_SAI |
|
|
Restrict delete | ||||||||
| FK_SAI_CON |
|
|
Restrict delete | ||||||||
| FK_MED_SAI |
|
|
Restrict delete | ||||||||
| FK_FUN_SAI |
|
|
Restrict delete | ||||||||
| FK_PRO_PRO_ITE_ANA |
|
|
Restrict delete | ||||||||
| FK_ITE_ANA_PRO_ITE_ANA |
|
|
Restrict delete | ||||||||
| FK_T_TIPO_RECIPIENTE_ITEM_1 |
|
|
Restrict delete | ||||||||
| FK_CND_PAG_CND_PAG_PRA |
|
|
Restrict delete | ||||||||
| FK_CND_PAG_CON_PAG |
|
|
Restrict delete | ||||||||
| FK_FOR_CON_PAG |
|
|
Restrict delete | ||||||||
| FK_PRO_PRO_HOM |
|
|
Restrict delete | ||||||||
| FK_PRO_MAT_PRI_SIN |
|
|
Restrict delete | ||||||||
| FK_CND_PAG_ENT |
|
|
Restrict delete | ||||||||
| FK_PED_ENT |
|
|
Restrict delete | ||||||||
| FK_CLI_REC |
|
|
Restrict delete | ||||||||
| FK_MED_REC |
|
|
Restrict delete | ||||||||
| FK_FUN_REC |
|
|
Restrict delete | ||||||||
| FK_FUN_USU |
|
|
Restrict delete | ||||||||
| FK_DETALHE_IMPRESSORA_FISCAL |
|
|
Restrict delete | ||||||||
| FK_T_APONTAMENTO_RESPONSAVEL_1 |
|
|
Restrict delete | ||||||||
| FK_T_APONTAMENTO_RESPONSAVEL_2 |
|
|
Restrict delete | ||||||||
| FK_INS_PRO_REAG_INS_PRO_REAG |
|
|
Restrict delete | ||||||||
| FK_INS_PRO_REAG_INS_PRO |
|
|
Restrict delete | ||||||||
| FK_T_INS_PRODUTO_FORMULA_2 |
|
|
Restrict delete | ||||||||
| FK_T_INS_PRODUTO_FORMULA_1 |
|
|
Restrict delete | ||||||||
| FK_T_KIT_PRODUTO_1 |
|
|
Restrict delete | ||||||||
| FK_PRE_MAN_PRO_MAT_PRI |
|
|
Restrict delete | ||||||||
| FK_PRO_GRA_ITE_PRO |
|
|
Restrict delete | ||||||||
| FK_PRO_GRA_ITE_MAT_PRI |
|
|
Restrict delete | ||||||||
| FK_PED_PED_PRO |
|
|
Restrict delete | ||||||||
| FK_PRO_PED_PRO |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|