Shopping

Tables (6)

Member (회원)

  • ID (회원ID) — BIGINT — Primary key — NOT NULL
  • name (회원 이름) — VARCHAR(255) — NOT NULL
  • roll (회원 역할) — ENUM(seller, user) — NOT NULL
  • email (회원 이메일) — VARCHAR(255) — NOT NULL
  • address (회원 주소) — VARCHAR(255) — NOT NULL

Order (주문)

  • ID (주문 ID) — BIGINT — Primary key — NOT NULL
  • member_ID (회원ID) — BIGINT — Foreign key → Member.ID — NOT NULL
  • date (주문 날짜) — DATE — NOT NULL
  • total_price (총 금액) — int — NOT NULL

Order_Detail (주문 상세)

  • ID (주문 상세 ID) — BIGINT — Primary key — NOT NULL
  • order_ID (주문 ID) — BIGINT — Foreign key → Order.ID — NOT NULL
  • product_ID (제품 ID) — BIGINT — Foreign key → Product.ID — NOT NULL
  • count (제품 개수) — int — NOT NULL
  • price (금액) — int — NOT NULL

Product (제품)

  • ID (제품 ID) — BIGINT — Primary key — NOT NULL
  • member_ID (회원ID) — BIGINT — Foreign key → Member.ID — NOT NULL
  • name (제품 이름) — VARCHAR(255) — NOT NULL
  • price (제품 가격) — int — NOT NULL
  • stock (제품 재고) — int — NOT NULL
  • detail (제품 설명) — VARCHAR(255)

SellerRank (판매자 랭크)

  • ID (판매자 랭크 ID) — BIGINT — Primary key — NOT NULL
  • member_ID (회원ID) — BIGINT — Foreign key → Member.ID — NOT NULL
  • rank (판매자 랭크) — VARCHAR(255) — NOT NULL
  • total_trade (총 판매량) — int — NOT NULL

UserRank (구매자 랭크)

  • ID (판매자 랭크 ID) — BIGINT — Primary key — NOT NULL
  • member_ID (회원ID) — BIGINT — Foreign key → Member.ID — NOT NULL
  • rank (판매자 랭크) — VARCHAR(255) — NOT NULL
  • total_trade (총 판매량) — int — NOT NULL