Tables


SchemaSpy Analysis of azimutt.public

Generated on Tue Sep 22 22:43 PDT 2026

XML Representation
Insertion Order Deletion Order
TABLES 14
VIEWS 0
COLUMNS 177
Constraints 27
Anomalies 0
Routines 57

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”}