native_query_snippet

{“what”:“Unique integer identifier for a snippet; primary key.”,“why”:“Without it, snippets cannot be uniquely referenced or joined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:56.987503726+00:00”}

{“what”:“Human-readable label for the snippet; used in lists and search.”,“why”:“Without it, users cannot identify or select a snippet by name.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:57.016844495+00:00”}

{“what”:“Free-form text describing the snippet’s purpose or usage.”,“why”:“Without it, the snippet’s intent is undocumented, making reuse risky.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:57.041448525+00:00”}

{“what”:“The exact query text to execute; typically SQL.”,“why”:“Without it, the snippet has no executable logic.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:57.064877576+00:00”}

{“what”:“User ID of the person who created this snippet.”,“why”:“Without it, ownership and audit trail for the snippet are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:57.095832086+00:00”}

{“what”:“Flag indicating whether the snippet is hidden from active use; true means archived.”,“why”:“Without it, obsolete snippets cannot be hidden without deletion.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:57.110628114+00:00”}

{“what”:“Creation timestamp with timezone; set automatically to now.”,“why”:“Without it, there is no record of when the snippet was added.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:57.128972325+00:00”}

{“what”:“Last modification timestamp with timezone; updated on each change.”,“why”:“Without it, there is no way to know if a snippet is stale or to sort by recent activity.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:57.145222766+00:00”}

{“what”:“ID of the collection this snippet belongs to; null if unassigned.”,“why”:“Without it, snippets cannot be grouped or filtered by collection.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:57.168606133+00:00”}

{“what”:“Optional single-character code referencing an external entity; exact meaning not defined in schema.”,“why”:“Without it, the link to an external entity is unknown; schema does not clarify its purpose.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:57.188217834+00:00”}

{“what”:“Free-form text containing tags for the snippet, e.g., comma-separated keywords.”,“why”:“Without it, snippets cannot be categorized or searched by tags.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:57.209087790+00:00”}

{“what”:“Version number of the dependency analysis performed on this snippet; 0 means none.”,“why”:“Without it, it is unknown whether the snippet’s dependencies have been analyzed or if the analysis is outdated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:57.239451187+00:00”}