Identification model

Single asset record, multiple identifiers.

Asset identity is modelled separately from scan values so QR, barcode and RFID can coexist.

AssetIdentifier
  id
  assetId
  type (QR, BARCODE, RFID, SERIAL, OTHER)
  value
  isPrimary
  createdAt
  retiredAt

What this enables

  • Reliable scan-led picking and returns.
  • Clear exception tracking when wrong code is scanned.
  • Future identity expansion without schema rework.

Practical rule

The physical label identifies the unit for proof; the authoritative state remains in server-side Production/workflow logic.