Проектирование информационной системы для автоматизации процесса продажи туров

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `worldb`.`Airport`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `worldb`.`Airport` (

`id_Airport` INT UNSIGNED NOT NULL AUTO_INCREMENT,

`Name` VARCHAR(20) NOT NULL,

`id_City` INT UNSIGNED NOT NULL,

`last_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id_Airport`),

INDEX `fk_Airport_City1_idx` (`id_City` ASC),

CONSTRAINT `fk_Airport_City1`

FOREIGN KEY (`id_City`)

REFERENCES `worldb`.`City` (`id_City`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `worldb`.`Flight`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `worldb`.`Flight` (

`id_Flight` INT UNSIGNED NOT NULL AUTO_INCREMENT,

`id_Airline` INT UNSIGNED NOT NULL,

`Number` INT UNSIGNED NOT NULL,

`id_Airport_depart` INT UNSIGNED NOT NULL,

`id_Airport_arrival` INT UNSIGNED NOT NULL,

`date_depart` DATETIME NOT NULL,

`date_arrival` DATETIME NOT NULL,

`last_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id_Flight`),

INDEX `fk_Flight_Airline1_idx` (`id_Airline` ASC),

INDEX `fk_Flight_Airport1_idx` (`id_Airport_depart` ASC),

INDEX `fk_Flight_Airport2_idx` (`id_Airport_arrival` ASC),

CONSTRAINT `fk_Flight_Airline1`

FOREIGN KEY (`id_Airline`)

REFERENCES `worldb`.`Airline` (`id_Airline`)

ON DELETE NO ACTION

ON UPDATE NO ACTION,

CONSTRAINT `fk_Flight_Airport1`

FOREIGN KEY (`id_Airport_depart`)

REFERENCES `worldb`.`Airport` (`id_Airport`)

ON DELETE NO ACTION

ON UPDATE NO ACTION,

CONSTRAINT `fk_Flight_Airport2`

FOREIGN KEY (`id_Airport_arrival`)

REFERENCES `worldb`.`Airport` (`id_Airport`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `worldb`.`Flight_has_Tour`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `worldb`.`Flight_has_Tour` (

`id_Flight` INT UNSIGNED NOT NULL,

`id_Tour` INT UNSIGNED NOT NULL,

`last_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id_Flight`, `id_Tour`),

INDEX `fk_Flight_has_Tour_Tour1_idx` (`id_Tour` ASC),

INDEX `fk_Flight_has_Tour_Flight1_idx` (`id_Flight` ASC),

CONSTRAINT `fk_Flight_has_Tour_Flight1`

FOREIGN KEY (`id_Flight`)

REFERENCES `worldb`.`Flight` (`id_Flight`)

ON DELETE NO ACTION

ON UPDATE NO ACTION,

CONSTRAINT `fk_Flight_has_Tour_Tour1`

FOREIGN KEY (`id_Tour`)

REFERENCES `worldb`.`Tour` (`id_Tour`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `worldb`.`TypeApp_has_Hotel`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `worldb`.`TypeApp_has_Hotel` (

`id_TypeApp` INT UNSIGNED NOT NULL,

`id_Hotel` INT UNSIGNED NOT NULL,

`last_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id_TypeApp`, `id_Hotel`),

INDEX `fk_TypeApp_has_Hotel_Hotel1_idx` (`id_Hotel` ASC),

INDEX `fk_TypeApp_has_Hotel_TypeApp1_idx` (`id_TypeApp` ASC),

CONSTRAINT `fk_TypeApp_has_Hotel_TypeApp1`

FOREIGN KEY (`id_TypeApp`)

REFERENCES `worldb`.`TypeApp` (`id_TypeApp`)

ON DELETE NO ACTION

ON UPDATE NO ACTION,

CONSTRAINT `fk_TypeApp_has_Hotel_Hotel1`

FOREIGN KEY (`id_Hotel`)

REFERENCES `worldb`.`Hotel` (`id_Hotel`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `worldb`.`Photo_Resort`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `worldb`.`Photo_Resort` (

`id_Photo_Resort` INT UNSIGNED NOT NULL,

`id_Resort` INT UNSIGNED NOT NULL,

`Photo` BLOB NOT NULL,

`last_update` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id_Photo_Resort`),

INDEX `fk_Photo_Resort_Resort1_idx` (`id_Resort` ASC),

CONSTRAINT `fk_Photo_Resort_Resort1`

FOREIGN KEY (`id_Resort`)

REFERENCES `worldb`.`Resort` (`id_Resort`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `worldb`.`Photo_hotel`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `worldb`.`Photo_hotel` (

`id_Photo_hotel` INT UNSIGNED NOT NULL AUTO_INCREMENT,

`id_Hotel` INT UNSIGNED NOT NULL,

`Photo` BLOB NOT NULL,

`last_update` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id_Photo_hotel`),

INDEX `fk_Photo_hotel_Hotel1_idx` (`id_Hotel` ASC),

CONSTRAINT `fk_Photo_hotel_Hotel1`

FOREIGN KEY (`id_Hotel`)

REFERENCES `worldb`.`Hotel` (`id_Hotel`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `worldb`.`Country_has_Currency`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `worldb`.`Country_has_Currency` (

`Country_id` INT UNSIGNED NOT NULL,

`Currency_id_Currency` INT UNSIGNED NOT NULL,

PRIMARY KEY (`Country_id`, `Currency_id_Currency`),

INDEX `fk_Country_has_Currency_Currency1_idx` (`Currency_id_Currency` ASC),

INDEX `fk_Country_has_Currency_Country1_idx` (`Country_id` ASC),

CONSTRAINT `fk_Country_has_Currency_Country1`

FOREIGN KEY (`Country_id`)

REFERENCES `worldb`.`Country` (`id`)

ON DELETE NO ACTION

ON UPDATE NO ACTION,

CONSTRAINT `fk_Country_has_Currency_Currency1`

FOREIGN KEY (`Currency_id_Currency`)

REFERENCES `worldb`.`Currency` (`id_Currency`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

SET SQL_MODE=@OLD_SQL_MODE;

SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;

SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

Размещено на Allbest.ru