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)