rate_limit_tiers


Description

{“what”:“One row per rate-limit tier, defining limits and costs for a provider or model.”,“why”:“Without it, rate limit information would be scattered or missing, preventing automated lookup of applicable limits.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:41.439889722+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('rate_limit_tiers_id_seq'::regclass)

{“what”:“Unique integer assigned by sequence; primary key for this table.”,“why”:“Without it, rows cannot be referenced by foreign keys or updated individually.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:41.456456273+00:00”}

provider_id text 2147483647 null

{“what”:“Text code for the provider (e.g., ‘openai’) that this tier applies to.”,“why”:“Without it, tiers from different providers would be indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:41.473056559+00:00”}

tier_name text 2147483647 null

{“what”:“Human-readable tier label such as ‘free’ or ‘pro’ within a provider.”,“why”:“Without it, multiple tiers for the same provider cannot be told apart.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:41.491254277+00:00”}

tier_cost_usd_per_month float8 17,17 √ null

{“what”:“Monthly price in US dollars for this tier; null if not published.”,“why”:“Without it, cost comparison between tiers is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:41.522336943+00:00”}

model_id text 2147483647 √ null
inference_providers.id Implied Constraint R

{“what”:“Model identifier (e.g., ‘gpt-4’) if this tier is model-specific; null for provider-wide tiers.”,“why”:“Without it, model-specific rate limits cannot be distinguished from provider-wide ones.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:41.551654487+00:00”}

rpm int4 10 √ null

{“what”:“Maximum requests allowed per minute; null if not specified.”,“why”:“Without it, clients cannot know the per-minute request cap.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:41.605959934+00:00”}

tpm int4 10 √ null

{“what”:“Maximum tokens processed per minute; null if not specified.”,“why”:“Without it, token throughput limits are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:41.640876523+00:00”}

rph int4 10 √ null

{“what”:“Maximum requests allowed per hour; null if not specified.”,“why”:“Without it, hourly request caps are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:41.690856339+00:00”}

tph int4 10 √ null

{“what”:“Maximum tokens processed per hour; null if not specified.”,“why”:“Without it, hourly token caps are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:41.708619350+00:00”}

rpd int4 10 √ null

{“what”:“Maximum requests allowed per day; null if not specified.”,“why”:“Without it, daily request caps are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:41.739290562+00:00”}

tpd int4 10 √ null

{“what”:“Maximum tokens processed per day; null if not specified.”,“why”:“Without it, daily token caps are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:41.767437959+00:00”}

concurrent_requests int4 10 √ null

{“what”:“Maximum simultaneous requests allowed; null if not specified.”,“why”:“Without it, clients cannot plan for concurrency limits.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:41.783439039+00:00”}

monthly_budget_usd float8 17,17 √ null

{“what”:“Spending cap in US dollars per month; null if not set.”,“why”:“Without it, cost overrun protection is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:41.803810508+00:00”}

overflow_allowed bool 1 √ false

{“what”:“Whether requests beyond the limit are permitted (true) or rejected (false); defaults to false.”,“why”:“Without it, behavior when limits are exceeded is undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:41.835755951+00:00”}

notes text 2147483647 √ null

{“what”:“Free-form notes about the tier, such as special conditions or caveats.”,“why”:“Without it, context not captured by other columns is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:41.847546892+00:00”}

source_url text 2147483647 √ null

{“what”:“URL of the official documentation or page where these limits were obtained.”,“why”:“Without it, the origin of the data cannot be audited.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:41.913783086+00:00”}

verified_at timestamptz 35,6 now()

{“what”:“Timestamp when the tier data was last verified against the source; defaults to now().”,“why”:“Without it, staleness of the data cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:41.951076244+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp when this row was inserted; defaults to now().”,“why”:“Without it, the age of the record is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:42.004567755+00:00”}

Indexes

Constraint Name Type Sort Column(s)
rate_limit_tiers_pkey Primary key Asc id
idx_rlt_provider Performance Asc provider_id
idx_rlt_unique Must be unique Asc/Asc provider_id + tier_name

Relationships