108
`nomer_dogovor` VARCHAR(45) NOT NULL,
`postacshik` INT NOT NULL,
PRIMARY KEY (`nomer_dogovor`),
INDEX `1_idx` (`postacshik` ASC),
CONSTRAINT `1`
FOREIGN KEY (`postacshik`)
REFERENCES `postavshik_oplata`.`postavshik` (`kod_postavshik`)
ON DELETE CASCADE
ON UPDATE CASCADE)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `postavshik_oplata`.`sdog`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `postavshik_oplata`.`sdog` ;
CREATE TABLE IF NOT EXISTS `postavshik_oplata`.`sdog` (
`nomer_dogovor` VARCHAR(45) NOT NULL,
`kod_izdelia` INT NOT NULL,
`data_dogovor` DATE NOT NULL,
`kolvo` INT NOT NULL,
PRIMARY KEY (`nomer_dogovor`, `kod_izdelia`),
INDEX `3_idx` (`kod_izdelia` ASC),
CONSTRAINT `2`
FOREIGN KEY (`nomer_dogovor`)
REFERENCES `postavshik_oplata`.`dogovor` (`nomer_dogovor`)
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT `3`
FOREIGN KEY (`kod_izdelia`)
REFERENCES `postavshik_oplata`.`izdelie` (`kod_izdelie`)
ON DELETE CASCADE
ON UPDATE CASCADE)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `postavshik_oplata`.`TTN`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `postavshik_oplata`.`TTN` ;
CREATE TABLE IF NOT EXISTS `postavshik_oplata`.`TTN` (
`Nomer_TTN` VARCHAR(45) NOT NULL,
`data_otgruzki` DATE NOT NULL,
`nomer_dogovor` VARCHAR(45) NOT NULL,
PRIMARY KEY (`Nomer_TTN`),
INDEX `4_idx` (`nomer_dogovor` ASC),
CONSTRAINT `4`
109
FOREIGN KEY (`nomer_dogovor`)
REFERENCES `postavshik_oplata`.`dogovor` (`nomer_dogovor`)
ON DELETE CASCADE
ON UPDATE CASCADE)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `postavshik_oplata`.`CTTN`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `postavshik_oplata`.`CTTN` ;
CREATE TABLE IF NOT EXISTS `postavshik_oplata`.`CTTN` (
`Nomer_TTN` VARCHAR(45) NOT NULL,
`kod_izdelie` INT NOT NULL,
`kolvo` INT NOT NULL,
INDEX `7_idx` (`kod_izdelie` ASC),
PRIMARY KEY (`Nomer_TTN`, `kod_izdelie`),
CONSTRAINT `7`
FOREIGN KEY (`kod_izdelie`)
REFERENCES `postavshik_oplata`.`izdelie` (`kod_izdelie`)
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT `8`
FOREIGN KEY (`Nomer_TTN`)
REFERENCES `postavshik_oplata`.`TTN` (`Nomer_TTN`)
ON DELETE CASCADE
ON UPDATE CASCADE)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `postavshik_oplata`.`PP`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `postavshik_oplata`.`PP` ;
CREATE TABLE IF NOT EXISTS `postavshik_oplata`.`PP` (
`Nomer_PP` VARCHAR(45) NOT NULL,
`nomer_TTN` VARCHAR(45) NULL,
`data_oplaty` DATE NULL,
PRIMARY KEY (`Nomer_PP`))
ENGINE = InnoDB;
- -----------------------------------------------------
-- Table `postavshik_oplata`.`SPP`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `postavshik_oplata`.`SPP` ;
CREATE TABLE IF NOT EXISTS `postavshik_oplata`.`SPP` (
`Nomer_PP` VARCHAR(45) NOT NULL,
`nomer_ttn` VARCHAR(45) NOT NULL,
`kod_izdelie` INT NOT NULL,
110
`kolvo` INT NULL,
PRIMARY KEY (`Nomer_PP`, `kod_izdelie`, `nomer_ttn`),
INDEX `150_idx` (`nomer_ttn` ASC, `kod_izdelie` ASC),
CONSTRAINT `11`
FOREIGN KEY (`Nomer_PP`)
REFERENCES `postavshik_oplata`.`PP` (`Nomer_PP`)
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT `150`
FOREIGN KEY (`nomer_ttn` , `kod_izdelie`)
REFERENCES `postavshik_oplata`.`CTTN` (`Nomer_TTN` , `kod_izdelie`)
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;
-- -----------------------------------------------------
-- Data for table `postavshik_oplata`.`ed_izm`
-- -----------------------------------------------------
START TRANSACTION;
USE `postavshik_oplata`;
INSERT INTO `postavshik_oplata`.`ed_izm` (`kod_ed_izm`, `name_ed_izm`)
VALUES (1, 'литр');
INSERT INTO `postavshik_oplata`.`ed_izm` (`kod_ed_izm`, `name_ed_izm`)
VALUES (2, 'шт');
INSERT INTO `postavshik_oplata`.`ed_izm` (`kod_ed_izm`, `name_ed_izm`)
VALUES (3, 'упаковка');
COMMIT;