Hpx8h4RR

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10-- -----------------------------------------------------
11-- Schema productdb
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema productdb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `productdb` DEFAULT CHARACTER SET utf8 ;
18USE `productdb` ;
19
20-- -----------------------------------------------------
21-- Table `productdb`.`companytime`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `productdb`.`companytime` (
24  `Company_Name` VARCHAR(45) NOT NULL,
25  `time_capacity` INT(8) NOT NULL,
26  PRIMARY KEY (`Company_Name`))
27ENGINE = InnoDB
28DEFAULT CHARACTER SET = utf8;
29
30
31-- -----------------------------------------------------
32-- Table `productdb`.`productdb`
33-- -----------------------------------------------------
34CREATE TABLE IF NOT EXISTS `productdb`.`productdb` (
35  `product_id` INT(2) NOT NULL AUTO_INCREMENT,
36  `name` VARCHAR(255) NOT NULL,
37  `time_produce_minutes` INT(3) NULL DEFAULT NULL,
38  `unit_cost` INT(8) NULL DEFAULT NULL,
39  `Company_Name` VARCHAR(45) NULL DEFAULT NULL,
40  PRIMARY KEY (`product_id`, `name`),
41  INDEX `fk_productdb_companytime1_idx` (`Company_Name` ASC),
42  CONSTRAINT `fk_productdb_companytime1`
43    FOREIGN KEY (`Company_Name`)
44    REFERENCES `productdb`.`companytime` (`Company_Name`)
45    ON DELETE NO ACTION
46    ON UPDATE NO ACTION)
47ENGINE = InnoDB
48AUTO_INCREMENT = 3
49DEFAULT CHARACTER SET = utf8;
50
51
52-- -----------------------------------------------------
53-- Table `productdb`.`product_data`
54-- -----------------------------------------------------
55CREATE TABLE IF NOT EXISTS `productdb`.`product_data` (
56  `product_id` INT(2) NOT NULL,
57  `priority` INT(31) NULL DEFAULT NULL,
58  `turnover` INT(31) NULL DEFAULT NULL,
59  `costs` INT(31) NULL DEFAULT NULL,
60  `margin` INT(31) NULL DEFAULT NULL,
61  `work_hours` INT(31) NULL DEFAULT NULL,
62  `difference_margin_hour` INT(31) NULL DEFAULT NULL,
63  `difference_hours` INT(31) NULL DEFAULT NULL,
64  `sum_difference_hours` INT(31) NULL DEFAULT NULL,
65  INDEX `fk_productdb_has_productinfo_productdb1_idx` (`product_id` ASC),
66  CONSTRAINT `fk_productdb_has_productinfo_productdb1`
67    FOREIGN KEY (`product_id`)
68    REFERENCES `productdb`.`productdb` (`product_id`)
69    ON DELETE NO ACTION
70    ON UPDATE NO ACTION)
71ENGINE = InnoDB
72DEFAULT CHARACTER SET = utf8;
73
74
75-- -----------------------------------------------------
76-- Table `productdb`.`productinfo`
77-- -----------------------------------------------------
78CREATE TABLE IF NOT EXISTS `productdb`.`productinfo` (
79  `product_id` INT(2) NULL DEFAULT NULL,
80  `unit_value` INT(10) NULL DEFAULT NULL,
81  `amount` INT(10) NULL DEFAULT NULL,
82  `id_each` INT(2) NOT NULL AUTO_INCREMENT,
83  PRIMARY KEY (`id_each`),
84  INDEX `fk_productinfo_productdb_idx` (`product_id` ASC),
85  CONSTRAINT `fk_productinfo_productdb`
86    FOREIGN KEY (`product_id`)
87    REFERENCES `productdb`.`productdb` (`product_id`)
88    ON DELETE NO ACTION
89    ON UPDATE NO ACTION)
90ENGINE = InnoDB
91AUTO_INCREMENT = 10
92DEFAULT CHARACTER SET = utf8;
93
94
95SET SQL_MODE=@OLD_SQL_MODE;
96SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
97SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;