AI_smart_Factory_

Tables (6)

defect_results

  • defect_id — BIGSERIAL
  • line_id — BIGINT — Foreign key → lines.line_id — NOT NULL
  • lot_id — VARCHAR(60) — NOT NULL
  • defect_code — VARCHAR(60) — NOT NULL
  • defect_name — VARCHAR(100) — NOT NULL
  • defect_count — INTEGER
  • severity — VARCHAR(20)
  • recorded_at — TIMESTAMPTZ

employees

  • employee_id — BIGSERIAL
  • employee_no — VARCHAR(30) — NOT NULL
  • employee_name — VARCHAR(100) — NOT NULL
  • role_code — VARCHAR(30) — NOT NULL
  • line_id — BIGINT — Foreign key → lines.line_id

equipments

  • equip_id — BIGSERIAL
  • line_id — BIGINT — Foreign key → lines.line_id — NOT NULL
  • equip_code — VARCHAR(50) — NOT NULL
  • equip_name — VARCHAR(100) — NOT NULL
  • equip_type — VARCHAR(50) — NOT NULL

inspection_results

  • inspection_id — BIGSERIAL
  • line_id — BIGINT — Foreign key → lines.line_id — NOT NULL
  • lot_id — VARCHAR(60) — NOT NULL
  • inspection_type — VARCHAR(50) — NOT NULL
  • total_checked_qty — INTEGER
  • pass_qty — INTEGER
  • fail_qty — INTEGER
  • recorded_at — TIMESTAMPTZ

lines

  • line_id — BIGSERIAL
  • line_code — VARCHAR(30) — NOT NULL
  • line_name — VARCHAR(100) — NOT NULL
  • is_active — BOOLEAN

production_records

  • production_id — BIGSERIAL
  • line_id — BIGINT — Foreign key → lines.line_id — NOT NULL
  • equip_id — BIGINT — Foreign key → equipments.equip_id
  • lot_id — VARCHAR(60) — NOT NULL
  • produced_qty — INTEGER
  • recorded_at — TIMESTAMPTZ