order

Tables (5)

category (카테고리)

  • 카테고리id (category_id) — bigint — Primary key — NOT NULL
  • 품목 (category) — varchar(10) — NOT NULL

order (주문)

  • 주문ID (order_id) — Primary key — NOT NULL
  • 구매자ID (buyer_id) — bigint — Foreign key → user.유저ID — NOT NULL
  • 주문날짜 (order_date) — datetime — NOT NULL

order_detail (주문상세정보)

  • 상품ID (product_id) — bigint — Foreign key → product.상품ID — NOT NULL
  • 주문ID (order_id) — Foreign key → order.주문ID — NOT NULL
  • 수량 (amount) — bigint — NOT NULL

product (상품)

  • 상품ID (product_id) — bigint — Primary key — NOT NULL
  • 상품이름 (product_name) — VARCHAR(255) — NOT NULL
  • 판매자ID (seller_id) — bigint — Foreign key → user.유저ID — NOT NULL
  • 카테고리id (category_id) — bigint — Foreign key → category.카테고리id — NOT NULL
  • 재고 (inventory) — bigint — NOT NULL
  • 가격 (price) — bigint — NOT NULL

user (유저)

  • 유저ID (user_id) — bigint — Primary key — NOT NULL
  • 이름 (name) — varchar(255) — NOT NULL
  • 나이 (age) — bigint — NOT NULL
  • 성별 (gender) — ENUM('M', 'W') — NOT NULL
  • 이용분류 (type) — ENUM('Seller', 'Buyer') — NOT NULL
  • 주소 (address) — varchar(255) — NOT NULL