Lithium-ion Battery Production & Quality MES
Tables (13)
bom
- id — VARCHAR(36) — NOT NULL
- product_code — VARCHAR(50) — NOT NULL
- material_id — VARCHAR(36) — Foreign key → materials.id — NOT NULL
- qty_per_unit — DECIMAL(15,4) — NOT NULL
- unit — VARCHAR(20) — NOT NULL
defect_types
- id — VARCHAR(36) — NOT NULL
- code — VARCHAR(20) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- description — TEXT
- is_active — BOOLEAN — NOT NULL
defects
- id — VARCHAR(36) — NOT NULL
- inspection_id — VARCHAR(36) — Foreign key → inspections.id — NOT NULL
- defect_type_id — VARCHAR(36) — Foreign key → defect_types.id — NOT NULL
- defect_code — VARCHAR(20) — NOT NULL
- severity — ENUM('CRITICAL','MAJOR','MINOR') — NOT NULL
- description — TEXT
- created_at — TIMESTAMP — NOT NULL
equipment
- id — VARCHAR(36) — NOT NULL
- eq_code — VARCHAR(50) — NOT NULL
- eq_name — VARCHAR(200) — NOT NULL
- eq_type — VARCHAR(50) — NOT NULL
- status — ENUM('RUNNING','IDLE','DOWN','PM') — NOT NULL
- last_pm_at — TIMESTAMP
equipment_logs
- id — VARCHAR(36) — NOT NULL
- equipment_id — VARCHAR(36) — Foreign key → equipment.id — NOT NULL
- log_type — ENUM('BREAKDOWN','PM','ALERT') — NOT NULL
- description — TEXT — NOT NULL
- occurred_at — TIMESTAMP — NOT NULL
- reported_by — VARCHAR(36) — Foreign key → users.id — NOT NULL
inspections
- id — VARCHAR(36) — NOT NULL
- lot_id — VARCHAR(36) — Foreign key → lots.id — NOT NULL
- work_order_id — VARCHAR(36) — Foreign key → work_orders.id
- inspector_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
- process_type — ENUM('IQC','IPQC','OQC') — NOT NULL
- inspection_item — VARCHAR(200) — NOT NULL
- spec_min — DECIMAL(10,4)
- spec_max — DECIMAL(10,4)
- measured_value — DECIMAL(10,4) — NOT NULL
- result — ENUM('PASS','FAIL') — NOT NULL
- inspected_at — TIMESTAMP — NOT NULL
- remarks — TEXT
- is_deleted — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
lots
- id — VARCHAR(36) — NOT NULL
- lot_number — VARCHAR(50) — NOT NULL
- product_name — VARCHAR(200) — NOT NULL
- quantity — INT — NOT NULL
- status — ENUM('IN_PROGRESS','COMPLETED','HOLD') — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
materials
- id — VARCHAR(36) — NOT NULL
- mat_code — VARCHAR(50) — NOT NULL
- mat_name — VARCHAR(200) — NOT NULL
- mat_type — ENUM('RAW','SEMI','CONSUMABLE') — NOT NULL
- stock_qty — DECIMAL(15,4) — NOT NULL
- unit — VARCHAR(20) — NOT NULL
process_params
- id — VARCHAR(36) — NOT NULL
- work_order_id — VARCHAR(36) — Foreign key → work_orders.id — NOT NULL
- param_name — VARCHAR(100) — NOT NULL
- target_value — DECIMAL(10,4)
- actual_value — DECIMAL(10,4) — NOT NULL
- unit — VARCHAR(20) — NOT NULL
- upper_limit — DECIMAL(10,4)
- lower_limit — DECIMAL(10,4)
- measured_at — TIMESTAMP — NOT NULL
spc_data
- id — VARCHAR(36) — NOT NULL
- lot_id — VARCHAR(36) — Foreign key → lots.id — NOT NULL
- work_order_id — VARCHAR(36) — Foreign key → work_orders.id
- parameter_name — VARCHAR(100) — NOT NULL
- subgroup_no — INT — NOT NULL
- sample_values — TEXT — NOT NULL — JSON array
- x_bar — DECIMAL(10, 4)
- range_value — DECIMAL(10, 4)
- ucl — DECIMAL(10, 4)
- cl — DECIMAL(10, 4)
- lcl — DECIMAL(10, 4)
- measured_at — TIMESTAMP — NOT NULL
users
- id — VARCHAR(36) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- role — ENUM('USER','ADMIN','OPERATOR') — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
work_assignments
- id — VARCHAR(36) — NOT NULL
- work_order_id — VARCHAR(36) — Foreign key → work_orders.id — NOT NULL
- user_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
- role — ENUM('OPERATOR','LEADER','INSPECTOR') — NOT NULL
- start_at — TIMESTAMP — NOT NULL
- end_at — TIMESTAMP
work_orders
- id — VARCHAR(36) — NOT NULL
- wo_number — VARCHAR(50) — NOT NULL
- lot_id — VARCHAR(36) — Foreign key → lots.id — NOT NULL
- equipment_id — VARCHAR(36) — Foreign key → equipment.id — NOT NULL
- process_type — ENUM('전극','조립','화성','검사') — NOT NULL
- status — ENUM('PLANNED','RUNNING','DONE','HOLD') — NOT NULL
- target_qty — INT — NOT NULL
- actual_qty — INT — NOT NULL
- planned_start — TIMESTAMP — NOT NULL
- actual_start — TIMESTAMP
- actual_end — TIMESTAMP