系统分析与设计Hw-4

CREATE TABLE `Customer`
(
userID INTEGER NOT NULL,
name VARCHAR(15) NOT NULL,
PRIMARY KEY (userID)
);

CREATE TABLE `Hotel`
(
hotelID INTEGER NOT NULL,
price INTEGER NOT NULL,
name VARCHAR(15),
rank INTEGER NOT NULL,
location VARCHAR(20) NOT NULL,
PRIMARY KEY (hotelID)
);

CREATE TABLE `CreditCard`
(
CardID INTEGER NOT NULL,
limit INTEGER NOT NULL,
PRIMARY KEY (CardID)
);

CREATE TABLE `Order`
(
orderID INTEGER NOT NULL,
hotelID INTEGER NOT NULL,
userID SMALLINT NOT NULL,
startTime DATE NOT NULL,
dueTime TIME NOT NULL,
PRIMARY KEY (orderID)
);