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 |
|---|---|---|---|---|---|
| entity_brief | 0 | 0 | 10 | Table | {“what”:“A generated brief (markdown) with provenance and facts for a single entity.”,“why”:“Without it, briefs would need to be regenerated on every request and provenance would be lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:10.804272841+00:00”} |
| page_brief | 0 | 1 | 13 | Table | {“what”:“A row per page content hash, holding extracted facts and processing state.”,“why”:“Without it, there is no single place to store per-page briefs, making retrieval and updates impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:16.436087488+00:00”} |
| domain_brief | 2 | 0 | 8 | Table | |
| image_asset | 0 | 1 | 6 | Table | {“what”:“Each row is one unique image content, identified by its SHA-256 hash.”,“why”:“Provides a single source of truth for image metadata, enabling alt-text coverage audits.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:53.677611483+00:00”} |
| brief_tags | 0 | 0 | 6 | Table | {“what”:“A row is one tag assignment from a source to an entity with a confidence score.”,“why”:“Without it, entity tags from different sources cannot be distinguished or weighted by reliability.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:44.570589338+00:00”} |