Lines 1124-1130
CREATE TABLE `borrower_attribute_types` (
Link Here
|
1124 |
`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)', |
1124 |
`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)', |
1125 |
`mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not', |
1125 |
`mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not', |
1126 |
PRIMARY KEY (`code`), |
1126 |
PRIMARY KEY (`code`), |
1127 |
KEY `auth_val_cat_idx` (`authorised_value_category`) |
1127 |
KEY `auth_val_cat_idx` (`authorised_value_category`), |
|
|
1128 |
KEY `category_code` (`category_code`), |
1129 |
CONSTRAINT `borrower_attribute_types_ibfk_1` FOREIGN KEY (`category_code`) REFERENCES `categories` (`categorycode`) |
1128 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1130 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1129 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1131 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1130 |
|
1132 |
|
1131 |
- |
|
|