CREATE TABLE `venues` (
  `venue_id` int NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier for a venue',
  `venue_name` varchar(200) DEFAULT NULL COMMENT 'Name of the venue hosting the event',
  PRIMARY KEY (`venue_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Venues are places where events are hosted';

CREATE TABLE `venue_seats` (
  `seat_id` int NOT NULL AUTO_INCREMENT COMMENT 'A unique identifier for a seat',
  `row` char(1) NOT NULL COMMENT 'The row designator of a venue; use a hyphen if rows do not apply',
  `seat_number` int NOT NULL COMMENT 'Numeric seat number within a row',
  `venue_id` int NOT NULL COMMENT '''The id of the venue that houses the seat.''',
  PRIMARY KEY (`seat_id`),
  UNIQUE KEY `idx_seatnumber` (`venue_id`,`row`,`seat_number`),
  KEY `FK_venue_seats_venue_idx` (`venue_id`),
  CONSTRAINT `FK_venue_seats_venue` FOREIGN KEY (`venue_id`) REFERENCES `venues` (`venue_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;