Audit modifiche

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

Azzera filtri

3 eventi mostrati · offset 0Ordinati dal più recente

Quando	Azione	Tabella	Record	Contesto	Sintesi modifiche
27/05/26, 12:44:59	Modifica	product_codes	197	—	throughput_per_shift: 20 → 150 Dettagli before/after Diff { "throughput_per_shift": { "new": 150, "old": 20 } } Prima { "id": 197, "code": "VOA0676593", "notes": null, "active": true, "customer": "VOLVO", "flow_type": "direct", "description": "BRACKET LH", "short_label": null, "raw_material_id": 76, "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": 197, "code": "VOA0676593", "notes": null, "active": true, "customer": "VOLVO", "flow_type": "direct", "description": "BRACKET LH", "short_label": null, "raw_material_id": 76, "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:24	Inserimento	plan_assignments	2571	—	id: ∅ → 2571; date: ∅ → 2026-05-13; notes: ∅ → ∅; shift: ∅ → T2; +10 altri campi Dettagli before/after Diff { "id": { "new": 2571, "old": null }, "date": { "new": "2026-05-13", "old": null }, "notes": { "new": null, "old": null }, "shift": { "new": "T2", "old": null }, "status": { "new": "completed", "old": null }, "machine_id": { "new": 15, "old": null }, "operator_id": { "new": 28, "old": null }, "scrap_by_type": { "new": { "workedCasting": 9 }, "old": null }, "setup_minutes": { "new": null, "old": null }, "assignment_type": { "new": "production", "old": null }, "product_code_id": { "new": 102, "old": null }, "planned_quantity": { "new": null, "old": null }, "produced_quantity": { "new": 197, "old": null }, "setup_from_product_code_id": { "new": null, "old": null } } Prima null Dopo { "id": 2571, "date": "2026-05-13", "notes": null, "shift": "T2", "status": "completed", "machine_id": 15, "operator_id": 28, "scrap_by_type": { "workedCasting": 9 }, "setup_minutes": null, "assignment_type": "production", "product_code_id": 102, "planned_quantity": null, "produced_quantity": 197, "setup_from_product_code_id": null }
22/05/26, 14:55:02	Cancellazione	plan_assignments	2109	—	id: 2109 → ∅; date: 2026-05-13 → ∅; notes: ∅ → ∅; shift: T2 → ∅; +10 altri campi Dettagli before/after Diff { "id": { "new": null, "old": 2109 }, "date": { "new": null, "old": "2026-05-13" }, "notes": { "new": null, "old": null }, "shift": { "new": null, "old": "T2" }, "status": { "new": null, "old": "completed" }, "machine_id": { "new": null, "old": 15 }, "operator_id": { "new": null, "old": 28 }, "scrap_by_type": { "new": null, "old": { "workedCasting": 9 } }, "setup_minutes": { "new": null, "old": null }, "assignment_type": { "new": null, "old": "production" }, "product_code_id": { "new": null, "old": 102 }, "planned_quantity": { "new": null, "old": null }, "produced_quantity": { "new": null, "old": 197 }, "setup_from_product_code_id": { "new": null, "old": null } } Prima { "id": 2109, "date": "2026-05-13", "notes": null, "shift": "T2", "status": "completed", "machine_id": 15, "operator_id": 28, "scrap_by_type": { "workedCasting": 9 }, "setup_minutes": null, "assignment_type": "production", "product_code_id": 102, "planned_quantity": null, "produced_quantity": 197, "setup_from_product_code_id": null } Dopo null

Quando

Azione

Tabella

Record

Contesto

Sintesi modifiche

27/05/26, 12:44:59

Modifica

product_codes

197

—

throughput_per_shift: 20 → 150

Dettagli before/after

Diff

{
  "throughput_per_shift": {
    "new": 150,
    "old": 20
  }
}

Prima

{
  "id": 197,
  "code": "VOA0676593",
  "notes": null,
  "active": true,
  "customer": "VOLVO",
  "flow_type": "direct",
  "description": "BRACKET LH",
  "short_label": null,
  "raw_material_id": 76,
  "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": 197,
  "code": "VOA0676593",
  "notes": null,
  "active": true,
  "customer": "VOLVO",
  "flow_type": "direct",
  "description": "BRACKET LH",
  "short_label": null,
  "raw_material_id": 76,
  "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:24

Inserimento

plan_assignments

2571

—

id: ∅ → 2571; date: ∅ → 2026-05-13; notes: ∅ → ∅; shift: ∅ → T2; +10 altri campi

Dettagli before/after

Diff

{
  "id": {
    "new": 2571,
    "old": null
  },
  "date": {
    "new": "2026-05-13",
    "old": null
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": "T2",
    "old": null
  },
  "status": {
    "new": "completed",
    "old": null
  },
  "machine_id": {
    "new": 15,
    "old": null
  },
  "operator_id": {
    "new": 28,
    "old": null
  },
  "scrap_by_type": {
    "new": {
      "workedCasting": 9
    },
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "product_code_id": {
    "new": 102,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 197,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}

Prima

null

Dopo

{
  "id": 2571,
  "date": "2026-05-13",
  "notes": null,
  "shift": "T2",
  "status": "completed",
  "machine_id": 15,
  "operator_id": 28,
  "scrap_by_type": {
    "workedCasting": 9
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 102,
  "planned_quantity": null,
  "produced_quantity": 197,
  "setup_from_product_code_id": null
}

22/05/26, 14:55:02

Cancellazione

plan_assignments

2109

—

id: 2109 → ∅; date: 2026-05-13 → ∅; notes: ∅ → ∅; shift: T2 → ∅; +10 altri campi

Dettagli before/after

Diff

{
  "id": {
    "new": null,
    "old": 2109
  },
  "date": {
    "new": null,
    "old": "2026-05-13"
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 15
  },
  "operator_id": {
    "new": null,
    "old": 28
  },
  "scrap_by_type": {
    "new": null,
    "old": {
      "workedCasting": 9
    }
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "production"
  },
  "product_code_id": {
    "new": null,
    "old": 102
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 197
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}

Prima

{
  "id": 2109,
  "date": "2026-05-13",
  "notes": null,
  "shift": "T2",
  "status": "completed",
  "machine_id": 15,
  "operator_id": 28,
  "scrap_by_type": {
    "workedCasting": 9
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 102,
  "planned_quantity": null,
  "produced_quantity": 197,
  "setup_from_product_code_id": null
}

Dopo

null