NEWESCAPE
Tables (5)
FAQ
- FAQ_NUM — NUMBER — Primary key — NOT NULL
- FAQ_TITLE — VARCHAR2(60) — NOT NULL
- FAQ_CONTENT — VARCHAR2 — NOT NULL
Q&A
- Q_NUM — NUMBER — Primary key — NOT NULL
- Q_TITLE — VARCHAR2(60) — NOT NULL
- Q_WRITERNAME — VARCHAR2(30) — NOT NULL
- Q_PASSWORD — VARCHAR2(20) — NOT NULL
- Q_CONTENT — VARCHAR2 — NOT NULL
- Q_DATE — DATE — NOT NULL
- Q_VIEWCOUNT — NUMBER — NOT NULL
- Q_COMMENT — NUMBER
RESERVE
- RESERVATION_NUM — NUMBER — Primary key — NOT NULL
- SUBSCRIBER_NAME — VARCHAR(30) — NOT NULL
- SUBSCRIBER_TEL — VARCHAR2(15) — NOT NULL
- SUBSCRIBER_EMAIL — VARCHAR2(60) — NOT NULL
- RESERVATION_PEOPLE — NUMBER(1) — NOT NULL
- PYAMENT_AMOUNT — NUMBER — NOT NULL
- PAYMENT_METHOD — CHAR(1) — NOT NULL — 1
- RESERVATION_TIME — DATE — NOT NULL
- ROOM_NUM — NUMBER — NOT NULL
ROOM
- Key — Primary key — NOT NULL
- ROOM_NUM — NUMBER — NOT NULL
- ROOMNAME — VARCHAR2(60) — NOT NULL
- LEVEL — NUMBER — NOT NULL
- ROOMTIME — NUMBER — NOT NULL
ROOM_RESERVATION
- RESERVATION_TIME — DATE — Primary key — NOT NULL
- ROOM_NUM — NUMBER — Foreign key → ROOM.ROOM_NUM — NOT NULL
- Key — Foreign key → ROOM.Key — NOT NULL
- RESERVATION_STATUS — CHAR(1) — NOT NULL — 1