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