Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE `stroiOrganizacia`;
- USE `stroiOrganizacia` ;
- CREATE TABLE IF NOT EXISTS `stroiOrganizacia`.`stroi_objekt` (
- `id_stroi_objekt` INT NOT NULL ,
- PRIMARY KEY (`id_stroi_objekt`)
- );
- CREATE TABLE IF NOT EXISTS `stroiOrganizacia`.`stroi_upravlenie` (
- `id_stroi_upravlenie` INT NOT NULL AUTO_INCREMENT ,
- `id_stroi_objekt` INT NOT NULL ,
- PRIMARY KEY (`id_stroi_upravlenie`) ,
- FOREIGN KEY (`id_stroi_objekt` )
- REFERENCES `stroiOrganizacia`.`stroi_objekt` (`id_stroi_objekt` )
- );
- CREATE TABLE IF NOT EXISTS `stroiOrganizacia`.`stroi_raboti` (
- `id_stroi_raboti` INT NOT NULL AUTO_INCREMENT ,
- `id_stroi_upravlenie` INT NOT NULL ,
- `vid_raboti` VARCHAR(45) NULL ,
- `stoimost` INT UNSIGNED NULL ,
- PRIMARY KEY (`id_stroi_raboti`) ,
- FOREIGN KEY (`id_stroi_upravlenie` )
- REFERENCES `stroiOrganizacia`.`stroi_upravlenie` (`id_stroi_upravlenie` )
- );
- CREATE TABLE IF NOT EXISTS `stroiOrganizacia`.`stroi_technika` (
- `id_stroi_technika` INT NOT NULL AUTO_INCREMENT ,
- `id_stroi_upravlenie` INT NOT NULL ,
- `Naimenovanie` VARCHAR(45) NULL ,
- PRIMARY KEY (`id_stroi_technika`) ,
- FOREIGN KEY (`id_stroi_upravlenie` )
- REFERENCES `stroiOrganizacia`.`stroi_upravlenie` (`id_stroi_upravlenie` )
- );
- CREATE TABLE IF NOT EXISTS `stroiOrganizacia`.`stroi_rabochie` (
- `FIO` VARCHAR(45) NOT NULL ,
- `kategoria` VARCHAR(45) NULL ,
- `Dolgnost` VARCHAR(45) NULL ,
- `Brigada` INT NULL ,
- `id_stroi_upravlenie` INT NOT NULL ,
- PRIMARY KEY (`FIO`) ,
- FOREIGN KEY (`id_stroi_upravlenie` )
- REFERENCES `stroiOrganizacia`.`stroi_upravlenie` (`id_stroi_upravlenie` )
- );
Add Comment
Please, Sign In to add comment