Lines 4230-4239
CREATE TABLE `pseudonymized_transactions` (
Link Here
|
4230 |
PRIMARY KEY (`id`), |
4230 |
PRIMARY KEY (`id`), |
4231 |
KEY `pseudonymized_transactions_ibfk_1` (`categorycode`), |
4231 |
KEY `pseudonymized_transactions_ibfk_1` (`categorycode`), |
4232 |
KEY `pseudonymized_transactions_borrowers_ibfk_2` (`branchcode`), |
4232 |
KEY `pseudonymized_transactions_borrowers_ibfk_2` (`branchcode`), |
4233 |
KEY `pseudonymized_transactions_borrowers_ibfk_3` (`transaction_branchcode`), |
4233 |
KEY `pseudonymized_transactions_borrowers_ibfk_3` (`transaction_branchcode`) |
4234 |
CONSTRAINT `pseudonymized_transactions_borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`), |
|
|
4235 |
CONSTRAINT `pseudonymized_transactions_borrowers_ibfk_3` FOREIGN KEY (`transaction_branchcode`) REFERENCES `branches` (`branchcode`), |
4236 |
CONSTRAINT `pseudonymized_transactions_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
4237 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4234 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4238 |
/*!40101 SET character_set_client = @saved_cs_client */; |
4235 |
/*!40101 SET character_set_client = @saved_cs_client */; |
4239 |
|
4236 |
|
4240 |
- |
|
|