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
|
CREATE TABLE `Elocation`
(
code INTEGER NOT NULL,
name VARCHAR(20) NOT NULL,
hot VARCHAR NOT NULL,
PRIMARY KEY (code)
);
CREATE TABLE `EHotel`
(
hotel_id INTEGER NOT NULL,
name VARCHAR(20) NOT NULL,
intro LONGTEXT NOT NULL,
star_rating INTEGER NOT NULL,
hot_index VARCHAR(20) NOT NULL,
address VARCHAR(20) NOT NULL,
PRIMARY KEY (hotel_id)
);
CREATE TABLE `Eroom_desc`
(
desc_id INTEGER NOT NULL,
type VARCHAR(10) NOT NULL,
list_price FLOAT NOT NULL,
PRIMARY KEY (desc_id)
);
CREATE TABLE `Eroom`
(
room_id INTEGER NOT NULL,
num INTEGER NOT NULL,
isavaliable BIT NOT NULL,
date DATE NOT NULL,
PRIMARY KEY (room_id)
);
CREATE TABLE `EReservation`
(
reservation_id INTEGER NOT NULL,
check_in_date DATE NOT NULL,
check_out_date DATE NOT NULL,
nights_num INTEGER NOT NULL,
total_price FLOAT NOT NULL,
PRIMARY KEY (reservation_id)
);
CREATE TABLE `customerInfo`
(
customer_id INTEGER NOT NULL,
full_name VARCHAR(20) NOT NULL,
email_address VARCHAR(20) NOT NULL,
Dr_Miss BIT NOT NULL,
isSmoke BIT NOT NULL,
PRIMARY KEY (customer_id)
);
CREATE TABLE `Eorder_item`
(
item_id INTEGER NOT NULL,
adult_num INTEGER NOT NULL,
children_num INTEGER NOT NULL,
min_child_num INTEGER NOT NULL,
max_child_num INTEGER NOT NULL,
PRIMARY KEY (item_id)
);
|
