Lines 1247-1253
DROP TABLE IF EXISTS `borrower_attribute_types`;
Link Here
|
1247 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1247 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1248 |
/*!40101 SET character_set_client = utf8 */; |
1248 |
/*!40101 SET character_set_client = utf8 */; |
1249 |
CREATE TABLE `borrower_attribute_types` ( |
1249 |
CREATE TABLE `borrower_attribute_types` ( |
1250 |
`code` varchar(10) NOT NULL COMMENT 'unique key used to identify each custom field', |
1250 |
`code` varchar(64) NOT NULL COMMENT 'unique key used to identify each custom field', |
1251 |
`description` varchar(255) NOT NULL COMMENT 'description for each custom field', |
1251 |
`description` varchar(255) NOT NULL COMMENT 'description for each custom field', |
1252 |
`repeatable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines whether one patron/borrower can have multiple values for this custom field (1 for yes, 0 for no)', |
1252 |
`repeatable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines whether one patron/borrower can have multiple values for this custom field (1 for yes, 0 for no)', |
1253 |
`unique_id` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this value needs to be unique (1 for yes, 0 for no)', |
1253 |
`unique_id` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this value needs to be unique (1 for yes, 0 for no)', |
Lines 1277-1283
DROP TABLE IF EXISTS `borrower_attribute_types_branches`;
Link Here
|
1277 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1277 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1278 |
/*!40101 SET character_set_client = utf8 */; |
1278 |
/*!40101 SET character_set_client = utf8 */; |
1279 |
CREATE TABLE `borrower_attribute_types_branches` ( |
1279 |
CREATE TABLE `borrower_attribute_types_branches` ( |
1280 |
`bat_code` varchar(10) DEFAULT NULL, |
1280 |
`bat_code` varchar(64) DEFAULT NULL, |
1281 |
`b_branchcode` varchar(10) DEFAULT NULL, |
1281 |
`b_branchcode` varchar(10) DEFAULT NULL, |
1282 |
KEY `bat_code` (`bat_code`), |
1282 |
KEY `bat_code` (`bat_code`), |
1283 |
KEY `b_branchcode` (`b_branchcode`), |
1283 |
KEY `b_branchcode` (`b_branchcode`), |
Lines 1296-1302
DROP TABLE IF EXISTS `borrower_attributes`;
Link Here
|
1296 |
CREATE TABLE `borrower_attributes` ( |
1296 |
CREATE TABLE `borrower_attributes` ( |
1297 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field', |
1297 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field', |
1298 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key from the borrowers table, defines which patron/borrower has this attribute', |
1298 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key from the borrowers table, defines which patron/borrower has this attribute', |
1299 |
`code` varchar(10) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for', |
1299 |
`code` varchar(64) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for', |
1300 |
`attribute` varchar(255) DEFAULT NULL COMMENT 'custom patron field value', |
1300 |
`attribute` varchar(255) DEFAULT NULL COMMENT 'custom patron field value', |
1301 |
PRIMARY KEY (`id`), |
1301 |
PRIMARY KEY (`id`), |
1302 |
KEY `borrowernumber` (`borrowernumber`), |
1302 |
KEY `borrowernumber` (`borrowernumber`), |
Lines 5301-5307
DROP TABLE IF EXISTS `pseudonymized_borrower_attributes`;
Link Here
|
5301 |
CREATE TABLE `pseudonymized_borrower_attributes` ( |
5301 |
CREATE TABLE `pseudonymized_borrower_attributes` ( |
5302 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field', |
5302 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field', |
5303 |
`transaction_id` int(11) NOT NULL, |
5303 |
`transaction_id` int(11) NOT NULL, |
5304 |
`code` varchar(10) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for', |
5304 |
`code` varchar(64) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for', |
5305 |
`attribute` varchar(255) DEFAULT NULL COMMENT 'custom patron field value', |
5305 |
`attribute` varchar(255) DEFAULT NULL COMMENT 'custom patron field value', |
5306 |
PRIMARY KEY (`id`), |
5306 |
PRIMARY KEY (`id`), |
5307 |
KEY `pseudonymized_borrower_attributes_ibfk_1` (`transaction_id`), |
5307 |
KEY `pseudonymized_borrower_attributes_ibfk_1` (`transaction_id`), |
5308 |
- |
|
|