Разработка веб-приложения на тему "Организация въездного туризма в Республике Беларусь"

INDEX `fk_tour_has_tourType_tourType1_idx` (`tourType_idtourType` ASC, `tourType_typeName` ASC),

INDEX `fk_tour_has_tourType_tour1_idx` (`tour_idtour` ASC),

CONSTRAINT `fk_tour_has_tourType_tour1`

FOREIGN KEY (`tour_idtour`)

REFERENCES `tripstoredb`.`tour` (`idtour`)

ON DELETE NO ACTION

ON UPDATE NO ACTION,

CONSTRAINT `fk_tour_has_tourType_tourType1`

FOREIGN KEY (`tourType_idtourType`, `tourType_typeName`)

REFERENCES `tripstoredb`.`tourType` (`idtourType`, `typeName`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

CREATE TABLE IF NOT EXISTS `tripstoredb`.`GroupPrice` (

`idGroupPrices` INT NOT NULL AUTO_INCREMENT,

`num1` INT NULL,

`num2` INT NULL,

`price_idprice` INT NOT NULL,

PRIMARY KEY (`idGroupPrices`),

INDEX `fk_GroupPrices_price1_idx` (`price_idprice` ASC),

CONSTRAINT `fk_GroupPrices_price1`

FOREIGN KEY (`price_idprice`)

REFERENCES `tripstoredb`.`price` (`idprice`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

CREATE TABLE IF NOT EXISTS `tripstoredb`.`InPrice` (

`idInPrice` INT NOT NULL AUTO_INCREMENT,

`includeText` TINYTEXT NULL,

`price_idprice` INT NOT NULL,

PRIMARY KEY (`idInPrice`),

INDEX `fk_InPrice_price1_idx` (`price_idprice` ASC),

CONSTRAINT `fk_InPrice_price1`

FOREIGN KEY (`price_idprice`)

REFERENCES `tripstoredb`.`price` (`idprice`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

CREATE TABLE IF NOT EXISTS `tripstoredb`.`touragent` (

`idtouragent` INT NOT NULL AUTO_INCREMENT,

`TourFirm_idTourOperator` INT NOT NULL,

PRIMARY KEY (`idtouragent`),

INDEX `fk_touragent_TourFirm1_idx` (`TourFirm_idTourOperator` ASC),

CONSTRAINT `fk_touragent_TourFirm1`

FOREIGN KEY (`TourFirm_idTourOperator`)

REFERENCES `tripstoredb`.`TourFirm` (`idTourOperator`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

CREATE TABLE IF NOT EXISTS `tripstoredb`.`Document` (

`idDocument` INT NOT NULL AUTO_INCREMENT,

`docName` VARCHAR(45) NOT NULL,

`touragent_idtouragent` INT NOT NULL,

PRIMARY KEY (`idDocument`),

INDEX `fk_Document_touragent1_idx` (`touragent_idtouragent` ASC),

CONSTRAINT `fk_Document_touragent1`

FOREIGN KEY (`touragent_idtouragent`)

REFERENCES `tripstoredb`.`touragent` (`idtouragent`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

CREATE TABLE IF NOT EXISTS `tripstoredb`.`agreement` (

`idagreement` INT NOT NULL AUTO_INCREMENT,

`docnumber` INT NOT NULL,

`user_iduser` INT NOT NULL,

`touragent_idtouragent` INT NOT NULL,

PRIMARY KEY (`idagreement`),

INDEX `fk_agreement_user1_idx` (`user_iduser` ASC),

INDEX `fk_agreement_touragent1_idx` (`touragent_idtouragent` ASC),

CONSTRAINT `fk_agreement_user1`

FOREIGN KEY (`user_iduser`)

REFERENCES `tripstoredb`.`user` (`iduser`)

ON DELETE NO ACTION

ON UPDATE NO ACTION,

CONSTRAINT `fk_agreement_touragent1`

FOREIGN KEY (`touragent_idtouragent`)

REFERENCES `tripstoredb`.`touragent` (`idtouragent`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

CREATE TABLE IF NOT EXISTS `tripstoredb`.`message` (

`idmessage` INT NOT NULL AUTO_INCREMENT,

`messagetext` LONGTEXT NOT NULL,

`messagetheme` VARCHAR(45) NOT NULL,

`user_iduser` INT NOT NULL,

`touragent_idtouragent` INT NOT NULL,

PRIMARY KEY (`idmessage`),

INDEX `fk_message_user1_idx` (`user_iduser` ASC),

INDEX `fk_message_touragent1_idx` (`touragent_idtouragent` ASC),

CONSTRAINT `fk_message_user1`

FOREIGN KEY (`user_iduser`)

REFERENCES `tripstoredb`.`user` (`iduser`)

ON DELETE NO ACTION

ON UPDATE NO ACTION,

CONSTRAINT `fk_message_touragent1`

FOREIGN KEY (`touragent_idtouragent`)

REFERENCES `tripstoredb`.`touragent` (`idtouragent`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

CREATE TABLE IF NOT EXISTS `tripstoredb`.`requisites` (

`idrequisites` INT NOT NULL AUTO_INCREMENT,

`requisitescol` VARCHAR(45) NULL,

`touragent_idtouragent` INT NOT NULL,

PRIMARY KEY (`idrequisites`),

INDEX `fk_requisites_touragent1_idx` (`touragent_idtouragent` ASC),

CONSTRAINT `fk_requisites_touragent1`

FOREIGN KEY (`touragent_idtouragent`)

REFERENCES `tripstoredb`.`touragent` (`idtouragent`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

CREATE TABLE IF NOT EXISTS `tripstoredb`.`street` (

`idstreet` INT NOT NULL AUTO_INCREMENT,

`streetname` VARCHAR(45) NOT NULL,

`Address_idAddress` INT NOT NULL,

`lang_idlang` INT NOT NULL,

PRIMARY KEY (`idstreet`),

INDEX `fk_street_Address1_idx` (`Address_idAddress` ASC),

INDEX `fk_street_lang1_idx` (`lang_idlang` ASC),

CONSTRAINT `fk_street_Address1`

FOREIGN KEY (`Address_idAddress`)

REFERENCES `tripstoredb`.`Address` (`idAddress`)

ON DELETE NO ACTION

ON UPDATE NO ACTION,

CONSTRAINT `fk_street_lang1`

FOREIGN KEY (`lang_idlang`)

REFERENCES `tripstoredb`.`lang` (`idlang`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

CREATE TABLE IF NOT EXISTS `tripstoredb`.`Place_has_CheckPoint` (

`Place_idPlace` INT NOT NULL,

`CheckPoint_idCheckPoint` INT NOT NULL,

PRIMARY KEY (`Place_idPlace`, `CheckPoint_idCheckPoint`),

INDEX `fk_Place_has_CheckPoint_CheckPoint1_idx` (`CheckPoint_idCheckPoint` ASC),

INDEX `fk_Place_has_CheckPoint_Place1_idx` (`Place_idPlace` ASC),

CONSTRAINT `fk_Place_has_CheckPoint_Place1`

FOREIGN KEY (`Place_idPlace`)

REFERENCES `tripstoredb`.`Place` (`idPlace`)

ON DELETE NO ACTION

ON UPDATE NO ACTION,

CONSTRAINT `fk_Place_has_CheckPoint_CheckPoint1`

FOREIGN KEY (`CheckPoint_idCheckPoint`)

REFERENCES `tripstoredb`.`CheckPoint` (`idCheckPoint`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

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