Pjz7TAQi

1-- MySQL Workbench Forward Engineering
2create database animation_base;
3use animation_base;
4
5SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
6SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
7SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
8
9-- -----------------------------------------------------
10-- Schema Animation_Base
11-- -----------------------------------------------------
12
13-- -----------------------------------------------------
14-- Schema Animation_Base
15-- -----------------------------------------------------
16CREATE SCHEMA IF NOT EXISTS `Animation_Base` DEFAULT CHARACTER SET utf8 ;
17USE `Animation_Base` ;
18
19-- -----------------------------------------------------
20-- Table `Animation_Base`.`Source`
21-- -----------------------------------------------------
22CREATE TABLE IF NOT EXISTS `Animation_Base`.`Source` (
23  `Source_ID` INT NOT NULL AUTO_INCREMENT,
24  `Source_name` VARCHAR(45) NOT NULL,
25  PRIMARY KEY (`Source_ID`))
26ENGINE = InnoDB;
27
28
29-- -----------------------------------------------------
30-- Table `Animation_Base`.`Studio`
31-- -----------------------------------------------------
32CREATE TABLE IF NOT EXISTS `Animation_Base`.`Studio` (
33  `Studio_ID` INT NOT NULL AUTO_INCREMENT,
34  `Studio_name` VARCHAR(45) NOT NULL,
35  `Studio_Foundation` INT NOT NULL,
36  PRIMARY KEY (`Studio_ID`))
37ENGINE = InnoDB;
38
39
40-- -----------------------------------------------------
41-- Table `Animation_Base`.`Producer`
42-- -----------------------------------------------------
43CREATE TABLE IF NOT EXISTS `Animation_Base`.`Producer` (
44  `Producer_ID` INT NOT NULL AUTO_INCREMENT,
45  `Producer_FirstName` VARCHAR(45) NOT NULL,
46  `Producer_SecondName` VARCHAR(45) NOT NULL,
47  PRIMARY KEY (`Producer_ID`))
48ENGINE = InnoDB;
49
50
51-- -----------------------------------------------------
52-- Table `Animation_Base`.`Animation`
53-- -----------------------------------------------------
54CREATE TABLE IF NOT EXISTS `Animation_Base`.`Animation` (
55  `Animation_ID` INT NOT NULL AUTO_INCREMENT,
56  `Animation_name` VARCHAR(45) NOT NULL,
57  `Animation_release` INT NOT NULL,
58  `Animation_rating` VARCHAR(45) NOT NULL,
59  `Animation_score` DECIMAL(3,2) NULL,
60  `Source_ID` INT NULL,
61  `Animation_Season` INT NOT NULL,
62  `Studio_ID` INT NOT NULL,
63  `Producer_ID` INT NOT NULL,
64  PRIMARY KEY (`Animation_ID`),
65  INDEX `source_idx` (`Source_ID` ASC) VISIBLE,
66  INDEX `studio_ID_idx` (`Studio_ID` ASC) VISIBLE,
67  INDEX `Producers_idx` (`Producer_ID` ASC) VISIBLE,
68  CONSTRAINT `source`
69    FOREIGN KEY (`Source_ID`)
70    REFERENCES `Animation_Base`.`Source` (`Source_ID`)
71    ON DELETE CASCADE
72    ON UPDATE CASCADE,
73  CONSTRAINT `studio`
74    FOREIGN KEY (`Studio_ID`)
75    REFERENCES `Animation_Base`.`Studio` (`Studio_ID`)
76    ON DELETE CASCADE
77    ON UPDATE CASCADE,
78  CONSTRAINT `Producers`
79    FOREIGN KEY (`Producer_ID`)
80    REFERENCES `Animation_Base`.`Producer` (`Producer_ID`)
81    ON DELETE CASCADE
82    ON UPDATE CASCADE)
83ENGINE = InnoDB;
84
85
86-- -----------------------------------------------------
87-- Table `Animation_Base`.`Genre`
88-- -----------------------------------------------------
89CREATE TABLE IF NOT EXISTS `Animation_Base`.`Genre` (
90  `Genre_ID` INT NOT NULL AUTO_INCREMENT,
91  `Genre_name` VARCHAR(25) NOT NULL,
92  PRIMARY KEY (`Genre_ID`))
93ENGINE = InnoDB;
94
95
96-- -----------------------------------------------------
97-- Table `Animation_Base`.`Animation_Genre`
98-- -----------------------------------------------------
99CREATE TABLE IF NOT EXISTS `Animation_Base`.`Animation_Genre` (
100  `Animation_ID` INT NOT NULL,
101  `Genre_ID` INT NOT NULL,
102  PRIMARY KEY (`Animation_ID`, `Genre_ID`),
103  INDEX `Genre_idx` (`Genre_ID` ASC) VISIBLE,
104  CONSTRAINT `Anime`
105    FOREIGN KEY (`Animation_ID`)
106    REFERENCES `Animation_Base`.`Animation` (`Animation_ID`)
107    ON DELETE CASCADE
108    ON UPDATE CASCADE,
109  CONSTRAINT `Genre`
110    FOREIGN KEY (`Genre_ID`)
111    REFERENCES `Animation_Base`.`Genre` (`Genre_ID`)
112    ON DELETE CASCADE
113    ON UPDATE CASCADE)
114ENGINE = InnoDB;
115
116
117SET SQL_MODE=@OLD_SQL_MODE;
118SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
119SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;