69 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||||||
|---|---|---|---|---|---|---|---|---|---|
| fk_前受金データ_顧客 |
|
|
Restrict delete | ||||||
| fk_前受金データ_入金 |
|
|
Restrict delete | ||||||
| 取引先マスタ_取引先グループコード_fkey |
|
|
Restrict delete | ||||||
| fk_請求明細_請求 |
|
|
Cascade on delete | ||||||
| fk_請求明細_売上 |
|
|
Restrict delete | ||||||
| 仕入先マスタ_仕入先コード_fkey |
|
|
Restrict delete | ||||||
| fk_支払明細_仕入 |
|
|
Restrict delete | ||||||
| fk_支払明細_支払 |
|
|
Cascade on delete | ||||||
| fk_入金消込明細_請求 |
|
|
Restrict delete | ||||||
| fk_入金消込明細_入金 |
|
|
Cascade on delete | ||||||
| 商品マスタ_商品分類コード_fkey |
|
|
Restrict delete | ||||||
| 顧客別販売単価_商品コード_fkey |
|
|
Restrict delete | ||||||
| fk_支払_仕入先 |
|
|
Restrict delete | ||||||
| fk_受注データ_出荷先 |
|
|
Restrict delete | ||||||
| fk_受注データ_見積 |
|
|
Restrict delete | ||||||
| fk_受注データ_顧客 |
|
|
Restrict delete | ||||||
| 顧客マスタ_顧客コード_fkey |
|
|
Restrict delete | ||||||
| fk_受注明細_受注 |
|
|
Cascade on delete | ||||||
| fk_受注明細_商品 |
|
|
Restrict delete | ||||||
| fk_在庫_倉庫 |
|
|
Restrict delete | ||||||
| fk_在庫_ロケーション |
|
|
Restrict delete | ||||||
| fk_在庫_商品 |
|
|
Restrict delete | ||||||
| fk_買掛金残高_仕入先 |
|
|
Restrict delete | ||||||
| 出荷先マスタ_取引先コード_顧客枝番_fkey |
|
|
Restrict delete | ||||||
| 出荷先マスタ_地域コード_fkey |
|
|
Restrict delete | ||||||
| fk_棚卸_倉庫 |
|
|
Restrict delete | ||||||
| fk_支払予定_支払 |
|
|
Restrict delete | ||||||
| fk_支払予定_仕入先 |
|
|
Restrict delete | ||||||
| fk_発注_仕入先 |
|
|
Restrict delete | ||||||
| fk_請求データ_顧客 |
|
|
Restrict delete | ||||||
| 社員マスタ_部門コード_開始日_fkey |
|
|
Restrict delete | ||||||
| fk_見積明細_見積 |
|
|
Cascade on delete | ||||||
| fk_見積明細_商品 |
|
|
Restrict delete | ||||||
| fk_売上明細_出荷明細 |
|
|
Restrict delete | ||||||
| fk_売上明細_売上 |
|
|
Cascade on delete | ||||||
| fk_売上明細_受注明細 |
|
|
Restrict delete | ||||||
| fk_売上明細_商品 |
|
|
Restrict delete | ||||||
| fk_ロケーション_倉庫 |
|
|
Restrict delete | ||||||
| fk_採番履歴_採番マスタ |
|
|
Restrict delete | ||||||
| fk_出荷データ_出荷先 |
|
|
Restrict delete | ||||||
| fk_出荷データ_受注 |
|
|
Restrict delete | ||||||
| fk_出荷データ_顧客 |
|
|
Restrict delete | ||||||
| fk_棚卸明細_商品 |
|
|
Restrict delete | ||||||
| fk_棚卸明細_棚卸 |
|
|
Cascade on delete | ||||||
| fk_出荷明細_受注明細 |
|
|
Restrict delete | ||||||
| fk_出荷明細_出荷 |
|
|
Cascade on delete | ||||||
| fk_出荷明細_商品 |
|
|
Restrict delete | ||||||
| fk_入荷_発注 |
|
|
Restrict delete | ||||||
| fk_入荷_仕入先 |
|
|
Restrict delete | ||||||
| fk_入荷_倉庫 |
|
|
Restrict delete | ||||||
| fk_入出庫履歴_商品 |
|
|
Restrict delete | ||||||
| fk_入出庫履歴_倉庫 |
|
|
Restrict delete | ||||||
| fk_請求締履歴_顧客 |
|
|
Restrict delete | ||||||
| fk_請求締履歴_請求 |
|
|
Restrict delete | ||||||
| fk_売掛金残高_顧客 |
|
|
Restrict delete | ||||||
| fk_発注明細_商品 |
|
|
Restrict delete | ||||||
| fk_発注明細_発注 |
|
|
Cascade on delete | ||||||
| fk_売上データ_出荷 |
|
|
Restrict delete | ||||||
| fk_売上データ_受注 |
|
|
Restrict delete | ||||||
| fk_売上データ_顧客 |
|
|
Restrict delete | ||||||
| fk_仕入明細_商品 |
|
|
Restrict delete | ||||||
| fk_仕入明細_仕入 |
|
|
Cascade on delete | ||||||
| fk_入荷明細_発注明細 |
|
|
Restrict delete | ||||||
| fk_入荷明細_入荷 |
|
|
Cascade on delete | ||||||
| fk_入荷明細_商品 |
|
|
Restrict delete | ||||||
| fk_見積データ_顧客 |
|
|
Restrict delete | ||||||
| fk_仕入_仕入先 |
|
|
Restrict delete | ||||||
| fk_仕入_入荷 |
|
|
Restrict delete | ||||||
| fk_入金データ_顧客 |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|