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