0EzmA8aS

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 VDO_Store
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema VDO_Store
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `VDO_Store` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
15USE `VDO_Store` ;
16
17-- -----------------------------------------------------
18-- Table `VDO_Store`.`Order`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `VDO_Store`.`Order` (
21  `order_id` INT NOT NULL AUTO_INCREMENT,
22  `cus_id` INT NOT NULL,
23  `movie_id` INT NOT NULL,
24  `count` INT NOT NULL,
25  `Rent_time` DATETIME NOT NULL,
26  `price` INT NOT NULL,
27  `total_price` INT NOT NULL,
28  PRIMARY KEY (`order_id`))
29ENGINE = InnoDB;
30
31
32-- -----------------------------------------------------
33-- Table `VDO_Store`.`Movie`
34-- -----------------------------------------------------
35CREATE TABLE IF NOT EXISTS `VDO_Store`.`Movie` (
36  `movie_id` INT NOT NULL AUTO_INCREMENT,
37  `movie_name` VARCHAR(100) NOT NULL,
38  `movie_type` VARCHAR(60) NOT NULL,
39  `movie_stock` INT NULL,
40  `Order_order_id` INT NOT NULL,
41  PRIMARY KEY (`movie_id`, `Order_order_id`),
42  INDEX `fk_Movie_Order1_idx` (`Order_order_id` ASC),
43  CONSTRAINT `fk_Movie_Order1`
44    FOREIGN KEY (`Order_order_id`)
45    REFERENCES `VDO_Store`.`Order` (`order_id`)
46    ON DELETE NO ACTION
47    ON UPDATE NO ACTION)
48ENGINE = InnoDB;
49
50
51-- -----------------------------------------------------
52-- Table `VDO_Store`.`Movie_type`
53-- -----------------------------------------------------
54CREATE TABLE IF NOT EXISTS `VDO_Store`.`Movie_type` (
55  `id` INT NOT NULL,
56  `type_name` VARCHAR(45) NOT NULL COMMENT 'ประเภทหนัง\n',
57  `Movie_list_movie_id` INT NOT NULL,
58  PRIMARY KEY (`id`, `Movie_list_movie_id`),
59  INDEX `fk_Movie_type_Movie_list_idx` (`Movie_list_movie_id` ASC),
60  CONSTRAINT `fk_Movie_type_Movie_list`
61    FOREIGN KEY (`Movie_list_movie_id`)
62    REFERENCES `VDO_Store`.`Movie` (`movie_id`)
63    ON DELETE NO ACTION
64    ON UPDATE NO ACTION)
65ENGINE = InnoDB;
66
67
68-- -----------------------------------------------------
69-- Table `VDO_Store`.`Stock`
70-- -----------------------------------------------------
71CREATE TABLE IF NOT EXISTS `VDO_Store`.`Stock` (
72  `id` INT NOT NULL,
73  `movie_id` VARCHAR(60) NOT NULL,
74  `movie_type` VARCHAR(45) NOT NULL,
75  `Count` INT NOT NULL,
76  PRIMARY KEY (`id`))
77ENGINE = InnoDB;
78
79
80-- -----------------------------------------------------
81-- Table `VDO_Store`.`Customer`
82-- -----------------------------------------------------
83CREATE TABLE IF NOT EXISTS `VDO_Store`.`Customer` (
84  `cus_id` INT NOT NULL AUTO_INCREMENT,
85  `id_card` VARCHAR(13) NOT NULL,
86  `F_name` VARCHAR(50) NOT NULL,
87  `L_name` VARCHAR(50) NOT NULL,
88  `Address` TEXT NOT NULL,
89  `Tel` VARCHAR(15) NOT NULL,
90  PRIMARY KEY (`cus_id`))
91ENGINE = InnoDB;
92
93
94-- -----------------------------------------------------
95-- Table `VDO_Store`.`table1`
96-- -----------------------------------------------------
97CREATE TABLE IF NOT EXISTS `VDO_Store`.`table1` (
98  `idtable1` INT NOT NULL,
99  PRIMARY KEY (`idtable1`))
100ENGINE = InnoDB;
101
102
103-- -----------------------------------------------------
104-- Table `VDO_Store`.`Movie_has_Order`
105-- -----------------------------------------------------
106CREATE TABLE IF NOT EXISTS `VDO_Store`.`Movie_has_Order` (
107  `Movie_movie_id` INT NOT NULL,
108  `Order_order_id` INT NOT NULL,
109  PRIMARY KEY (`Movie_movie_id`, `Order_order_id`),
110  INDEX `fk_Movie_has_Order_Order1_idx` (`Order_order_id` ASC),
111  INDEX `fk_Movie_has_Order_Movie1_idx` (`Movie_movie_id` ASC),
112  CONSTRAINT `fk_Movie_has_Order_Movie1`
113    FOREIGN KEY (`Movie_movie_id`)
114    REFERENCES `VDO_Store`.`Movie` (`movie_id`)
115    ON DELETE NO ACTION
116    ON UPDATE NO ACTION,
117  CONSTRAINT `fk_Movie_has_Order_Order1`
118    FOREIGN KEY (`Order_order_id`)
119    REFERENCES `VDO_Store`.`Order` (`order_id`)
120    ON DELETE NO ACTION
121    ON UPDATE NO ACTION)
122ENGINE = InnoDB;
123
124
125-- -----------------------------------------------------
126-- Table `VDO_Store`.`Customer_has_Order`
127-- -----------------------------------------------------
128CREATE TABLE IF NOT EXISTS `VDO_Store`.`Customer_has_Order` (
129  `Customer_cus_id` INT NOT NULL,
130  `Order_order_id` INT NOT NULL,
131  PRIMARY KEY (`Customer_cus_id`, `Order_order_id`),
132  INDEX `fk_Customer_has_Order_Order1_idx` (`Order_order_id` ASC),
133  INDEX `fk_Customer_has_Order_Customer1_idx` (`Customer_cus_id` ASC),
134  CONSTRAINT `fk_Customer_has_Order_Customer1`
135    FOREIGN KEY (`Customer_cus_id`)
136    REFERENCES `VDO_Store`.`Customer` (`cus_id`)
137    ON DELETE NO ACTION
138    ON UPDATE NO ACTION,
139  CONSTRAINT `fk_Customer_has_Order_Order1`
140    FOREIGN KEY (`Order_order_id`)
141    REFERENCES `VDO_Store`.`Order` (`order_id`)
142    ON DELETE NO ACTION
143    ON UPDATE NO ACTION)
144ENGINE = InnoDB;
145
146
147SET SQL_MODE=@OLD_SQL_MODE;
148SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
149SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;