|
Lines 1256-1270
CREATE TABLE `borrower_attribute_types` (
Link Here
|
| 1256 |
`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)', |
1256 |
`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 |
`authorised_value_category` varchar(32) DEFAULT NULL COMMENT 'foreign key from authorised_values that links this custom field to an authorized value category', |
1257 |
`authorised_value_category` varchar(32) DEFAULT NULL COMMENT 'foreign key from authorised_values that links this custom field to an authorized value category', |
| 1258 |
`display_checkout` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field displays in checkout screens', |
1258 |
`display_checkout` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field displays in checkout screens', |
| 1259 |
`category_code` varchar(10) DEFAULT NULL COMMENT 'defines a category for an attribute_type', |
|
|
| 1260 |
`class` varchar(255) NOT NULL DEFAULT '' COMMENT 'defines a class for an attribute_type', |
1259 |
`class` varchar(255) NOT NULL DEFAULT '' COMMENT 'defines a class for an attribute_type', |
| 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)', |
1260 |
`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)', |
| 1262 |
`mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not in the staff interface', |
1261 |
`mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not in the staff interface', |
| 1263 |
`opac_mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not in the OPAC', |
1262 |
`opac_mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not in the OPAC', |
| 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 |
-- |