measure

{“what”:“Unique integer identifier for each measure row.”,“why”:“Without it, rows cannot be uniquely referenced by foreign keys or updates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.786819904+00:00”}

{“what”:“Integer identifier of the database table the measure is defined on.”,“why”:“Without it, the measure’s scope is unknown, so it cannot be computed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.812386602+00:00”}

{“what”:“Integer identifier of the user who created the measure.”,“why”:“Without it, ownership and audit trail for the measure is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.859806103+00:00”}

{“what”:“Short human-readable name for the measure, e.g., ‘Total Revenue’.”,“why”:“Without it, measures cannot be displayed or referenced in UI/API.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.885268535+00:00”}

{“what”:“Free-form text explaining the measure’s purpose or calculation.”,“why”:“Without it, context for future maintainers is missing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:37.024936024+00:00”}

{“what”:“Flag indicating whether the measure is soft-deleted (true) or active (false).”,“why”:“Without it, inactive measures would still appear in lists and computations.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:37.109303773+00:00”}

{“what”:“The actual formula or SQL expression that computes the measure.”,“why”:“Without it, the measure cannot be evaluated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:37.143878613+00:00”}

{“what”:“UTC timestamp when the measure row was inserted.”,“why”:“Without it, creation time is unknown, affecting audit and ordering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:37.178529095+00:00”}

{“what”:“UTC timestamp of the last update to the measure row.”,“why”:“Without it, stale definitions cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:37.247966211+00:00”}

{“what”:“Character code identifying the entity type the measure applies to (e.g., ‘order’).”,“why”:“Without it, measures cannot be filtered by entity type.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:37.297198485+00:00”}

{“what”:“Integer version number for the measure’s dependency analysis, incremented on changes.”,“why”:“Without it, cached analysis results may be stale.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:37.324985346+00:00”}