|
Lines 6719-6727
CREATE TABLE `vendor_edi_accounts` (
Link Here
|
| 6719 |
KEY `vendorid` (`vendor_id`), |
6719 |
KEY `vendorid` (`vendor_id`), |
| 6720 |
KEY `shipmentbudget` (`shipment_budget`), |
6720 |
KEY `shipmentbudget` (`shipment_budget`), |
| 6721 |
KEY `vendor_edi_accounts_file_transport_id` (`file_transport_id`), |
6721 |
KEY `vendor_edi_accounts_file_transport_id` (`file_transport_id`), |
|
|
6722 |
CONSTRAINT `vendor_edi_accounts_ibfk_file_transport` FOREIGN KEY (`file_transport_id`) REFERENCES `file_transports` (`file_transport_id`) ON DELETE SET NULL ON UPDATE CASCADE, |
| 6722 |
CONSTRAINT `vfk_shipment_budget` FOREIGN KEY (`shipment_budget`) REFERENCES `aqbudgets` (`budget_id`), |
6723 |
CONSTRAINT `vfk_shipment_budget` FOREIGN KEY (`shipment_budget`) REFERENCES `aqbudgets` (`budget_id`), |
| 6723 |
CONSTRAINT `vfk_vendor_id` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`), |
6724 |
CONSTRAINT `vfk_vendor_id` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) |
| 6724 |
CONSTRAINT `vendor_edi_accounts_ibfk_file_transport` FOREIGN KEY (`file_transport_id`) REFERENCES `file_transports` (`file_transport_id`) ON DELETE SET NULL ON UPDATE CASCADE |
|
|
| 6725 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
6725 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 6726 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6726 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 6727 |
|
6727 |
|
| 6728 |
- |
|
|