Skip to content

Modello dati ​

Scopo ​

Mappare i DocType dell'app ez_factoryos (v0.1.0), relazioni e naming series. Fonte: JSON in apps/ez_factoryos/ez_factoryos/ez_factoryos/doctype/.

Prerequisiti ​

  • Concetti Frappe: DocType, List/Form view, Link, Child table, naming series, permessi per ruolo. Vedi Fondamenti Frappe.

Diagramma ER (anagrafiche + produzione) ​

mermaid
erDiagram
  FactorySupplier ||--o{ FactoryRawMaterial : supplies
  FactorySupplier ||--o{ FactoryPackaging : supplies
  FactoryProductCategory ||--o{ FactoryProduct : classifies
  FactoryProduct ||--o{ FactoryProductMaterialItem : contains
  FactoryProduct ||--o{ FactoryProductPackagingItem : uses
  FactoryProduct ||--o{ FactoryProductLabelItem : labeled
  FactoryRawMaterial ||--o{ FactoryProductMaterialItem : referenced
  FactoryPackaging ||--o{ FactoryProductPackagingItem : referenced
  FactoryProductLabel ||--o{ FactoryProductLabelItem : referenced
  FactoryLine ||--o{ FactoryLineMachineItem : has
  FactoryMachine ||--o{ FactoryLineMachineItem : assigned
  FactoryLine ||--o{ FactoryProduct : default_line
  FactoryShift ||--o{ FactoryOperator : default_shift
  FactoryCustomer ||--o{ FactoryWorkOrder : orders
  FactoryProduct ||--o{ FactoryWorkOrder : produces
  FactoryLine ||--o{ FactoryWorkOrder : on_line
  FactoryMachine ||--o{ MachineCommand : commands
  FactoryMachine ||--o{ MachineEvent : events
  FactoryMachine ||--o{ MachineDataLog : logs

DocType — anagrafiche ​

DocTypeSeries / autonameCampi chiave
Factory CustomerFC-.YYYY.-customer_name, tax_id, is_active, contatti
Factory SupplierFS-.YYYY.-supplier_name, tax_id, is_active
Factory ProductFPR-.YYYY.-product_name, category, default_line, raw_materials, packaging_items, labels
Factory Product Categorycategory_nameis_active, description
Factory Product Labellabel_nameis_active, description
Factory Raw MaterialFRM-.YYYY.-material_name, supplier, uom
Factory PackagingFPK-.YYYY.-packaging_name, supplier, uom
Factory LineFLN-.YYYY.-line_name, child machines
Factory MachineFMC-.YYYY.-vedi Macchine
Factory OperatorFOP-.YYYY.-operator_name, employee_id, default_shift
Factory ShiftFSH-.YYYY.-shift_name, start_time, end_time
Factory Work OrderFWO-.YYYY.-vedi Produzione

Child table ​

ChildParent / fieldCampi
Factory Product Material ItemProduct → raw_materialsraw_material, qty, uom
Factory Product Packaging ItemProduct → packaging_itemspackaging, qty, uom
Factory Product Label ItemProduct → labelslabel
Factory Line Machine ItemLine → machinesmachine

Campi comuni sulle anagrafiche master: naming_series, is_active (default 1), notes.

DocType — macchine / OT ​

DocTypeTipoRuolo
Machine Connection ProfileSingleEnable, base_url, timeout, TLS, stato connessione
Machine CommandMCMD-.YYYY.-Comandi con approvazione e dispatch
Machine EventMEV-.YYYY.-Eventi gateway (idempotenti su external_event_id)
Machine Data LogMDL-.YYYY.-Audit Read / Command / Event

Settings ​

DocTypeContenuto
Ez FactoryOS Settings (Single)Single con i campi Brand cliente (client_name, client_logo, hide_client_logo). La configurazione OT effettiva è in Machine Connection Profile + env (NODE_RED_*)

Perimetro del modello dati ​

Il codice contiene esclusivamente i DocType elencati sopra. Non esistono DocType Lot, Quality Check / Non Conformity, Warehouse / Stock Movement, Production Batch.

Per le attività quotidiane di tracciabilità, qualità e magazzino con gli strumenti esistenti vedi:

Ruoli ​

Creati in install/fixtures: Factory Admin, Production Manager, Line Operator, Warehouse Operator. Permessi nei JSON DocType. Dettaglio operativo: Accesso e Desk.

Verifica ​

bash
# Nel container Frappe
./scripts/bench-exec.sh bench --site factory.local list-apps
# Desk → Ez FactoryOS: anagrafiche e Number Card visibili

In Desk, Awesome Bar → digitare il nome DocType (es. Factory Product) → List view con filtri ed export CSV.

Ez FactoryOS — MES per Ortobellina / OP Raggio di Sole · App Frappe v16 ez_factoryos