rising-erd

Tables (10)

CartItem (장바구니)

  • 장바구니ID (id) — PRIMARYKEY — Primary key — NOT NULL
  • 수량 (quantity) — NOT NULL
  • 선택옵션 (selected_option) — NOTNULL
  • 유저ID (user_id) — FOREIGNKEY — Foreign key → User.유저ID — NOT NULL
  • 판매자등록ID (vender_product_id) — FOREIGNKEY — Foreign key → VendorProduct.판매자등록ID — NOT NULL

Category (카테코리)

  • 카테고리ID (id) — PRIMARYKEY — Primary key — NOT NULL
  • 카테고리명 (name) — NOTNULL
  • 상위 카테고리ID (category_id) — FOREIGNKEY — Foreign key → Category.카테고리ID — NOT NULL

Option (옵션)

  • 옵션ID (id) — PRIMARYKEY — Primary key — NOT NULL
  • 옵션명 (name) — NOTNULL
  • 설명 (description) — NOTNULL
  • 그룹ID (option_group_id) — FOREIGNKEY — Foreign key → OptionGroup.그룹ID — NOT NULL

OptionGroup (옵션 그룹)

  • 그룹ID (id) — PRIMARYKEY — Primary key — NOT NULL
  • 그룹명 (name) — NOTNULL
  • 상품ID (product_id) — FOREIGNKEY — Foreign key → Products.상품ID — NOT NULL

Order (주문)

  • 주문ID (id) — PRIMARYKEY — Primary key — NOT NULL
  • 주문일시 (order_date) — NOTNULL
  • 총금액 (total_price) — NOTNULL
  • 유저ID (user_id) — FOREINGKEY — Foreign key → User.유저ID — NOT NULL

OrderItem (주문상품별상세)

  • 상세ID (id) — PRIMARYKEY — Primary key — NOT NULL
  • 수량 (quantity) — NOTNULL
  • 옵션 (selected_option) — NOTNULL
  • 단가 (item_price) — NOTNULL
  • 주문ID (order_id) — FOREIGNKEY — Foreign key → Order.주문ID — NOT NULL
  • 판매자등록ID (vender_product_id) — FOREIGNKEY — Foreign key → VendorProduct.판매자등록ID — NOT NULL

Products (상품)

  • 상품ID (id) — PRIMARYKEY — Primary key — NOT NULL
  • 상품명 (name) — NOTNULL
  • 설명 (discription) — NOTNULL
  • 카테고리ID (category_id) — FOREIGNKEY — Foreign key → Category.카테고리ID — NOT NULL

User (유저)

  • 유저ID (id) — PRIMARYKEY — Primary key — NOT NULL
  • 이름 (name) — NOTNULL
  • 비밀번호 (pw) — NOTNULL
  • 이메일 (email) — NOTNULL
  • 생년월일 (birth_date) — NOTNULL
  • 역활 (role) — NOTNULL

VendorProduct (판매자별 상품 등록)

  • 판매자등록ID (id) — PRIMARYKEY — Primary key — NOT NULL
  • 가격 (price) — NOTNULL
  • 재고수량 (stock_quantity) — NOT NULL
  • 판매코드 (vendor_item_code) — NOT NULL
  • 유저ID (user_id) — FOREIGNKEY — Foreign key → User.유저ID — NOT NULL
  • 상품ID (product_id) — FOREIGNKEY — Foreign key → Products.상품ID — NOT NULL

WishList (관심상품)

  • 관심상품ID (id) — PRIMARYKEY — Primary key — NOT NULL
  • 판매자등록ID (vender_product_id) — FOREIGNKEY — Foreign key → VendorProduct.판매자등록ID — NOT NULL
  • 유저ID (user_id) — FOREIGNKEY — Foreign key → User.유저ID — NOT NULL