Order system

Tables (4)

User (사용자)

  • id (사용자 id) — BIGINT — Primary key — NOT NULL
  • name (이름) — varchar(255)
  • role (역할) — varchar(255) — NOT NULL

order (주문)

  • id (주문 id) — BIGINT — Primary key — NOT NULL
  • user_id (사용자 id) — BIGINT — Foreign key → User.id — NOT NULL
  • order_price (주문가격) — BIGINT — NOT NULL

product (상품)

  • id (상품 id) — BIGINT — Primary key — NOT NULL
  • seller_id (사용자 id) — BIGINT — Foreign key → User.id — NOT NULL
  • product_name (상품이름) — varchar(255) — NOT NULL
  • inventory (재고) — varchar(255) — NOT NULL
  • price (가격) — BIGINT — NOT NULL

product_order_list (상품주문 리스트)

  • id (주문상품 id) — BIGINT — Primary key — NOT NULL
  • product_id (상품번호) — BIGINT — Foreign key → product.id — NOT NULL
  • order_id (주문번호) — BIGINT — Foreign key → order.user_id — NOT NULL
  • quantity (수량) — BIGINT — NOT NULL