q2E5Pv87

1Sending...
210:58 AM
3DROP TABLE IF EXISTS `building_amenities`;
4CREATE TABLE `building_amenities` (
5  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
6  `building_id` bigint(20) unsigned DEFAULT NULL,
7  `amenity_id` bigint(20) unsigned DEFAULT NULL,
8  `amenity_value` varchar(255) DEFAULT NULL,
9  `amenity_brand` varchar(255) DEFAULT NULL,
10  `created_at` timestamp NULL DEFAULT NULL,
11  `updated_at` timestamp NULL DEFAULT NULL,
12  PRIMARY KEY (`id`),
13  KEY `building_amenities_building_id_foreign` (`building_id`),
14  KEY `building_amenities_amenity_id_foreign` (`amenity_id`),
15  CONSTRAINT `building_amenities_amenity_id_foreign` FOREIGN KEY (`amenity_id`) REFERENCES `amenities` (`id`) ON DELETE CASCADE,
16  CONSTRAINT `building_amenities_building_id_foreign` FOREIGN KEY (`building_id`) REFERENCES `buildings` (`id`) ON DELETE CASCADE
17) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;