projects

{“what”:“Unique identifier for the project; primary key.”,“why”:“Without it, rows cannot be uniquely referenced by foreign keys or updated reliably.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.297452148+00:00”}

{“what”:“UUID of the organization that owns this project.”,“why”:“Without it, projects cannot be scoped to an organization, and cross-tenant access control is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.311082462+00:00”}

{“what”:“URL-friendly project identifier, unique within the organization.”,“why”:“Without it, project URLs and API routes cannot be stable and human-readable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.326008198+00:00”}

{“what”:“Display name of the project, e.g., ‘Sales Analytics’.”,“why”:“Without it, users cannot distinguish projects in lists or pickers.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.339844075+00:00”}

{“what”:“Free-form text describing the project’s purpose or scope.”,“why”:“Without it, context for future maintainers is lost, making project discovery harder.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.356090882+00:00”}

{“what”:“Version number of the project’s serialization format.”,“why”:“Without it, older project files cannot be migrated or read correctly after format changes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.375201736+00:00”}

{“what”:“Storage backend type, e.g., ‘file’ or ‘database’.”,“why”:“Without it, the system cannot decide how to load or persist the project’s data.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.385851722+00:00”}

{“what”:“Path or key to the project file in the storage backend.”,“why”:“Without it, the project’s content cannot be located when storage_kind requires a file.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.394056266+00:00”}

{“what”:“UUID of the user who owns the project locally, if any.”,“why”:“Without it, local ownership and personal project scoping are ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.403484416+00:00”}

{“what”:“Count of data sources defined in the project.”,“why”:“Without it, project size and complexity cannot be summarized without scanning all sources.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.413681880+00:00”}

{“what”:“Count of tables defined in the project.”,“why”:“Without it, project size and complexity cannot be summarized without scanning all tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.424593643+00:00”}

{“what”:“Count of columns across all tables in the project.”,“why”:“Without it, project size and complexity cannot be summarized without scanning all columns.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.435810935+00:00”}

{“what”:“Count of relationships between tables in the project.”,“why”:“Without it, project size and complexity cannot be summarized without scanning all relations.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.446608905+00:00”}

{“what”:“Count of custom data types defined in the project.”,“why”:“Without it, project size and complexity cannot be summarized without scanning all types.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.463689881+00:00”}

{“what”:“Count of comments attached to project elements.”,“why”:“Without it, project size and complexity cannot be summarized without scanning all comments.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.476765454+00:00”}

{“what”:“Count of notes attached to project elements.”,“why”:“Without it, project size and complexity cannot be summarized without scanning all notes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.488515877+00:00”}

{“what”:“Count of layouts (diagrams) defined in the project.”,“why”:“Without it, project size and complexity cannot be summarized without scanning all layouts.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.503320408+00:00”}

{“what”:“UUID of the user who created the project.”,“why”:“Without it, audit trails and ownership history are incomplete.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.518345686+00:00”}

{“what”:“UUID of the user who last updated the project.”,“why”:“Without it, audit trails and change attribution are incomplete.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.532469835+00:00”}

{“what”:“Timestamp when the project was created, in UTC.”,“why”:“Without it, project age and ordering cannot be determined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.824933345+00:00”}

{“what”:“Timestamp when the project was last updated, in UTC.”,“why”:“Without it, stale projects cannot be identified or sorted by recency.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.836612013+00:00”}

{“what”:“UUID of the user who archived the project, if archived.”,“why”:“Without it, archive actions cannot be attributed to a user.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.849300988+00:00”}

{“what”:“Timestamp when the project was archived, if archived.”,“why”:“Without it, archive status and duration cannot be tracked.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.862302181+00:00”}

{“what”:“Visibility level, e.g., ‘none’, ‘public’, ‘internal’.”,“why”:“Without it, access control and sharing behavior are undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.873494774+00:00”}

{“what”:“Count of memos attached to the project.”,“why”:“Without it, project size and complexity cannot be summarized without scanning all memos.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.887439056+00:00”}