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 |
|---|---|---|---|---|---|
| binding_types | 0 | 0 | 4 | Table | {“what”:“Catalog of binding type identifiers and their metadata.”,“why”:“Defines the set of valid binding types referenced by other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:20.732632071+00:00”} |
| contacts | 7 | 2 | 22 | Table | {“what”:“A person or organization with contact details and outreach metadata.”,“why”:“Without it, no central record exists to link profiles, emails, and outreach status.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.018751323+00:00”} |
| profile_dimensions | 0 | 4 | 13 | Table | |
| sync_state | 0 | 0 | 2 | Table | {“what”:“Key-value store for per-target synchronization progress.”,“why”:“Without it, sync state is lost, forcing full re-syncs or missed updates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:02.987158465+00:00”} |
| profiles | 7 | 0 | 12 | Table | {“what”:“Root entity for a profile; each row is one profiled organization or person.”,“why”:“Provides a stable identifier so other tables can reference a profile without repeating its attributes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:20.715557300+00:00”} |
| card_contacts | 0 | 2 | 4 | Table | {“what”:“Links an event card to a contact with a specific role.”,“why”:“Without it, we cannot know which contacts are associated with which event cards and in what capacity.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:26.125673970+00:00”} |
| dimension_edges | 0 | 2 | 4 | Table | {“what”:“A pair of dimension values that form an edge in a dimension graph.”,“why”:“Without it, relationships between dimension values are unknown, preventing graph traversal or clustering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:46.815217189+00:00”} |
| contact_dimensions | 0 | 3 | 10 | Table | {“what”:“Pairs a contact with a dimension and its numeric score.”,“why”:“Without it, contact traits are not stored, so filtering by dimension is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:28.350644642+00:00”} |
| prism_values | 1 | 1 | 5 | Table | {“what”:“Values belonging to a prism, each with a name and description.”,“why”:“Without it, prisms have no list of selectable values.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:26.926040127+00:00”} |
| dimension_values | 4 | 1 | 10 | Table | {“what”:“Lookup table of allowed values for each dimension.”,“why”:“Provides a controlled vocabulary for dimensions; without it values are free-form and inconsistent.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.160367385+00:00”} |
| dimensions | 3 | 0 | 8 | Table | {“what”:“A dimension in a multidimensional data model; each row defines one analysis axis.”,“why”:“Without it, there is no catalog of available dimensions for slicing or grouping data.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:08.152176906+00:00”} |
| sales_templates | 1 | 0 | 9 | Table | {“what”:“Templates for sales messages, each with a text pattern and classification metadata.”,“why”:“Without it, no central store of reusable sales message patterns, forcing ad-hoc creation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:47.210653100+00:00”} |
| card_categories | 1 | 0 | 6 | Table | |
| linkedin_messages | 0 | 0 | 15 | Table | {“what”:“Inbound/outbound LinkedIn messages synced from Unipile; one row per message.”,“why”:“Central record for all LinkedIn conversations; without it no unified message history.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:29.952684900+00:00”} |
| profile_org_views | 0 | 4 | 11 | Table | {“what”:“Snapshot of a profile’s view of an org function, with metrics and optional contact binding.”,“why”:“Without it, profile-specific org function assessments cannot be stored or compared over time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:11.378639219+00:00”} |
| suppression_list | 2 | 0 | 8 | Table | {“what”:“Email addresses excluded from outbound mail; each row is one suppression event.”,“why”:“Without it, mail could be sent to addresses that previously bounced or complained, harming deliverability.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:30.143802842+00:00”} |
| certifications | 0 | 1 | 15 | Table | {“what”:“A record that a profile passed or failed a certification check for a domain.”,“why”:“Without it, certification status and history for profiles and domains are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:47.377761331+00:00”} |
| commentary | 0 | 3 | 10 | Table | {“what”:“AI-generated textual notes associated with one of three entity types.”,“why”:“Without it, there is no record of machine-written observations for these entities.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:52.893241918+00:00”} |
| event_card_templates | 1 | 1 | 9 | Table | {“what”:“Templates defining event card content, trigger signals, and display order.”,“why”:“Without it, no event card definitions exist to render or trigger.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.010829197+00:00”} |
| signals | 0 | 3 | 9 | Table | {“what”:“Signal observations linking a profile and/or contact to a type, with optional intensity and expiry.”,“why”:“Without it, signal history and its attributes are lost, breaking any feature that relies on past signals.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:52.730103956+00:00”} |
| event_cards | 2 | 2 | 9 | Table | {“what”:“A card instance tied to a profile, created from a template and matched signals.”,“why”:“Without it, the system cannot track which cards were generated for a profile and when.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:59.263567167+00:00”} |
| interactions | 0 | 0 | 12 | Table | {“what”:“Log of communications and events tied to a contact and optionally a deal.”,“why”:“Without it, there is no history of touchpoints for contacts or deals, so relationship tracking is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:20.507637665+00:00”} |
| signal_types | 1 | 0 | 6 | Table | |
| deals | 0 | 1 | 10 | Table | {“what”:“A sales opportunity record tied to a contact, tracking pipeline stage and outreach sequence.”,“why”:“Without it, there is no central entity to track sales progress, making pipeline reporting and sequence automation impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.399581184+00:00”} |
| calendar_events | 0 | 1 | 19 | Table | |
| org_functions | 1 | 0 | 4 | Table | {“what”:“Catalog of organizational functions, each identified by a unique slug.”,“why”:“Without it, there is no canonical list of functions to reference for roles, permissions, or feature gating.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:32.219161431+00:00”} |
| prisms | 1 | 0 | 4 | Table | {“what”:“Catalog of prism definitions; each row is one prism.”,“why”:“Without it, there is no canonical list of prisms to reference.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:05.940988970+00:00”} |
| field_changes | 0 | 1 | 8 | Table | {“what”:“Audit log of field-level edits across tables; one row per changed field.”,“why”:“Without it, no history of who changed what or when, making rollback and debugging impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:04.826909873+00:00”} |