|
Lines 286-292
CREATE TABLE `borrower_attribute_types` ( -- definitions for custom patron field
Link Here
|
| 286 |
`staff_searchable` tinyint(1) NOT NULL default 0, -- defines if this field is searchable via the patron search in the staff client (1 for yes, 0 for no) |
286 |
`staff_searchable` tinyint(1) NOT NULL default 0, -- defines if this field is searchable via the patron search in the staff client (1 for yes, 0 for no) |
| 287 |
`authorised_value_category` varchar(10) default NULL, -- foreign key from authorised_values that links this custom field to an authorized value category |
287 |
`authorised_value_category` varchar(10) default NULL, -- foreign key from authorised_values that links this custom field to an authorized value category |
| 288 |
`display_checkout` tinyint(1) NOT NULL default 0,-- defines if this field displays in checkout screens |
288 |
`display_checkout` tinyint(1) NOT NULL default 0,-- defines if this field displays in checkout screens |
| 289 |
`category_code` VARCHAR(1) NOT NULL DEFAULT '',-- defines a category for an attribute_type |
289 |
`category_code` VARCHAR(1) NULL DEFAULT NULL,-- defines a category for an attribute_type |
| 290 |
`class` VARCHAR(255) NOT NULL DEFAULT '',-- defines a class for an attribute_type |
290 |
`class` VARCHAR(255) NOT NULL DEFAULT '',-- defines a class for an attribute_type |
| 291 |
PRIMARY KEY (`code`), |
291 |
PRIMARY KEY (`code`), |
| 292 |
KEY `auth_val_cat_idx` (`authorised_value_category`) |
292 |
KEY `auth_val_cat_idx` (`authorised_value_category`) |
| 293 |
- |
|
|