05AFZQuh

1CREATE  TABLE IF NOT EXISTS `Kursinis`.`Padalinys` (
2  `ID` INT NOT NULL AUTO_INCREMENT COMMENT 'Uniklaus padalinio ID' ,
3  `Adreso_ID` VARCHAR(45) NOT NULL ,
4  `Telefonas` VARCHAR(45) NOT NULL COMMENT 'Padalinio telefonas' ,
5  `Pastabos` TEXT NULL COMMENT 'Padakinio pastabos' ,
6  `Sukurimas` DATE NOT NULL ,
7  `Modifikavimas` DATE NULL ,
8  PRIMARY KEY (`ID`, `Adreso_ID`) ,
9  UNIQUE INDEX `ID_UNIQUE` (`ID` ASC) ,
10  INDEX `fk_Padalinys_Adresas1` (`Adreso_ID` ASC) ,
11  CONSTRAINT `fk_Padalinys_Imone_Padalinys1`
12    FOREIGN KEY (`ID` )
13    REFERENCES `Kursinis`.`Imone_Padalinys` (`Padalinys_ID` )
14    ON DELETE NO ACTION
15    ON UPDATE NO ACTION,
16  CONSTRAINT `fk_Padalinys_Adresas1`
17    FOREIGN KEY (`Adreso_ID` )
18    REFERENCES `Kursinis`.`Adresas` (`ID` )
19    ON DELETE NO ACTION
20    ON UPDATE NO ACTION,
21  CONSTRAINT `fk_Padalinys_Darbuotojas_Padalinys1`
22    FOREIGN KEY (`ID` )
23    REFERENCES `Kursinis`.`Darbuotojas_Padalinys` (`Darbuotojas_ID` )
24    ON DELETE NO ACTION
25    ON UPDATE NO ACTION)
26ENGINE = InnoDB;