온라인 쇼핑몰

테이블 (13)

CART

  • CART_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • RGST_ID — VARCHAR2(20) — NOT NULL
  • UPD_ID — VARCHAR2(20) — NOT NULL
  • RGST_DT — DATE — NOT NULL
  • UPD_DT — DATE — NOT NULL
  • USE_YN — CHAR — NOT NULL
  • MEMBER_ID (Key2) — NUMBER — 외래 키 → MEMBER.MEMBER_ID — NOT NULL

CART_ITEM

  • CART_ITEM_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • PRDC_ID — NUMBER — NOT NULL
  • RGST_ID — VARCHAR2(20) — NOT NULL
  • UPD_ID — VARCHAR2(20) — NOT NULL
  • RGST_DT — DATE — NOT NULL
  • UPD_DT — DATE — NOT NULL
  • USE_YN — CHAR — NOT NULL
  • PRDC_CNT — NUMBER — NOT NULL
  • IMSI_YN — CHAR — NOT NULL
  • CART_ID (Key2) — NUMBER — 외래 키 → CART.CART_ID — NOT NULL

CATEGORY

  • CTGR_ID (Key) — VARCHAR2(20) — 기본 키 — NOT NULL
  • RGST_ID — VARCHAR2(20) — NOT NULL
  • UPD_ID — VARCHAR2(20) — NOT NULL
  • RGST_DT — DATE — NOT NULL
  • USE_YN — CHAR — NOT NULL
  • CTGR_NAME — VARCHAR2(50) — NOT NULL
  • PRNT_CTGR_ID — VARCHAR2(20) — NOT NULL
  • UPD_DT — DATE — NOT NULL

CODE

  • CD_ID (Key) — VARCHAR2(20) — 기본 키 — NOT NULL
  • RGST_ID — VARCHAR2(20) — NOT NULL
  • UPD_ID — VARCHAR2(20) — NOT NULL
  • RGST_DT — DATE — NOT NULL
  • USE_YN — CHAR — NOT NULL
  • CD_GRP — VARCHAR2(10) — NOT NULL
  • CD_NAME — VARCHAR2(50) — NOT NULL
  • CD_GRP_NAME — VARCHAR2(50) — NOT NULL
  • UPD_DT — DATE — NOT NULL

DELIVERY

  • DLVR_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • DLVR_RECV_NAME — VARCHAR2(50) — NOT NULL
  • DLVR_RECV_PHONE — VARCHAR2(20) — NOT NULL
  • DLVR_ZIP_CD — CHAR(5) — NOT NULL
  • DLVR_ADDR — VARCHAR2(200) — NOT NULL
  • DLVR_ADDR_DTL — VARCHAR2(200) — NOT NULL
  • DLVR_MSG — VARCHAR2(500) — NOT NULL
  • RGST_ID — VARCHAR2(20) — NOT NULL
  • UPD_ID — VARCHAR2(20) — NOT NULL
  • RGST_DT — DATE — NOT NULL
  • UPD_DT — DATE — NOT NULL
  • USE_YN — CHAR — NOT NULL
  • DLVR_COST — NUMBER — NOT NULL
  • ORD_ID (Key2) — NUMBER — 외래 키 → ORDERS.ORD_ID — NOT NULL

IMAGE

  • IMG_ID (Key) — VARCHAR2(50) — 기본 키 — NOT NULL
  • RGST_ID — VARCHAR2(20) — NOT NULL
  • UPD_ID — VARCHAR2(20) — NOT NULL
  • RGST_DT — DATE — NOT NULL
  • UPD_DT — DATE — NOT NULL
  • USE_YN — CHAR — NOT NULL
  • IMG_SEQ — NUMBER — NOT NULL
  • ORG_IMG_NAME — VARCHAR2(255) — NOT NULL
  • IMG_PATH — VARCHAR2(260) — NOT NULL
  • CD_SEQ — NUMBER — NOT NULL
  • CD_ID (Key2) — NUMBER — 외래 키 → REVIEW.RVW_ID — NOT NULL — RVW_ID fk
  • CD_ID (Key3) — NUMBER — 외래 키 → PRODUCT.PRDC_ID — NOT NULL — PRDC_ID fk

MEMBER

  • MEMBER_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • RGST_ID — VARCHAR2(20) — NOT NULL
  • UPD_ID — VARCHAR2(20) — NOT NULL
  • RGST_DT — DATE — NOT NULL
  • USE_YN — CHAR — NOT NULL
  • NAME — VARCHAR2(50) — NOT NULL
  • EMAIL — VARCHAR2(100) — NOT NULL
  • PASSWORD — VARCHAR2(100) — NOT NULL
  • PHONE — VARCHAR2(20) — NOT NULL
  • ZIP_CD — CHAR(5) — NOT NULL
  • ADDR — VARCHAR2(200) — NOT NULL
  • ADDR_DTL — VARCHAR2(200) — NOT NULL
  • UPD_DT — DATE — NOT NULL
  • MEMBER_CD (Key2) — VARCHAR2(20) — 외래 키 → CODE.CD_ID — NOT NULL — CD_ID fk

ORDERS

  • ORD_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • RGST_ID — VARCHAR2(20) — NOT NULL
  • UPD_ID — VARCHAR2(20) — NOT NULL
  • RGST_DT — DATE — NOT NULL
  • UPD_DT — DATE — NOT NULL
  • USE_YN — CHAR — NOT NULL
  • ORD_NUMBER — VARCHAR2(100) — NOT NULL
  • MEMBER_ID (Key2) — NUMBER — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
  • ORD_STT_CD (Key3) — VARCHAR2(20) — 외래 키 → CODE.CD_ID — NOT NULL — CD_ID fk

ORDER_ITEM

  • ORD_ITEM_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • RGST_ID — VARCHAR2(20) — NOT NULL
  • UPD_ID — VARCHAR2(20) — NOT NULL
  • RGST_DT — DATE — NOT NULL
  • UPD_DT — DATE — NOT NULL
  • USE_YN — CHAR — NOT NULL
  • PRDC_CNT — NUMBER — NOT NULL
  • RVW_YN — CHAR — NOT NULL
  • ORD_ID (Key2) — NUMBER — 외래 키 → ORDERS.ORD_ID — NOT NULL
  • PRDC_ID (Key3) — NUMBER — 외래 키 → PRODUCT.PRDC_ID — NOT NULL

PAYMENT

  • PYMN_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • PYMN_CMP_CD — VARCHAR2(20) — NOT NULL
  • RGST_ID — VARCHAR2(20) — NOT NULL
  • UPD_ID — VARCHAR2(20) — NOT NULL
  • RGST_DT — DATE — NOT NULL
  • UPD_DT — DATE — NOT NULL
  • USE_YN — CHAR — NOT NULL
  • PYMN_AMNT — NUMBER — NOT NULL
  • ORD_ID (Key2) — NUMBER — 외래 키 → ORDERS.ORD_ID — NOT NULL
  • PYMN_MTHD_CD (Key3) — VARCHAR2(20) — 외래 키 → CODE.CD_ID — NOT NULL — CD_ID fk

PRODUCT

  • PRDC_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • RGST_ID — VARCHAR2(20) — NOT NULL
  • UPD_ID — VARCHAR2(20) — NOT NULL
  • RGST_DT — DATE — NOT NULL
  • USE_YN — CHAR — NOT NULL
  • PRDC_NAME — VARCHAR2(100) — NOT NULL
  • PRICE — NUMBER — NOT NULL
  • PRDC_DSCR — CLOB — NOT NULL
  • PRDC_STCK — NUMBER — NOT NULL
  • UPD_DT — DATE — NOT NULL
  • DLVR_CMP_CD — VARCHAR2(20) — NOT NULL

PRODUCT_CATEGORY

  • PRDC_CTGR_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • USE_YN — CHAR — NOT NULL
  • PRDC_ID (Key2) — NUMBER — 외래 키 → PRODUCT.PRDC_ID — NOT NULL
  • CTGR_ID (Key3) — VARCHAR2(20) — 외래 키 → CATEGORY.CTGR_ID — NOT NULL

REVIEW

  • RVW_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • RGST_ID — VARCHAR2(20) — NOT NULL
  • UPD_ID — VARCHAR2(20) — NOT NULL
  • RGST_DT — DATE — NOT NULL
  • UPD_DT — DATE — NOT NULL
  • USE_YN — CHAR — NOT NULL
  • RVW_DSCR — CLOB — NOT NULL
  • RVW_RATING — CHAR — NOT NULL
  • MEMBER_ID (Key2) — NUMBER — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
  • PRDC_ID (Key3) — NUMBER — 외래 키 → PRODUCT.PRDC_ID — NOT NULL
  • ORD_ID (Key4) — NUMBER — 외래 키 → ORDERS.ORD_ID — NOT NULL