온라인 쇼핑몰
테이블 (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