這邊是建立資料表的SQL語法,會創建
顧客表
CREATE TABLE CUSTOMER (
CUSTOMER_ID NUMBER PRIMARY KEY,
NAME VARCHAR2(50) NOT NULL,
PHONE VARCHAR2(20) NOT NULL,
EMAIL VARCHAR2(50),
ADDRESS VARCHAR2(100)
);
菜單表
CREATE TABLE MENU (
MENU_ID NUMBER PRIMARY KEY,
MEAL_NAME VARCHAR2(50) NOT NULL,
TYPE VARCHAR2(30),
PRICE DECIMAL(10,2) NOT NULL,
DETAIL VARCHAR2(100)
);
預約表
CREATE TABLE RESERVATION (
RESERVATION_ID NUMBER PRIMARY KEY,
CUSTOMER_ID NUMBER REFERENCES CUSTOMER(CUSTOMER_ID) NOT NULL,
RESERVATION_ID DATE NOT NULL,
TIME VARCHAR(10) NOT NULL,
TABLE NUMBER NOT NULL,
PEOPLE_AMOUNT INT NOT NULL,
TOTAL DECIMAL(10,2),
);
預約明細表
**CREATE TABLE RESERVATION_DETAIL (
RESERVATION_ID NUMBER PRIMARY KEY REFERENCES REVERSATION(RESERVATION_ID) NOT NULL,
MENU_ID NUMBER REFERENCES MENU(MEAL_ID) NOT NULL,
AMOUNT NUMBER NOT NULL,
PRIMARY KEY (REVERSATION_ID, MEAL_ID),
);**