RoomIt

Tables (3)

ADMIN

  • admin_id — VARCHAR2(30)
  • password — VARCHAR2(100) — NOT NULL
  • name — VARCHAR2(50) — NOT NULL

RESERVATION

  • resv_id — NUMBER
  • room_id — NUMBER — NOT NULL
  • customer_name — VARCHAR2(50) — NOT NULL
  • phone — VARCHAR2(20) — NOT NULL
  • checkin_date — DATE — NOT NULL
  • checkout_date — DATE — NOT NULL
  • people_count — NUMBER — NOT NULL
  • resv_time — DATE — NOT NULL
  • status — CHAR(1) — NOT NULL

ROOM

  • room_id — NUMBER
  • room_name — VARCHAR2(50) — NOT NULL
  • max_people — NUMBER — NOT NULL
  • price — NUMBER — NOT NULL
  • description — CLOB
  • image_url — VARCHAR2(200)
  • status — CHAR(1) — NOT NULL