Mysql外键创建酒店客房表
CREATE TABLE ROOMSTATE
(
ROOMSTATEID INT PRIMARY KEY ,
ROOMSTATENAME VARCHAR(255)
);
CREATE TABLE ROOMTYPE
(
TYPEID INT PRIMARY KEY,
TYPENAME VARCHAR(255),
TYPEPRICE NUMBER(5,2),
BEDNUM INT
);
CREATE TABLE ROOM
(
ROOMID INT PRIMARY KEY,
DESCRIPTION VARCHAR(2000),
GUESTNUM INT,
ROOMSTATEID INT ,
ROOMTYPEID INT,
FOREIGN KEY(ROOMSTATEID) REFERENCES ROOMSTATE(ROOMSTATEID),
FOREIGN KEY(ROOMTYPEID) REFERENCES ROOMTYPE(TYPEID)
);
CREATE TABLE GUESTRECORD
(
GUESTID INT PRIMARY KEY,
GUESTNAME VARCHAR(255),
IDENTITYID INT,
RESIDEDATE DATE,
LEAVEDATE DATE,
DEPOSIT NUMBER(10,2),
TOTALMONEY NUMBER(10,2),
ROOMID INT,
FOREIGN KEY(ROOMID) REFERENCES ROOM(ROOMID)
);
CREATE TABLE GOODS
(
GID INT PRIMARY KEY ,
GNAME VARCHAR(255),
GPRICE NUMBER(10,2),
GNUMBER