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 |
|
|
{“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 |