Lines 1257-1270
CREATE TABLE `borrower_attribute_types` (
Link Here
|
1257 |
`searched_by_default` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field is included in "Standard" patron searches in the staff interface (1 for yes, 0 for no)', |
1257 |
`searched_by_default` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field is included in "Standard" patron searches in the staff interface (1 for yes, 0 for no)', |
1258 |
`authorised_value_category` varchar(32) DEFAULT NULL COMMENT 'foreign key from authorised_values that links this custom field to an authorized value category', |
1258 |
`authorised_value_category` varchar(32) DEFAULT NULL COMMENT 'foreign key from authorised_values that links this custom field to an authorized value category', |
1259 |
`display_checkout` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field displays in checkout screens', |
1259 |
`display_checkout` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field displays in checkout screens', |
1260 |
`category_code` varchar(10) DEFAULT NULL COMMENT 'defines a category for an attribute_type', |
|
|
1261 |
`class` varchar(255) NOT NULL DEFAULT '' COMMENT 'defines a class for an attribute_type', |
1260 |
`class` varchar(255) NOT NULL DEFAULT '' COMMENT 'defines a class for an attribute_type', |
1262 |
`keep_for_pseudonymization` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field is copied to anonymized_borrower_attributes (1 for yes, 0 for no)', |
1261 |
`keep_for_pseudonymization` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field is copied to anonymized_borrower_attributes (1 for yes, 0 for no)', |
1263 |
`mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not', |
1262 |
`mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not', |
1264 |
PRIMARY KEY (`code`), |
1263 |
PRIMARY KEY (`code`), |
1265 |
KEY `auth_val_cat_idx` (`authorised_value_category`), |
1264 |
KEY `auth_val_cat_idx` (`authorised_value_category`) |
1266 |
KEY `category_code` (`category_code`), |
|
|
1267 |
CONSTRAINT `borrower_attribute_types_ibfk_1` FOREIGN KEY (`category_code`) REFERENCES `categories` (`categorycode`) |
1268 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1265 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1269 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1266 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1270 |
|
1267 |
|
Lines 1285-1290
CREATE TABLE `borrower_attribute_types_branches` (
Link Here
|
1285 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1282 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1286 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1283 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1287 |
|
1284 |
|
|
|
1285 |
-- |
1286 |
-- Table structure for table `borrower_attribute_types_categories` |
1287 |
-- |
1288 |
|
1289 |
DROP TABLE IF EXISTS `borrower_attribute_types_categories`; |
1290 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1291 |
/*!40101 SET character_set_client = utf8 */; |
1292 |
CREATE TABLE `borrower_attribute_types_categories` ( |
1293 |
`borrower_attribute_type_code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, |
1294 |
`categorycode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, |
1295 |
KEY `borrower_attribute_type_code` (`borrower_attribute_type_code`), |
1296 |
KEY `categorycode` (`categorycode`), |
1297 |
CONSTRAINT `borrower_attribute_types_categories_borrower_attribute_type_code` FOREIGN KEY (`borrower_attribute_type_code`) REFERENCES `borrower_attribute_types` (`code`) ON DELETE CASCADE ON UPDATE CASCADE, |
1298 |
CONSTRAINT `borrower_attribute_types_categories_categorycode` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE, |
1299 |
PRIMARY KEY (`borrower_attribute_type_code`, `categorycode`) |
1300 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1301 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1302 |
|
1288 |
-- |
1303 |
-- |
1289 |
-- Table structure for table `borrower_attributes` |
1304 |
-- Table structure for table `borrower_attributes` |
1290 |
-- |
1305 |
-- |