SH
Tables (12)
INTEREST BASKET (관심상품)
- INTEREST_NO — NUMBER — Primary key — NOT NULL
- PRODUCT_NO — NUMBER — Foreign key → PRODUCT.PRODUCT_NO — NOT NULL
- INSTEREST_YN (Field) — CHAR(1)
- BASKET_YN (Field2) — CHAR(1)
- REG_USER_ID — VARCHAR(10)
- REG_DATE — DATE
- MOD_USER_ID — VARCHAR(10)
- MOD_DATE — DATE
PRODUCT (상품)
- PRODUCT_NO — NUMBER — Primary key — NOT NULL
- REG_USER_ID — VARCHAR(10)
- REG_DATE — DATE
- MOD_USER_ID — VARCHAR(10)
- MOD_DATE — DATE
- SALE_FLG — CHAR(1)
- SOLD_OUT — CHAR(1)
PRODUCT_ANSWER (상품답변)
- ANSWER_NO — NUMBER — Primary key — NOT NULL
- QUESTION_NO — NUMBER — Foreign key → PRODUCT_QUESTION.QUESTION_NO — NOT NULL
- PRODUCT_NO — NUMBER — Foreign key → PRODUCT_QUESTION.PRODUCT_NO — NOT NULL
- CONTENT — TEXT
- REG_USER_ID — VARCHAR(10)
- REG_DATE — DATE
- MOD_USER_ID — VARCHAR(10)
- MOD_DATE — DATE
PRODUCT_ATTACH (상품이미지)
- ATTACH_NO — NUMBER — Primary key — NOT NULL
- PRODUCT_NO — NUMBER — Foreign key → PRODUCT.PRODUCT_NO — NOT NULL
- ATTACH_TYPE — VARCHAR(10)
- ATTACH_DIR — VARCHAR(100)
- URL_PATH — VARCHAR(100)
- ORIGINAL_NM — VARCHAR(20)
- REF_FLG — CHAR(1)
- REIVEW_FLG (REIVIEW_FLG) — CHAR(1)
- TITLE_YN — CHAR(1)
- MOD_USER_ID — VARCHAR(10)
- REG_USER_ID — VARCHAR(10)
- REG_DATE — DATE
PRODUCT_COMMENT (상품QA댓글)
- COMMENT_NO — NUMBER — Primary key — NOT NULL
- ANSWER_NO — NUMBER — Foreign key → PRODUCT_ANSWER.ANSWER_NO — NOT NULL
- QUESTION_NO — NUMBER — Foreign key → PRODUCT_ANSWER.QUESTION_NO — NOT NULL
- PRODUCT_NO — NUMBER — Foreign key → PRODUCT_ANSWER.PRODUCT_NO — NOT NULL
- CONTENT — VARCHAR(100)
- REG_USER_ID — VARCHAR(10)
- REG_DATE — DATE
- MOD_USER_ID — VARCHAR(10)
- MOD_DATE — DATE
- PARENT_COMMENT_NO — NUMBER
- REPLY_FLG — CHAR(1)
PRODUCT_DETAIL (상품상세)
- DETAIL_NO — NUMBER — Primary key — NOT NULL
- PRODUCT_NO — NUMBER — Foreign key → PRODUCT.PRODUCT_NO — NOT NULL
- PRODUCT_NM — VARCHAR(20)
- PRODUCT_CAT — VARCHAR(10)
- PRODUC_PRICE — NUMBER
- EDIT_DETAIL — TEXT
- COLOR — VARCHAR(10)
- SIZE — VARCHAR(10)
PRODUCT_QUESTION (상품문의)
- QUESTION_NO — NUMBER — Primary key — NOT NULL
- PRODUCT_NO — NUMBER — Foreign key → PRODUCT.PRODUCT_NO — NOT NULL
- CONTENT — TEXT
- REG_USER_ID — VARCHAR(10)
- REG_DATE — DATE
- MOD_USER_ID — VARCHAR(10)
- MOD_DATE — DATE
PRODUCT_REIVEW (상품리뷰)
- REIVEW_NO (REIVIEW_NO) — NUMBER — Primary key — NOT NULL
- PRODUCT_NO — NUMBER — Foreign key → PRODUCT.PRODUCT_NO — NOT NULL
- CONTENT — TEXT
- REG_USER_ID — VARCHAR(10)
- REG_DATE (REG_USER_DATE) — DATE
- MOD_USER_ID — VARCHAR(10)
- MOD_DATE — DATE
PURCHARSE (상품구매)
- PURCHASE_NO — NUMBER — Primary key — NOT NULL
- TOTAL_PRICE — NUMBER
- PAYMENT_TYPE — VARCHAR(20)
- REG_USER_ID — VARCHAR(10)
- REG_DATE — DATE
- MOD_USER_ID — VARCHAR(10)
- MOD_DATE — DATE
PURCHARSE_CANCLE (상품구매취소)
- CANCLE_NO — NUMBER — Primary key — NOT NULL
- PURCHASE_NO — NUMBER — Foreign key → PURCHARSE.PURCHASE_NO — NOT NULL
- CANCEL_COUNT — NUMBER
- REFUNT_TYPE — VARCHAR(20)
- REFUND_COMPLETE_FLG — CHAR(1)
- PART_REFUNT_FLG — CHAR(1)
- REFUND_PRICE — NUMBER
- REG_USER_ID — VARCHAR(10)
- REG_DATE — DATE
- MOD_USER_ID — VARCHAR(10)
- MOD_DATE — DATE
PURCHASE_DETAIL (상품구매상세)
- PURCHASE_NO — NUMBER — Foreign key → PURCHARSE.PURCHASE_NO — NOT NULL
- PRODUCT_NO — NUMBER — Foreign key → PRODUCT.PRODUCT_NO — NOT NULL
- PRODUCT_CNT — NUMBER
- PRICE_TOTAL — NUMBER
- REG_USER_ID — VARCHAR(10)
- REG_DATE — DATE
- MOD_USER_ID — VARCHAR(10)
- MOD_DATE — DATE
STOCK (재고)
- STOCK_NO — NUMBER — Primary key — NOT NULL
- PRODUCT_NO — NUMBER — Foreign key → PRODUCT.PRODUCT_NO — NOT NULL
- STOCK_AMOUNT — NUMBER
- REG_USER_ID — VARCHAR(10)
- REG_DATE — DATE
- MOD_USER_ID — VARCHAR(10)
- MOD_DATE — DATE
- INSERT_STOCK_DT — DATE
- INSERT_COUNT — NUMBER