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