CX PROJECT

Tables (7)

CUSTOMER_ACCOUNT

  • CUSTOMER_ID (CUS_ID) — VARCHAR2(10) — Primary key — NOT NULL
  • CUSTOMER_PW (CUS_PW) — VARCHAR2(255)
  • CUSTOMER_NAME (CUS_NAME) — VARCHAR2(255)
  • CUSTOMER_AGE (CUS_AGE) — VARCHAR2(255)
  • CUSTOMER_CALL (CUS_CALL) — VARCHAR2(255)
  • CUSTOMER_EMAIL (CUS_EMAIL) — VARCHAR2(255)
  • CUSTOMER_ADDRESS (CUS_ADD) — VARCHAR2(200)

CUSTOMER_FEEDBACK

  • RESERVATION_ID (RESERV_ID) — VARCHAR2(20) — Foreign key → RESERVATION.RESERVATION_ID — NOT NULL
  • USER_RATING (U_RATE) — NUMBER
  • FEEDBACK_CONTENTS (FB_CONT) — VARCHAR2(4000)
  • REVIEW_DATE (R_DATE) — DATE

CUSTOMER_REQUEST_HEALTH

  • HEALTH_NO (H_NO) — NUMBER — Primary key — NOT NULL
  • HEALTH_INFO (H_INFO) — VARCHAR2(100)
  • REGISTERED_DATE (H_DATE) — DATE
  • CUSTOMER_ID (CUS_ID) — VARCHAR2(10) — Foreign key → CUSTOMER_ACCOUNT.CUSTOMER_ID — NOT NULL

RESERVATION

  • RESERVATION_ID (RESERV_ID) — VARCHAR2(20) — Primary key — NOT NULL
  • CHECKIN_DATE (CHIN_DATE) — DATE
  • CHECKOUT_DATE (CHOUT_DATE) — DATE
  • GUEST_COUNT (GUEST_CNT) — NUMBER
  • RESERVATION_DATE (RESERV_DATE) — DATE
  • CUSTOMER_ID (CUS_ID) — VARCHAR2(10) — Foreign key → CUSTOMER_ACCOUNT.CUSTOMER_ID — NOT NULL
  • ROOM_NUMBER (R_NUM) — VARCHAR2(10) — Foreign key → ROOMS.ROOM_NUMBER
  • PAY_AMOUNT — NUMBER
  • PAY_DATE — DATE

ROOMS

  • ROOM_NUMBER (R_NUM) — VARCHAR2(10) — Primary key
  • ROOM_TYPE (R_TYPE) — VARCHAR2(20)
  • BED_TYPE (B_TYPE) — VARCHAR2(20)
  • VIEW_TYPE (V_TYPE) — VARCHAR2(20)
  • ROOM_PRICE (R_PRICE) — NUMBER
  • DESCRIPTION (R_DESC) — VARCHAR2(100)
  • ROOM_GUEST_COUNT (R_AVLGUEST) — NUMBER
  • ROOM_AVAILABLE (R_AVL) — CHAR(1)
  • ROOM_STRUCTURE (R_STRUCT) — VARCHAR2(500)
  • CLEAN_STATUS (C_STATUS) — VARCHAR2(20)
  • CHECKINOUT (CIO_STATUS) — VARCHAR2(20)
  • ROOM_CONTROL (R_CONTROL) — VARCHAR2(20)

ROOM_CONDITION

  • ROOM_NUMBER (R_NUM) — VARCHAR2(10) — Foreign key → ROOMS.ROOM_NUMBER
  • ROOM_HUMIDITY (R_HUMID) — NUMBER
  • ROOM_NOISELEVEL (R_NOISE) — NUMBER
  • ROOM_AIRQUAL (R_AIRQ) — NUMBER
  • ROOM_TEPERATURE (R_TEMP) — NUMBER

ROOM_TAG

  • TAG_ID — NUBER — Primary key — NOT NULL
  • ROOM_NUMBER (R_NUM) — VARCHAR2(10) — Foreign key → ROOMS.ROOM_NUMBER
  • TAG_NAME — VARCHAR2(50)