· 9 years ago · Dec 21, 2016, 10:50 PM
1CREATE TABLE IF NOT EXISTS `online_parking_database`.`parking_space` (
2 `parking_space_id` INT(8) NOT NULL,
3 `occupied_by` VARCHAR(16) NULL DEFAULT NULL,
4 `locations_location_id` VARCHAR(45) NOT NULL,
5 PRIMARY KEY (`parking_space_id`, `locations_location_id`),
6 INDEX `locations_location_id_idx` (`locations_location_id` ASC),
7 CONSTRAINT `locations_location_id`
8 FOREIGN KEY (`locations_location_id`)
9 REFERENCES `online_parking_database`.`locations` (`location_id`)
10 ON DELETE NO ACTION
11 ON UPDATE NO ACTION)
12
13CREATE TABLE IF NOT EXISTS `online_parking_database`.`locations` (
14 `name` VARCHAR(45) NOT NULL,
15 `location_id` VARCHAR(45) NOT NULL,
16 PRIMARY KEY (`location_id`))