legal_cache


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

Relationships