wdGL9sUh

1DROP DATABASE IF EXISTS cinema_franchise;
2
3CREATE DATABASE IF NOT EXISTS cinema_franchise;
4
5USE cinema_franchise;
6
7CREATE TABLE IF NOT EXISTS cinema(
8	Id INT NOT NULL AUTO_INCREMENT,
9	Name VARCHAR(30) NOT NULL,
10    Address VARCHAR(35) NOT NULL,
11    PRIMARY KEY (Id)
12);
13
14CREATE TABLE IF NOT EXISTS movie(
15	Id INT NOT NULL AUTO_INCREMENT,
16    Name VARCHAR(30) NOT NULL,
17    Year INT NOT NULL,
18    Genre VARCHAR(15) NOT NULL,
19    Cinema_Id INT NOT NULL,
20    FOREIGN KEY (Cinema_Id) REFERENCES cinema(Id),
21    PRIMARY KEY (Id)
22);
23
24CREATE TABLE IF NOT EXISTS schedule(
25	Id INT NOT NULL AUTO_INCREMENT,
26    Movie_Id INT NOT NULL,
27    Airing_Time DATETIME NOT NULL,
28    FOREIGN KEY (Movie_Id) REFERENCES movie(Id),
29    PRIMARY KEY (Id)
30);
31
32CREATE TABLE IF NOT EXISTS actor(
33	Id INT NOT NULL AUTO_INCREMENT,
34    Name VARCHAR(40) NOT NULL,
35    Birth_Date DATE NOT NULL,
36    PRIMARY KEY (Id)
37);
38
39CREATE TABLE IF NOT EXISTS actor_in_movie(
40	Id INT NOT NULL AUTO_INCREMENT,
41    Actor_Id INT NOT NULL,
42    Movie_Id INT NOT NULL,
43    FOREIGN KEY (Actor_Id) REFERENCES actor(Id),
44    FOREIGN KEY (Movie_Id) REFERENCES movie(Id),
45    PRIMARY KEY (Id)
46);
47
48CREATE TABLE IF NOT EXISTS client(
49	Id INT NOT NULL AUTO_INCREMENT,
50    Name VARCHAR(40) NOT NULL,
51    Email VARCHAR(40) NOT NULL,
52    PRIMARY KEY (Id)
53 );
54
55CREATE TABLE IF NOT EXISTS ticket(
56	Id INT NOT NULL AUTO_INCREMENT,
57    Seat_Number INT NOT NULL,
58    Client_Id INT NOT NULL,
59    Movie_Id INT NOT NULL,
60    FOREIGN KEY (Movie_Id) REFERENCES movie(Id),
61    FOREIGN KEY (Client_Id) REFERENCES client(Id),
62    PRIMARY KEY (Id)
63);