재고관리

테이블 (6)

member

  • user_no — VARCHAR(255) — 기본 키 — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

order_item

  • order_item_no — VARCHAR(255) — 기본 키 — NOT NULL
  • quantity — BIGINT — NOT NULL
  • unit_price — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • order_no — VARCHAR(255) — 외래 키 → orders.order_no — NOT NULL
  • product_no — VARCHAR(255) — 외래 키 → product.product_no — NOT NULL

orders

  • order_no — VARCHAR(255) — 기본 키 — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • user_no — VARCHAR(255) — 외래 키 → member.user_no — NOT NULL

product

  • product_no — VARCHAR(255) — 기본 키 — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

product_stock

  • product_stock_no — VARCHAR(255) — 기본 키 — NOT NULL
  • total_quantity — BIGINT — NOT NULL
  • available_quantity — BIGINT — NOT NULL
  • reserved_quantity — BIGINT — NOT NULL
  • sold_quantity — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • product_no — VARCHAR(255) — 외래 키 → product.product_no — NOT NULL

stock_reservation

  • stock_reserve_no — VARCHAR(255) — 기본 키 — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • reserved_quantity — BIGINT — NOT NULL
  • reserved_at — DATETIME — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • confirmed_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • order_no — VARCHAR(255) — 외래 키 → orders.order_no — NOT NULL
  • product_no — VARCHAR(255) — 외래 키 → product.product_no — NOT NULL