세인티 과제 테스트

테이블 (7)

Inventory

  • warehouse_id — INT — 기본 키 — NOT NULL
  • material_id — INT — 기본 키 — NOT NULL
  • material_name — VARCHAR(255) — NOT NULL
  • quantity — DECIMAL(10,2) — NOT NULL

InventoryHistory

  • history_id — INT
  • warehouse_id — INT — NOT NULL
  • material_id — INT — NOT NULL
  • date — DATE — NOT NULL
  • quantity — DECIMAL(10,2) — NOT NULL

Product

  • product_id — INT
  • name — VARCHAR(255) — NOT NULL

ProductionRecord

  • record_id — INT
  • product_id — INT — NOT NULL
  • production_date — TIMESTAMP
  • quantity_produced — INT — NOT NULL

RawMaterial

  • material_id — INT
  • name — VARCHAR(255) — NOT NULL
  • unit — VARCHAR(50) — NOT NULL

StockTransaction

  • transaction_id — INT
  • material_id — INT — NOT NULL
  • warehouse_id — INT — NOT NULL
  • transaction_type — ENUM('IN', 'OUT') — NOT NULL
  • quantity — DECIMAL(10,2) — NOT NULL
  • transaction_date — TIMESTAMP

Warehouse

  • warehouse_id — INT
  • name — VARCHAR(255) — NOT NULL