erd1
Tables (24)
CART
- REG_ID — VARCHAR2(15) — Foreign key → REGISTER_PROD.REG_ID — NOT NULL
- USER_ID — VARCHAR2(20) — Foreign key → USERS.USER_ID — NOT NULL
- PEOPLE_CNT — NUMBER(3) — NOT NULL
COUNTRY
- CTRY_ID — VARCHAR2(25)
- CTRY_NAME — VARCHAR2(30) — NOT NULL
- REGION_NAME — VARCHAR2(20)
EMAIL_VERIFIED
- EMAIL — VARCHAR2(200)
- VERIFIED_AT — DATE — NOT NULL
- TOKEN — VARCHAR2(64) — Foreign key → EMAIL_VERIFY_TOKEN.TOKEN — NOT NULL
EMAIL_VERIFY_TOKEN
- TOKEN — VARCHAR2(64)
- EMAIL — VARCHAR2(200) — NOT NULL
- EXPIRES_AT — DATE — NOT NULL
- USED_YN — CHAR(1) — NOT NULL
- CREATED_AT — DATE — NOT NULL
HOTELS
- HOTEL_ID — VARCHAR2(24)
- HOTEL_NAME — VARCHAR2(30)
- HOTEL_CODE — VARCHAR2(10)
- LOC_ID — VARCHAR2(10) — Foreign key → LOCATION.LOC_ID — NOT NULL
- HOTEL_TEL — VARCHAR2(14)
IMG_MAPPING
- MAP_NO — NUMBER(3)
- REG_ID — VARCHAR2(15) — Foreign key → REGISTER_PROD.REG_ID — NOT NULL
- IMG_NO — NUMBER(3) — Foreign key → IMG_STORAGE.IMG_NO — NOT NULL
- VIEW_SEQUENCE — NUMBER
IMG_STORAGE
- IMG_NO — NUMBER(3)
- IMG_PATH — VARCHAR2(100) — NOT NULL
- ORIGIN_NAME — VARCHAR2(50) — NOT NULL
- FILE_SIZE — NUMBER(10)
ITEM
- ITEM_ID — VARCHAR2(20)
- ITEM_TITLE — VARCHAR2(200)
- LOC_ID — VARCHAR2(10) — Foreign key → LOCATION.LOC_ID
- THEME_ID — VARCHAR2(20) — Foreign key → I_THEME.ITH_ID
ITEM_IMG_MAPPING
- MAP_NO — NUMBER — Primary key — NOT NULL
- ITEM_ID — VARCHAR2(20) — Foreign key → ITEM.ITEM_ID — NOT NULL
- IMG_NO — NUMBER — Foreign key → IMG_STORAGE.IMG_NO — NOT NULL
I_THEME
- ITH_ID — VARCHAR2(20)
- ITH_TITLE — VARCHAR2(50)
- THEME_ID — VARCHAR2(10) — Foreign key → P_THEME.THEME_ID — NOT NULL
LOCATION
- LOC_ID — VARCHAR2(10)
- CTRY_ID — VARCHAR2(25) — Foreign key → COUNTRY.CTRY_ID — NOT NULL
- LOC_NAME — VARCHAR2(40)
ORDERS
- ORDER_NO — VARCHAR2(20)
- USER_ID — VARCHAR2(20) — Foreign key → USERS.USER_ID — NOT NULL
- TOTAL_PRICE — NUMBER(12) — NOT NULL
- ORDER_DATE — DATE — NOT NULL
- ORDER_STATUS — VARCHAR2(20) — NOT NULL
ORDER_ITEM
- REG_ID — VARCHAR2(15) — Foreign key → REGISTER_PROD.REG_ID — NOT NULL
- ORDER_NO — VARCHAR2(20) — Foreign key → ORDERS.ORDER_NO — NOT NULL
- ORDER_QTY — NUMBER(2) — NOT NULL
- UNIT_PRICE — NUMBER(12) — NOT NULL
- ITEM_TOTAL — NUMBER(12) — NOT NULL
PACKAGES
- PACKAGE_ID — VARCHAR2(20)
- PACKAGE_TITLE — VARCHAR2(200)
- CTRY_ID — VARCHAR2(25) — Foreign key → COUNTRY.CTRY_ID
- THEME_ID — VARCHAR2(10) — Foreign key → P_THEME.THEME_ID
- LOC_ID — VARCHAR2(20) — Foreign key → LOCATION.LOC_ID
PACKAGE_ITEM
- PITEM_NO — NUMBER(4)
- PACKAGE_ID — VARCHAR2(20) — Foreign key → PACKAGES.PACKAGE_ID — NOT NULL
- ITEM_ID — VARCHAR2(20) — Foreign key → ITEM.ITEM_ID
- HOTEL_ID — VARCHAR2(24) — Foreign key → HOTELS.HOTEL_ID
- BY_DATE — VARCHAR2(20)
PAYMENT
- PAY_NO — NUMBER(10)
- IMP_UID — VARCHAR2(50) — NOT NULL
- PAY_METHOD — VARCHAR2(20) — NOT NULL
- PAY_AMOUNT — NUMBER(12) — NOT NULL
- PAY_STATUS — VARCHAR2(20) — NOT NULL
- REQUEST_AT — DATE
- PAID_AT — DATE
- FAIL_REASON — VARCHAR2(200)
- ORDER_NO — VARCHAR2(20) — Foreign key → ORDERS.ORDER_NO
P_THEME
- THEME_ID — VARCHAR2(10)
- THEME_TITLE — VARCHAR2(30)
QNA_BOARD
- QNA_NO — NUMBER(10)
- USER_ID — VARCHAR2(20) — Foreign key → USERS.USER_ID — NOT NULL
- QNA_TITLE — VARCHAR2(180) — NOT NULL
- QNA_CTT — VARCHAR2(3000) — NOT NULL
- QNA_STATUS — VARCHAR2(20) — NOT NULL
- QNA_CREATED — DATE — NOT NULL
- QNA_UPDATE — DATE
- ANS_CTT — VARCHAR2(2000)
- ANS_AT — DATE
- IS_NOTICE — CHAR(1) — NOT NULL
- QNA_HIT — NUMBER(10) — NOT NULL
- DEL_YN — CHAR(1) — NOT NULL
- DEL_AT — DATE
- DEL_BY — VARCHAR2(30)
REFUND
- REFUND_NO — NUMBER(10)
- PAY_NO — NUMBER(10) — Foreign key → PAYMENT.PAY_NO — NOT NULL
- REFUND_AMOUNT — NUMBER(12) — NOT NULL
- REFUND_STATUS — VARCHAR2(20) — NOT NULL
- REFUND_DATE — DATE — NOT NULL
- REASON — VARCHAR2(200)
REGISTER_PROD
- REG_ID — VARCHAR2(15)
- PACKAGE_ID — VARCHAR2(20) — Foreign key → PACKAGES.PACKAGE_ID — NOT NULL
- REG_TITLE — VARCHAR2(200)
- REG_DATE — DATE
- REG_PRICE — NUMBER(10)
- REG_QTY — NUMBER(3)
- FOR_SALE — CHAR(1)
- START_DT — DATE
- END_DT — DATE
- SALE_START_DT — DATE
- SALE_END_DT — DATE
- HIGHLIGHT — VARCHAR2(400)
- DESCRIPTION_A — VARCHAR2(500)
- DESCRIPTION_B — VARCHAR2(500)
REPLY
- RE_NUM — NUMBER(10)
- USER_ID — VARCHAR2(20) — Foreign key → USERS.USER_ID — NOT NULL
- QNA_NO — NUMBER(10) — Foreign key → QNA_BOARD.QNA_NO
- REVIEW_NO — NUMBER(10) — Foreign key → REVIEW_BOARD.REVIEW_NO
- PARENT_RE_NUM — NUMBER(10) — Foreign key → REPLY.RE_NUM
- RE_CTT — VARCHAR2(2000) — NOT NULL
- RE_CREATE — DATE — NOT NULL
- RE_UPDATE — DATE
REVIEW_BOARD
- REVIEW_NO — NUMBER(10)
- USER_ID — VARCHAR2(20) — Foreign key → USERS.USER_ID — NOT NULL
- REVIEW_RATING — NUMBER(1) — NOT NULL
- REVIEW_CTT — VARCHAR2(3000) — NOT NULL
- REVIEW_CREATED — DATE — NOT NULL
- REVIEW_UPDATE — DATE
- ORDER_NO — VARCHAR2(20) — Foreign key → ORDERS.ORDER_NO
- REVIEW_TITLE — VARCHAR2(180)
- REVIEW_HIT — NUMBER(10) — NOT NULL
- DEL_YN — CHAR(1) — NOT NULL
- DEL_AT — DATE
- DEL_BY — VARCHAR2(30)
USERS
- USER_ID — VARCHAR2(20)
- USER_PASS — VARCHAR2(60) — NOT NULL
- ROLE — VARCHAR2(20) — NOT NULL
- USER_NAME — VARCHAR2(30) — NOT NULL
- USER_BIR — DATE
- USER_EMAIL — VARCHAR2(200) — Foreign key → EMAIL_VERIFIED.EMAIL — NOT NULL
- USER_TEL — VARCHAR2(20) — NOT NULL
- USER_ADDR1 — VARCHAR2(100)
- USER_ADDR2 — VARCHAR2(100)
- USER_ZIP — CHAR(7)
WISHLIST
- REG_ID — VARCHAR2(15) — Foreign key → REGISTER_PROD.REG_ID — NOT NULL
- USER_ID — VARCHAR2(20) — Foreign key → USERS.USER_ID — NOT NULL
- WISH_DT — DATE