|
Lines 1237-1250
CREATE TABLE `borrower_attribute_types` (
Link Here
|
| 1237 |
`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)', |
1237 |
`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)', |
| 1238 |
`authorised_value_category` varchar(32) DEFAULT NULL COMMENT 'foreign key from authorised_values that links this custom field to an authorized value category', |
1238 |
`authorised_value_category` varchar(32) DEFAULT NULL COMMENT 'foreign key from authorised_values that links this custom field to an authorized value category', |
| 1239 |
`display_checkout` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field displays in checkout screens', |
1239 |
`display_checkout` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field displays in checkout screens', |
| 1240 |
`category_code` varchar(10) DEFAULT NULL COMMENT 'defines a category for an attribute_type', |
|
|
| 1241 |
`class` varchar(255) NOT NULL DEFAULT '' COMMENT 'defines a class for an attribute_type', |
1240 |
`class` varchar(255) NOT NULL DEFAULT '' COMMENT 'defines a class for an attribute_type', |
| 1242 |
`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)', |
1241 |
`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)', |
| 1243 |
`mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not', |
1242 |
`mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not', |
| 1244 |
PRIMARY KEY (`code`), |
1243 |
PRIMARY KEY (`code`), |
| 1245 |
KEY `auth_val_cat_idx` (`authorised_value_category`), |
1244 |
KEY `auth_val_cat_idx` (`authorised_value_category`) |
| 1246 |
KEY `category_code` (`category_code`), |
|
|
| 1247 |
CONSTRAINT `borrower_attribute_types_ibfk_1` FOREIGN KEY (`category_code`) REFERENCES `categories` (`categorycode`) |
| 1248 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1245 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1249 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1246 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1250 |
|
1247 |
|
|
Lines 1265-1270
CREATE TABLE `borrower_attribute_types_branches` (
Link Here
|
| 1265 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1262 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1266 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1263 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1267 |
|
1264 |
|
|
|
1265 |
-- |
| 1266 |
-- Table structure for table `borrower_attribute_types_categories` |
| 1267 |
-- |
| 1268 |
|
| 1269 |
DROP TABLE IF EXISTS `borrower_attribute_types_categories`; |
| 1270 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 1271 |
/*!40101 SET character_set_client = utf8 */; |
| 1272 |
CREATE TABLE `borrower_attribute_types_categories` ( |
| 1273 |
`borrower_attribute_type_code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, |
| 1274 |
`categorycode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, |
| 1275 |
KEY `borrower_attribute_type_code` (`borrower_attribute_type_code`), |
| 1276 |
KEY `categorycode` (`categorycode`), |
| 1277 |
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, |
| 1278 |
CONSTRAINT `borrower_attribute_types_categories_categorycode` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 1279 |
PRIMARY KEY (`borrower_attribute_type_code`, `categorycode`) |
| 1280 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1281 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1282 |
|
| 1268 |
-- |
1283 |
-- |
| 1269 |
-- Table structure for table `borrower_attributes` |
1284 |
-- Table structure for table `borrower_attributes` |
| 1270 |
-- |
1285 |
-- |