Lines 1248-1261
CREATE TABLE `borrower_attribute_types` (
Link Here
|
1248 |
`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)', |
1248 |
`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)', |
1249 |
`authorised_value_category` varchar(32) DEFAULT NULL COMMENT 'foreign key from authorised_values that links this custom field to an authorized value category', |
1249 |
`authorised_value_category` varchar(32) DEFAULT NULL COMMENT 'foreign key from authorised_values that links this custom field to an authorized value category', |
1250 |
`display_checkout` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field displays in checkout screens', |
1250 |
`display_checkout` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field displays in checkout screens', |
1251 |
`category_code` varchar(10) DEFAULT NULL COMMENT 'defines a category for an attribute_type', |
|
|
1252 |
`class` varchar(255) NOT NULL DEFAULT '' COMMENT 'defines a class for an attribute_type', |
1251 |
`class` varchar(255) NOT NULL DEFAULT '' COMMENT 'defines a class for an attribute_type', |
1253 |
`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)', |
1252 |
`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)', |
1254 |
`mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not', |
1253 |
`mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not', |
1255 |
PRIMARY KEY (`code`), |
1254 |
PRIMARY KEY (`code`), |
1256 |
KEY `auth_val_cat_idx` (`authorised_value_category`), |
1255 |
KEY `auth_val_cat_idx` (`authorised_value_category`) |
1257 |
KEY `category_code` (`category_code`), |
|
|
1258 |
CONSTRAINT `borrower_attribute_types_ibfk_1` FOREIGN KEY (`category_code`) REFERENCES `categories` (`categorycode`) |
1259 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1256 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1260 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1257 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1261 |
|
1258 |
|
Lines 1276-1281
CREATE TABLE `borrower_attribute_types_branches` (
Link Here
|
1276 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1273 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1277 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1274 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1278 |
|
1275 |
|
|
|
1276 |
-- |
1277 |
-- Table structure for table `borrower_attribute_types_categories` |
1278 |
-- |
1279 |
|
1280 |
DROP TABLE IF EXISTS `borrower_attribute_types_categories`; |
1281 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1282 |
/*!40101 SET character_set_client = utf8 */; |
1283 |
CREATE TABLE `borrower_attribute_types_categories` ( |
1284 |
`borrower_attribute_type_code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, |
1285 |
`categorycode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, |
1286 |
KEY `borrower_attribute_type_code` (`borrower_attribute_type_code`), |
1287 |
KEY `categorycode` (`categorycode`), |
1288 |
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, |
1289 |
CONSTRAINT `borrower_attribute_types_categories_categorycode` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE, |
1290 |
PRIMARY KEY (`borrower_attribute_type_code`, `categorycode`) |
1291 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1292 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1293 |
|
1279 |
-- |
1294 |
-- |
1280 |
-- Table structure for table `borrower_attributes` |
1295 |
-- Table structure for table `borrower_attributes` |
1281 |
-- |
1296 |
-- |