Lines 5439-5460
CREATE TABLE `problem_reports` (
Link Here
|
5439 |
/*!40101 SET character_set_client = @saved_cs_client */; |
5439 |
/*!40101 SET character_set_client = @saved_cs_client */; |
5440 |
|
5440 |
|
5441 |
-- |
5441 |
-- |
5442 |
-- Table structure for table `pseudonymized_borrower_attributes` |
5442 |
-- Table structure for table `pseudonymized_metadata_values` |
5443 |
-- |
5443 |
-- |
5444 |
|
5444 |
|
5445 |
DROP TABLE IF EXISTS `pseudonymized_borrower_attributes`; |
5445 |
DROP TABLE IF EXISTS `pseudonymized_metadata_values`; |
5446 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5446 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5447 |
/*!40101 SET character_set_client = utf8 */; |
5447 |
/*!40101 SET character_set_client = utf8 */; |
5448 |
CREATE TABLE `pseudonymized_borrower_attributes` ( |
5448 |
CREATE TABLE `pseudonymized_metadata_values` ( |
5449 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field', |
5449 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field', |
5450 |
`transaction_id` int(11) NOT NULL, |
5450 |
`transaction_id` int(11) NOT NULL, |
5451 |
`code` varchar(64) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for', |
5451 |
`tablename` varchar(64) NOT NULL COMMENT 'Name of the related table', |
5452 |
`attribute` varchar(255) DEFAULT NULL COMMENT 'custom patron field value', |
5452 |
`key` varchar(64) NOT NULL COMMENT 'key for the metadata', |
|
|
5453 |
`value` varchar(255) DEFAULT NULL COMMENT 'value for the metadata', |
5453 |
PRIMARY KEY (`id`), |
5454 |
PRIMARY KEY (`id`), |
5454 |
KEY `pseudonymized_borrower_attributes_ibfk_1` (`transaction_id`), |
5455 |
KEY `pseudonymized_metadata_values_ibfk_1` (`transaction_id`), |
5455 |
KEY `anonymized_borrower_attributes_ibfk_2` (`code`), |
5456 |
CONSTRAINT `pseudonymized_metadata_values_ibfk_1` FOREIGN KEY (`transaction_id`) REFERENCES `pseudonymized_transactions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
5456 |
CONSTRAINT `anonymized_borrower_attributes_ibfk_2` FOREIGN KEY (`code`) REFERENCES `borrower_attribute_types` (`code`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
|
5457 |
CONSTRAINT `pseudonymized_borrower_attributes_ibfk_1` FOREIGN KEY (`transaction_id`) REFERENCES `pseudonymized_transactions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
5458 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
5457 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
5459 |
/*!40101 SET character_set_client = @saved_cs_client */; |
5458 |
/*!40101 SET character_set_client = @saved_cs_client */; |
5460 |
|
5459 |
|
5461 |
- |
|
|