KH
Tables (14)
AREA_CODE
- AREA_NO — NUMBER — Primary key — NOT NULL
- AREA_NAME — VARCHAR2(30 BYTE) — NOT NULL
BOOKING
- BOOK_NO — VARCHAR2(100 BYTE) — Primary key — NOT NULL
- USER_NO — NUMBER — NOT NULL
- ROOM_NO — NUMBER — NOT NULL
- BU_TITLE — VARCHAR2(100 BYTE) — NOT NULL
- ROOM_CHECKIN — VARCHAR2(100 BYTE) — NOT NULL
- ROOM_CHECKOUT — VARCHAR2(100 BYTE) — NOT NULL
- STATUS — VARCHAR2(1 BYTE) — NOT NULL
BUSINESS
- BU_ID — VARCHAR2(30BYTE) — Primary key — NOT NULL
- AREA_NO — NUMBER — NOT NULL
- BU_CATEGORY — NUMBER — NOT NULL
- BU_PASSWORD — VARCHAR2(100 BYTE) — NOT NULL
- BU_TEL — VARCHAR2(30 BYTE) — NOT NULL
- BU_USER_NAME — VARCHAR2(15BYTE) — NOT NULL
- BU_ADDRESS — VARCHAR2(100 BYTE) — NOT NULL
- BU_TITLE — VARCHAR2(100BYTE) — NOT NULL
- APPROVAL — VARCHAR2(1 BYTE) — NOT NULL
- BU_IMG_NO — NUMBER — NOT NULL
- ROOM_COUNT — NUMBER — NOT NULL
BU_MAIN_IMG
- FILE_NO — NUMBER — NOT NULL
- BU_ID — VARCHAR2(30BYTE) — NOT NULL
- ORIGIN_NAME — VARCHAR2(1000 BYTE) — NOT NULL
- SAVE_NAME — VARCHAR2(1000 BYTE) — NOT NULL
- FILE_PATH — VARCHAR2(1000 BYTE) — NOT NULL
- STATUS — VARCHAR2(1 BYTE) — NOT NULL
- AREA_NO — NUMBER — NOT NULL
- BU_CATEGORY2 — NUMBER — NOT NULL
CART
- USER_NO — NUMBER — Foreign key → MEMBER.USER_NO — NOT NULL
- ROOM_NO — NUMBER — Foreign key → ROOM.ROOM_NO — NOT NULL
CATEGORY_CODE
- BU_CATEGORY — VARCHAR2(30 BYTE) — Primary key — NOT NULL
- CATEGORY_NAME — VARCHAR2(30 BYTE) — NOT NULL
D_A_CODE
- CODE_NO — NUMBER — Primary key — NOT NULL
- AREA_NO — NUMBER — Foreign key → AREA_CODE.AREA_NO — NOT NULL
- D_A_CODE — NUMBER — NOT NULL
- D_A_NAME — VARCHAR2(30 BYTE) — NOT NULL
MEMBER
- USER_NO — NUMBER — Primary key — NOT NULL
- USER_ID — VARCHAR2(30 BYTE) — NOT NULL
- USER_PWD — VARCHAR2(100 BYTE) — NOT NULL
- USER_NAME — VARCHAR2(15 BYTE) — NOT NULL
- EMAIL — VARCHAR2(100 BYTE) — NOT NULL
- ENROLL_DATE — DATE — NOT NULL
- AUTHORITY — NUMBER — NOT NULL
- STATUS — VARCHAR2(1 BYTE) — NOT NULL
NOTICE
- NOTICE_NO — NUMBER — Primary key — NOT NULL
- USER_NO — NUMBER — NOT NULL
- NOTICE_TITLE — VARCHAR2(400BYTE) — NOT NULL
- NOTICE_CONTENT — CLOB — NOT NULL
- STATUS — VARCHAR2(1BYTE) — NOT NULL
- CREATE_DATE — DATE — NOT NULL
REVIEW
- REVIEW_NO — NUMBER — Primary key — NOT NULL
- USER_NO — NUMBER — NOT NULL
- ROOM_NO — NUMBER — NOT NULL
- BOOK_NO — VARCHAR2(100BYTE) — NOT NULL
- STAR_SCORE — NUMBER
- REVIEW_CONTENT — VARCHAR2(1000 BYTE) — NOT NULL
- REVIEW_AVAILABLE — VARCHAR2(1 BYTE) — NOT NULL
- CREATE_DATE — DATE — NOT NULL
- REVIEW_DECLARIATION — VARCHAR2(1 BYTE) — NOT NULL
- PARENT_REVIEW_NO — VARCHAR2(100 BYTE) — NOT NULL
ROOM
- ROOM_NO — NUMBER — Primary key — NOT NULL
- BU_ID — VARCHAR2(30 BYTE) — NOT NULL
- ROOM_IMG_NO — NUMBER — NOT NULL
- ROOM_COUNT — VARCHAR2(30 BYTE) — NOT NULL
- ROOM_NAME — VARCHAR2(100 BYTE) — NOT NULL
- ROOM_PRICE — VARCHAR2(100 BYTE) — NOT NULL
- ROOM_CHECKIN — VARCHAR2(100 BYTE) — NOT NULL
- ROOM_CHECKOUT — VARCHAR2(100 BYTE) — NOT NULL
- ROOM_INFO — VARCHAR2(1000 BYTE)
ROOM_IMG
- FILE_NO — NUMBER — Primary key — NOT NULL
- ROOM_NO — NUMBER — NOT NULL
- ORIGIN_NAME — VARCHAR2(100 BYTE) — NOT NULL
- SAVE_NAME — VARCHAR2(1000 BYTE) — NOT NULL
- FILE_PATH — VARCHAR2(1000 BYTE) — NOT NULL
- FILE_LEVEL — NUMBER
- STATUS — VARCHAR2(1 BYTE) — NOT NULL
STAR_HISTORY
- STAR_NO — NUMBER — Primary key — NOT NULL
- USER_NO — NUMBER — Foreign key → MEMBER.USER_NO — NOT NULL
- REVIEW_NO — NUMBER — Foreign key → REVIEW.REVIEW_NO — NOT NULL
- STAR_SCORE — NUMBER — NOT NULL
- CREATE_DATE — DATE — NOT NULL
WISHLIST
- USER_NO — NUMBER — Foreign key → MEMBER.USER_NO — NOT NULL
- BU_ID — VARCHAR2(30 BYTE) — Foreign key → BUSINESS.BU_ID — NOT NULL