Semi

Tables (8)

BUYLIST (구매목록)

  • ORDER_NUM (주문번호) — Foreign key → ORDER.ID — NOT NULL
  • ITEMS_ID (물품아이디) — Foreign key → ITEMS.ID — NOT NULL
  • CHECK_D (배송,환불여부(1,2,3)) — NOT NULL
  • NUM (주문수량) — NOT NULL

CART (장바구니)

  • ITEMS_ID (물품아이디) — Foreign key → ITEMS.ID — NOT NULL
  • USER_ID (유저아이디) — Foreign key → USER.ID — NOT NULL
  • NUM (주문수량) — NOT NULL

DELIVERY (배송정보)

  • ID (송장번호) — Primary key — NOT NULL
  • ORDER_NUM (주문번호) — Foreign key → ORDER.ID — NOT NULL
  • ITEMS_ID (물품아이디) — Foreign key → ITEMS.ID — NOT NULL
  • OFFICE (배송회사) — NOT NULL

ITEMS (상품)

  • ID (물품아이디) — Primary key — NOT NULL
  • SELLER_ID (셀러아이디) — Foreign key → SELLER.ID — NOT NULL
  • NAME (물품이름) — NOT NULL
  • PRICE (가격) — NOT NULL
  • REGDATE (등록날짜) — NOT NULL
  • CATEGORY (분류) — NOT NULL
  • QT (재고) — NOT NULL
  • INFO (상품정보)
  • RATE (할인율)

ORDER (영수증)

  • ID (주문번호) — Primary key — NOT NULL
  • USER_ID (유저아이디) — Foreign key → USER.ID — NOT NULL
  • BUY_DATE (구매날짜) — NOT NULL
  • TOTAL (구매총액) — NOT NULL

REVIEW (구매후기)

  • ID (게시물번호) — Primary key — NOT NULL
  • USER_ID (유저아이디) — Foreign key → USER.ID — NOT NULL
  • ITEMS_ID (물품아이디) — Foreign key → ITEMS.ID — NOT NULL
  • DATA (REVIEW 내용)
  • REVIEW_DATE (리뷰날짜) — NOT NULL

SELLER (판매자)

  • ID (셀러아이디) — Foreign key → USER.ID — NOT NULL
  • INFO (셀러정보)

USER (사용자)

  • ID (유저아이디) — Primary key — NOT NULL
  • PWD (비밀번호) — NOT NULL
  • NAME (이름) — NOT NULL
  • ADDR (주소)