DB/createTables.sql at main · razshely/DB · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
CREATE TABLE Movies
(
  Title VARCHAR(20) NOT NULL,
  length FLOAT NOT NULL,
  Upload_Date DATE,
  rank FLOAT,
  PRIMARY KEY (Title)
);

CREATE TABLE Worker
(
  ID INT NOT NULL,
  name VARCHAR(20) NOT NULL,
  birthday DATE,
  petName VARCHAR(20),
  PRIMARY KEY (ID)
);

CREATE TABLE Cliants
(
  ID INT NOT NULL,
  credit_card INT NOT NULL,
  email VARCHAR(20) NOT NULL,
  PRIMARY KEY (ID)
);

CREATE TABLE Actor
(
  Experience INT NOT NULL,
  Specialty VARCHAR(20)
);

CREATE TABLE Directors
(
  awards INT NOT NULL
);

CREATE TABLE Series
(
  episodes INT NOT NULL,
  Title VARCHAR(20) NOT NULL,
  PRIMARY KEY (Title),
  FOREIGN KEY (Title) REFERENCES Movies(Title)
);

CREATE TABLE language
(
  type VARCHAR(20),
  acsent VARCHAR(20),
  otherLanguageSupurted VARCHAR(20)
);

CREATE TABLE Login
(
  password VARCHAR(20) NOT NULL,
  username VARCHAR(20) NOT NULL,
  PRIMARY KEY (password, username)
);

CREATE TABLE Bill
(
  expire_date DATE NOT NULL,
  bill_ID INT NOT NULL,
  level_user INT NOT NULL,
  ID INT NOT NULL,
  PRIMARY KEY (bill_ID),
  FOREIGN KEY (ID) REFERENCES Cliants(ID)
);

CREATE TABLE genre
(
  gener_ID INT NOT NULL,
  descrption VARCHAR(200),
  PRIMARY KEY (gener_ID)
);

CREATE TABLE Stylist
(
  tools VARCHAR(20) NOT NULL
);