|
Lines 3276-3282
CREATE TABLE `erm_usage_data_providers` (
Link Here
|
| 3276 |
`requestor_email` varchar(80) DEFAULT NULL COMMENT 'requestor email', |
3276 |
`requestor_email` varchar(80) DEFAULT NULL COMMENT 'requestor email', |
| 3277 |
`report_types` varchar(255) DEFAULT NULL COMMENT 'report types provided by the harvester', |
3277 |
`report_types` varchar(255) DEFAULT NULL COMMENT 'report types provided by the harvester', |
| 3278 |
`service_platform` varchar(80) DEFAULT NULL COMMENT 'platform if provider requires it', |
3278 |
`service_platform` varchar(80) DEFAULT NULL COMMENT 'platform if provider requires it', |
| 3279 |
PRIMARY KEY (`erm_usage_data_provider_id`) |
3279 |
`vendor_id` int(11) DEFAULT NULL COMMENT 'foreign key to aqbooksellers', |
|
|
3280 |
PRIMARY KEY (`erm_usage_data_provider_id`), |
| 3281 |
KEY `erm_usage_data_provider_ibfk_1` (`vendor_id`), |
| 3282 |
CONSTRAINT `erm_usage_data_provider_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE |
| 3280 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3283 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 3281 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3284 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 3282 |
|
3285 |
|
| 3283 |
- |
|
|