Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| provider_id | text | 2147483647 | null |
|
|
{“what”:“Unique text key for a provider; primary key of the cache.”,“why”:“Without it, cache entries cannot be uniquely identified or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:23:11.815160012+00:00”} |
||
| privacy_tier | text | 2147483647 | √ | null |
|
|
{“what”:“Categorical privacy level (e.g., high, medium, low) assigned to the provider.”,“why”:“Without it, the provider’s privacy classification is unknown, blocking tier-based access decisions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:23:11.838846637+00:00”} |
|
| privacy_score | int4 | 10 | √ | null |
|
|
{“what”:“Integer value representing a privacy rating; higher indicates stronger privacy.”,“why”:“Without it, providers cannot be compared or filtered by privacy strength.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:23:11.941841568+00:00”} |
|
| grade | text | 2147483647 | √ | null |
|
|
{“what”:“Letter grade (e.g., A, B, C) summarizing overall legal compliance.”,“why”:“Without it, quick compliance assessment is impossible, slowing review workflows.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:23:11.961950689+00:00”} |
|
| dimensions | jsonb | 2147483647 | √ | null |
|
|
{“what”:“JSON object containing per-dimension legal scores or attributes.”,“why”:“Without it, detailed breakdown of legal aspects is missing, preventing granular analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:23:12.003413278+00:00”} |
|
| data_retention | text | 2147483647 | √ | null |
|
|
{“what”:“Text describing the provider’s data retention policy.”,“why”:“Without it, the retention period is unknown, risking non-compliance.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:23:12.020965434+00:00”} |
|
| training_usage | text | 2147483647 | √ | null |
|
|
{“what”:“Text describing whether and how provider data is used for model training.”,“why”:“Without it, training usage rights are unclear, causing legal risk.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:23:12.051876166+00:00”} |
|
| jurisdiction_summary | text | 2147483647 | √ | null |
|
|
{“what”:“Text summarizing the legal jurisdictions the provider operates in.”,“why”:“Without it, cross-border compliance cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:23:12.128955147+00:00”} |
|
| tos_summary | text | 2147483647 | √ | null |
|
|
{“what”:“Text summarizing key terms of service clauses.”,“why”:“Without it, contractual obligations are unknown, leading to potential breaches.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:23:12.405757930+00:00”} |
|
| data_retention_verdict | text | 2147483647 | √ | null |
|
|
{“what”:“Verdict (e.g., compliant, non-compliant) on data retention policy.”,“why”:“Without it, the compliance status of retention is not recorded, delaying audits.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:23:12.538574281+00:00”} |
|
| training_usage_verdict | text | 2147483647 | √ | null |
|
|
{“what”:“Verdict (e.g., allowed, prohibited) on training usage.”,“why”:“Without it, training usage compliance is unknown, risking unauthorized use.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:23:12.774525039+00:00”} |
|
| cached_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when this cache entry was last refreshed.”,“why”:“Without it, staleness of cached data is unknown, leading to outdated decisions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:23:12.836249025+00:00”} |
||
| legalrhythm_provider_id | text | 2147483647 | √ | null |
|
|
{“what”:“Provider identifier in the external LegalRhythm system, if mapped.”,“why”:“Without it, linking to LegalRhythm records is impossible, breaking cross-system reconciliation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:23:12.903550777+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| legal_cache_pkey | Primary key | Asc | provider_id |