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