대략?

테이블 (8)

Category (Untitled5)

  • category_id (Key) — INT — 기본 키 — NOT NULL
  • category_name (Field) — VARCHAR(50)

Inventory (Untitled6)

  • inventory_id (Key2) — INT — 기본 키 — NOT NULL
  • quantity (Field) — INT
  • warehouse_id (Key) — INT — 외래 키 → Warehouse.warehouse_id — NOT NULL
  • product_id (Key3) — INT — 외래 키 → Product.product_id — NOT NULL
  • movement_id (Key22) — INT — 외래 키 → Warehouse.movement_id — NOT NULL

Member (Untitled)

  • member_id (Key) — INT — 기본 키 — NOT NULL
  • name — VARCHAR(50)
  • email — VARCHAR(100)
  • phone — VARCHAR(20)

OrderDatail (Untitled3)

  • order_detail_id (Key) — INT — 기본 키 — NOT NULL
  • order_id (Key2) — INT — 외래 키 → OrderTable.order_id — NOT NULL
  • product_id (Key3) — INT — 외래 키 → Product.product_id — NOT NULL
  • quantity (Field) — INT
  • price (Field2) — DECIMAL(10,2)

OrderTable (Untitled2)

  • order_id (Key) — INT — 기본 키 — NOT NULL
  • order_date (Field) — DATE
  • total_amount — DECIMAL(10,2)
  • status (Field2) — VARCHAR(20)
  • member_id (Key2) — INT — 외래 키 → Member.member_id — NOT NULL

Product (Untitled4)

  • product_id (Key) — INT — 기본 키 — NOT NULL
  • product_name (Field) — VARCHAR(100)
  • price (Field2) — DECIMAL(10,2)
  • size (Field3) — VARCHAR(20)
  • color (Field4) — VARCHAR(20)
  • category_id (Key3) — INT — 외래 키 → Category.category_id — NOT NULL

StockMovement (Untitled8)

  • movement_id (Key) — INT — 기본 키 — NOT NULL
  • quantity (Field) — INT
  • movement|_date (Field2) — DATETIME

Warehouse (Untitled7)

  • warehouse_id (Key) — INT — 기본 키 — NOT NULL
  • movement_id (Key2) — INT — 외래 키 → StockMovement.movement_id — NOT NULL
  • location (Field) — VARCHAR(100)
  • capacity (Field2) — INT