세인티 과제 테스트
테이블 (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