online_shop

Tables (6)

member (회원)

  • ID (회원) — BIGINT — Primary key — NOT NULL
  • name (이름) — VARCHAR(255) — NOT NULL
  • role (구분) — ENUM('고객','판매자') — NOT NULL
  • address (주소) — VARCHAR(255) — NOT NULL

orders (주문)

  • ID (주문번호) — BIGINT — Primary key — NOT NULL
  • customer_id (주문자) — BIGINT — Foreign key → member.ID — NOT NULL
  • date (주문날짜) — DATETIME — NOT NULL

orders_product (주문_상품_목록)

  • order_id (주문번호) — BIGINT — Foreign key → orders.ID — NOT NULL
  • product_id (상품번호) — BIGINT — Foreign key → product.ID — NOT NULL
  • quantity (주문수량) — BIGINT — NOT NULL
  • price (주문금액) — BIGINT — NOT NULL
  • size (사이즈) — enum — NOT NULL
  • color (색상) — enum — NOT NULL

product (상품)

  • ID (상품번호) — BIGINT — Primary key — NOT NULL
  • seller_id (판매자id) — BIGINT — Foreign key → member.ID — NOT NULL
  • name (상품이름) — VARCHAR(255) — NOT NULL
  • total_quantity (재고) — BIGINT — NOT NULL
  • price (가격) — BIGINT — NOT NULL

product_col (상품 색상)

  • product_id (상품번호) — BIGINT — Foreign key → product.ID — NOT NULL
  • seller_id (판매자id) — BIGINT — Foreign key → product.seller_id — NOT NULL
  • color (색상) — ENUM — NOT NULL
  • quantity (재고) — BIGINT — NOT NULL

product_size (상품사이즈)

  • product_id (상품번호) — BIGINT — Foreign key → product.ID — NOT NULL
  • seller_id (판매자id) — BIGINT — Foreign key → product.seller_id — NOT NULL
  • size (사이즈) — ENUM — NOT NULL
  • quantity (재고) — BIGINT — NOT NULL