Audit modifiche

Consulta le modifiche registrate dai trigger database. Gli intervalli data/ora sono interpretati come orario italiano Europe/Rome.

Azzera filtri
Filtro record attivo: codice prodotto #196
7 eventi mostrati · offset 0Ordinati dal più recente
QuandoAzioneTabellaRecordContestoSintesi modifiche
27/05/26, 12:44:59Modificaproduct_codes196—
throughput_per_shift: 20 → 150
Dettagli before/after
Diff
{
  "throughput_per_shift": {
    "new": 150,
    "old": 20
  }
}
Prima
{
  "id": 196,
  "code": "SCA0902995",
  "notes": null,
  "active": true,
  "customer": "SCANIA",
  "flow_type": "direct",
  "description": "FRONT COVER",
  "short_label": null,
  "raw_material_id": 77,
  "packaging_quantity": 1,
  "production_flow_id": 1,
  "assembly_throughput": null,
  "throughput_per_shift": 20,
  "external_treatment_status": "none",
  "inventory_source_warehouse": null,
  "inventory_destination_warehouse": null
}
Dopo
{
  "id": 196,
  "code": "SCA0902995",
  "notes": null,
  "active": true,
  "customer": "SCANIA",
  "flow_type": "direct",
  "description": "FRONT COVER",
  "short_label": null,
  "raw_material_id": 77,
  "packaging_quantity": 1,
  "production_flow_id": 1,
  "assembly_throughput": null,
  "throughput_per_shift": 150,
  "external_treatment_status": "none",
  "inventory_source_warehouse": null,
  "inventory_destination_warehouse": null
}
22/05/26, 16:03:27Inserimentoplan_assignments2658—
id: ∅ → 2658; date: ∅ → 2026-05-20; notes: ∅ → ∅; shift: ∅ → T1; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2658,
    "old": null
  },
  "date": {
    "new": "2026-05-20",
    "old": null
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": "T1",
    "old": null
  },
  "status": {
    "new": "completed",
    "old": null
  },
  "machine_id": {
    "new": 15,
    "old": null
  },
  "operator_id": {
    "new": 28,
    "old": null
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "product_code_id": {
    "new": 139,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 196,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2658,
  "date": "2026-05-20",
  "notes": null,
  "shift": "T1",
  "status": "completed",
  "machine_id": 15,
  "operator_id": 28,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 139,
  "planned_quantity": null,
  "produced_quantity": 196,
  "setup_from_product_code_id": null
}
22/05/26, 14:55:36Cancellazioneplan_assignments1679—
id: 1679 → ∅; date: 2026-04-09 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2318 → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 1679
  },
  "date": {
    "new": null,
    "old": "2026-04-09"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2318"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 27
  },
  "operator_id": {
    "new": null,
    "old": 18
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "production"
  },
  "product_code_id": {
    "new": null,
    "old": 115
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 196
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 1679,
  "date": "2026-04-09",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2318",
  "shift": "T2",
  "status": "completed",
  "machine_id": 27,
  "operator_id": 18,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 115,
  "planned_quantity": null,
  "produced_quantity": 196,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:55:36Cancellazioneplan_assignments1677—
id: 1677 → ∅; date: 2026-04-09 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2316 → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 1677
  },
  "date": {
    "new": null,
    "old": "2026-04-09"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2316"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": null
  },
  "operator_id": {
    "new": null,
    "old": 26
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "assembly"
  },
  "product_code_id": {
    "new": null,
    "old": 106
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 196
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 1677,
  "date": "2026-04-09",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2316",
  "shift": "T2",
  "status": "completed",
  "machine_id": null,
  "operator_id": 26,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "assembly",
  "product_code_id": 106,
  "planned_quantity": null,
  "produced_quantity": 196,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:55:36Cancellazioneplan_assignments1625—
id: 1625 → ∅; date: 2026-04-07 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2244 → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 1625
  },
  "date": {
    "new": null,
    "old": "2026-04-07"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2244"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 25
  },
  "operator_id": {
    "new": null,
    "old": 36
  },
  "scrap_by_type": {
    "new": null,
    "old": {
      "workedCasting": 136
    }
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "production"
  },
  "product_code_id": {
    "new": null,
    "old": 114
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 196
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 1625,
  "date": "2026-04-07",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2244",
  "shift": "T2",
  "status": "completed",
  "machine_id": 25,
  "operator_id": 36,
  "scrap_by_type": {
    "workedCasting": 136
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 114,
  "planned_quantity": null,
  "produced_quantity": 196,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:54:47Cancellazioneplan_assignments2214—
id: 2214 → ∅; date: 2026-05-20 → ∅; notes: ∅ → ∅; shift: T1 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 2214
  },
  "date": {
    "new": null,
    "old": "2026-05-20"
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": null,
    "old": "T1"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 15
  },
  "operator_id": {
    "new": null,
    "old": 28
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "production"
  },
  "product_code_id": {
    "new": null,
    "old": 139
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 196
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 2214,
  "date": "2026-05-20",
  "notes": null,
  "shift": "T1",
  "status": "completed",
  "machine_id": 15,
  "operator_id": 28,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 139,
  "planned_quantity": null,
  "produced_quantity": 196,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 12:28:13Inserimentoplan_assignments2214—
id: ∅ → 2214; date: ∅ → 2026-05-20; notes: ∅ → ∅; shift: ∅ → T1; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2214,
    "old": null
  },
  "date": {
    "new": "2026-05-20",
    "old": null
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": "T1",
    "old": null
  },
  "status": {
    "new": "completed",
    "old": null
  },
  "machine_id": {
    "new": 15,
    "old": null
  },
  "operator_id": {
    "new": 28,
    "old": null
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "product_code_id": {
    "new": 139,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 196,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2214,
  "date": "2026-05-20",
  "notes": null,
  "shift": "T1",
  "status": "completed",
  "machine_id": 15,
  "operator_id": 28,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 139,
  "planned_quantity": null,
  "produced_quantity": 196,
  "setup_from_product_code_id": null
}