-
Notifications
You must be signed in to change notification settings - Fork 1
/
nwc.create
126 lines (107 loc) · 2.46 KB
/
nwc.create
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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
drop table if exists watch;
drop table if exists play;
drop table if exists res_seat_assignments;
drop table if exists seat;
drop table if exists reservation;
drop table if exists theater;
drop table if exists member;
drop table if exists membership;
drop table if exists movie;
drop table if exists cinplex;
create table cinplex
(
name varchar(32),
addr varchar(50),
phone varchar(13),
id int auto_increment NOT NULL,
primary key(id)
)
engine = InnoDB;
create table movie
(
title varchar(32),
descr varchar(150),
runtime int,
rating varchar(6),
stars varchar(1500),
id int auto_increment NOT NULL,
primary key (id)
)
engine = InnoDB;
create table membership
(
acct int NOT NULL auto_increment,
prim_member int NOT NULL references member(id),
start_date date,
end_date date,
primary key (acct)
)
engine = InnoDB;
create table member
(
id int NOT NULL auto_increment,
f_name varchar(50),
l_name varchar(50),
addr varchar(50),
age int,
email varchar(100),
phone varchar(13),
membership_acct int NOT NULL references membership(acct),
primary key (id)
)
engine = InnoDB;
create table theater
(
number int,
cinplex_id varchar(32) references cinplex(id),
cap int,
seat_chart varchar(16),
primary key (number, cinplex_id)
)
engine = InnoDB;
create table seat
(
row int,
col int,
theater_number int references theater(number),
cinplex_id varchar(32) references cinplex(id),
reserv_id int references reservation(id),
primary key (row, col, theater_number, cinplex_id, reserv_id)
)
engine = InnoDB;
create table reservation
(
id int NOT NULL auto_increment,
cinplex int,
theater int,
movie varchar(32),
date_time datetime,
member_id int references member(id),
acct varchar(16) references membership(acct),
primary key (id,member_id, acct)
)
engine = InnoDB;
create table res_seat_assignments
(
reserv_id int references reservation(id),
seat_no varchar(16),
primary key(reserv_id, seat_no)
)
engine = InnoDB;
create table watch
(
member_id int references member(id),
acct varchar(16) references membership(acct),
movie_id int references movie(id),
primary key(member_id, acct, movie_id)
)
engine = InnoDB;
create table play
(
t_num int references theater(number),
cinplex_id varchar(32) references cinplex(id),
showtime datetime,
movie_id int references movie(id),
primary key(t_num, cinplex_id, showtime, movie_id)
)
engine = InnoDB;