Lines 1257-1263
DROP TABLE IF EXISTS `borrower_attribute_types_branches`;
Link Here
|
1257 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1257 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1258 |
/*!40101 SET character_set_client = utf8 */; |
1258 |
/*!40101 SET character_set_client = utf8 */; |
1259 |
CREATE TABLE `borrower_attribute_types_branches` ( |
1259 |
CREATE TABLE `borrower_attribute_types_branches` ( |
1260 |
`bat_code` varchar(10) DEFAULT NULL, |
1260 |
`bat_code` varchar(64) DEFAULT NULL, |
1261 |
`b_branchcode` varchar(10) DEFAULT NULL, |
1261 |
`b_branchcode` varchar(10) DEFAULT NULL, |
1262 |
KEY `bat_code` (`bat_code`), |
1262 |
KEY `bat_code` (`bat_code`), |
1263 |
KEY `b_branchcode` (`b_branchcode`), |
1263 |
KEY `b_branchcode` (`b_branchcode`), |
Lines 1276-1282
DROP TABLE IF EXISTS `borrower_attributes`;
Link Here
|
1276 |
CREATE TABLE `borrower_attributes` ( |
1276 |
CREATE TABLE `borrower_attributes` ( |
1277 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field', |
1277 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field', |
1278 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key from the borrowers table, defines which patron/borrower has this attribute', |
1278 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key from the borrowers table, defines which patron/borrower has this attribute', |
1279 |
`code` varchar(10) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for', |
1279 |
`code` varchar(64) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for', |
1280 |
`attribute` varchar(255) DEFAULT NULL COMMENT 'custom patron field value', |
1280 |
`attribute` varchar(255) DEFAULT NULL COMMENT 'custom patron field value', |
1281 |
PRIMARY KEY (`id`), |
1281 |
PRIMARY KEY (`id`), |
1282 |
KEY `borrowernumber` (`borrowernumber`), |
1282 |
KEY `borrowernumber` (`borrowernumber`), |
Lines 5276-5282
DROP TABLE IF EXISTS `pseudonymized_borrower_attributes`;
Link Here
|
5276 |
CREATE TABLE `pseudonymized_borrower_attributes` ( |
5276 |
CREATE TABLE `pseudonymized_borrower_attributes` ( |
5277 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field', |
5277 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field', |
5278 |
`transaction_id` int(11) NOT NULL, |
5278 |
`transaction_id` int(11) NOT NULL, |
5279 |
`code` varchar(10) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for', |
5279 |
`code` varchar(64) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for', |
5280 |
`attribute` varchar(255) DEFAULT NULL COMMENT 'custom patron field value', |
5280 |
`attribute` varchar(255) DEFAULT NULL COMMENT 'custom patron field value', |
5281 |
PRIMARY KEY (`id`), |
5281 |
PRIMARY KEY (`id`), |
5282 |
KEY `pseudonymized_borrower_attributes_ibfk_1` (`transaction_id`), |
5282 |
KEY `pseudonymized_borrower_attributes_ibfk_1` (`transaction_id`), |
5283 |
- |
|
|