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 #154
3 eventi mostrati · offset 0Ordinati dal più recente
QuandoAzioneTabellaRecordContestoSintesi modifiche
27/05/26, 12:44:59Modificaproduct_codes154—
assembly_throughput: 18.8 → 141; throughput_per_shift: 8 → 60
Dettagli before/after
Diff
{
  "assembly_throughput": {
    "new": 141,
    "old": 18.8
  },
  "throughput_per_shift": {
    "new": 60,
    "old": 8
  }
}
Prima
{
  "id": 154,
  "code": "VPF002878101",
  "notes": null,
  "active": true,
  "customer": "MARVAL",
  "flow_type": "assembly",
  "description": "SPACER L128",
  "short_label": null,
  "raw_material_id": 53,
  "packaging_quantity": 3,
  "production_flow_id": 2,
  "assembly_throughput": 18.8,
  "throughput_per_shift": 8,
  "external_treatment_status": "none",
  "inventory_source_warehouse": null,
  "inventory_destination_warehouse": null
}
Dopo
{
  "id": 154,
  "code": "VPF002878101",
  "notes": null,
  "active": true,
  "customer": "MARVAL",
  "flow_type": "assembly",
  "description": "SPACER L128",
  "short_label": null,
  "raw_material_id": 53,
  "packaging_quantity": 3,
  "production_flow_id": 2,
  "assembly_throughput": 141,
  "throughput_per_shift": 60,
  "external_treatment_status": "none",
  "inventory_source_warehouse": null,
  "inventory_destination_warehouse": null
}
22/05/26, 14:55:24Cancellazioneplan_assignments1842—
id: 1842 → ∅; date: 2026-04-22 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2586 → ∅; shift: T1 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 1842
  },
  "date": {
    "new": null,
    "old": "2026-04-22"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2586"
  },
  "shift": {
    "new": null,
    "old": "T1"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": null
  },
  "operator_id": {
    "new": null,
    "old": 33
  },
  "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": 134
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 154
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 1842,
  "date": "2026-04-22",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2586",
  "shift": "T1",
  "status": "completed",
  "machine_id": null,
  "operator_id": 33,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "assembly",
  "product_code_id": 134,
  "planned_quantity": null,
  "produced_quantity": 154,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:55:08Cancellazioneplan_assignments2044—
id: 2044 → ∅; date: 2026-05-07 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2892 → ∅; shift: T1 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 2044
  },
  "date": {
    "new": null,
    "old": "2026-05-07"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2892"
  },
  "shift": {
    "new": null,
    "old": "T1"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": null
  },
  "operator_id": {
    "new": null,
    "old": 29
  },
  "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": 103
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 154
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 2044,
  "date": "2026-05-07",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2892",
  "shift": "T1",
  "status": "completed",
  "machine_id": null,
  "operator_id": 29,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "assembly",
  "product_code_id": 103,
  "planned_quantity": null,
  "produced_quantity": 154,
  "setup_from_product_code_id": null
}
Dopo
null