Database Properties
Database Type: PostgreSQL - 18.4 (Ubuntu 18.4-1.pgdg24.04+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Type | Comments |
|---|---|---|---|---|---|
| events | 0 | 2 | 8 | Table | {“what”:“A row per event occurrence, identified by UUID, with a name and optional JSON payloads.”,“why”:“Without it, system activity is untraceable and cannot be audited.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:13.720511614+00:00”} |
| user_auth_tokens | 0 | 1 | 8 | Table | {“what”:“Authentication tokens issued to users for API access.”,“why”:“Without it, there is no way to validate user sessions or revoke access.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:46.916576657+00:00”} |
| projects | 2 | 5 | 25 | Table | {“what”:“Container for a data modeling project with metadata and content counts.”,“why”:“Without it, there is no grouping for schemas, sources, and layouts; all project-scoped data would be orphaned.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:30.281660465+00:00”} |
| organization_members | 0 | 4 | 7 | Table | |
| gallery | 0 | 1 | 12 | Table | {“what”:“Rows representing gallery entries for projects, each with presentation and descriptive metadata.”,“why”:“Without it, there is no way to display a curated gallery of projects.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:38.586630184+00:00”} |
| heroku_resources | 0 | 1 | 14 | Table | {“what”:“A provisioned Heroku add-on or app with plan, region, and OAuth credentials.”,“why”:“Without it, no record of provisioned resources exists, breaking billing and management.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:16.144804938+00:00”} |
| project_tokens | 0 | 3 | 10 | Table | grant access to projects |
| user_profiles | 0 | 2 | 18 | Table | {“what”:“Extended profile data for a user, one row per user.”,“why”:“Keeps optional profile fields separate from core auth to reduce table width.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:44.212249029+00:00”} |
| clever_cloud_resources | 0 | 1 | 14 | Table | {“what”:“A Clever Cloud addon resource instance, linking addon, owner, user, and organization.”,“why”:“Without it, there is no record of which addons are provisioned, for whom, and with what configuration.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:36.609315331+00:00”} |
| organizations | 7 | 3 | 23 | Table | |
| organization_invitations | 0 | 3 | 11 | Table | {“what”:“Invitations for users to join an organization with a role.”,“why”:“Tracks pending, cancelled, and answered invitations to control access.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:29.086503732+00:00”} |
| schema_migrations | 0 | 0 | 2 | Table | |
| user_tokens | 0 | 1 | 6 | Table | {“what”:“Issued authentication or authorization tokens for users, one row per token.”,“why”:“Without it, there is no record of which tokens are valid or what they were issued for.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:24.260982114+00:00”} |
| users | 18 | 0 | 19 | Table | {“what”:“Registered user accounts; central identity for authentication and authorization.”,“why”:“Without it, no persistent identity for login, permissions, or per-user data.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:50.476874535+00:00”} |