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