models


Description

{“what”:“Registry of AI models with identifying attributes and metadata.”,“why”:“Without it, no canonical list of models exists for referencing in other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:56.769460264+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('models_id_seq'::regclass)
inference_offerings.model_ref inference_offerings_model_ref_fkey R

{“what”:“Unique integer identifier for each model row.”,“why”:“Without it, rows cannot be uniquely referenced by foreign keys.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:56.803293227+00:00”}

canonical_slug text 2147483647 null

{“what”:“Unique human-readable slug such as ‘gpt-4’ for external references.”,“why”:“Without it, no stable public identifier exists for lookups by name.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:56.823511966+00:00”}

family text 2147483647 null

{“what”:“Model family name such as ‘GPT’ or ‘Llama’.”,“why”:“Without it, models cannot be grouped by their base architecture.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:56.840822955+00:00”}

version text 2147483647 √ null

{“what”:“Version string like ‘4o’ or ‘3.5’ within the family.”,“why”:“Without it, distinct releases of the same family cannot be told apart.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:56.860651704+00:00”}

variant text 2147483647 √ null

{“what”:“Variant label such as ‘turbo’ or ‘instruct’.”,“why”:“Without it, different fine-tuned or specialized versions of the same model are indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:56.891555331+00:00”}

params text 2147483647 √ null

{“what”:“Parameter count or configuration string, e.g., ‘175B’.”,“why”:“Without it, model size and resource requirements cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:56.909679519+00:00”}

modality text 2147483647 'text'::text

{“what”:“Input/output modality, default ‘text’, e.g., ‘image’, ‘audio’.”,“why”:“Without it, it’s unknown which data types a model accepts.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:56.929313155+00:00”}

reference_precision text 2147483647 √ null

{“what”:“Precision used for reference, e.g., ‘fp16’, ‘int8’.”,“why”:“Without it, numerical precision for reproducibility is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:56.939923749+00:00”}

open_weights bool 1 true

{“what”:“Boolean flag indicating whether model weights are publicly available.”,“why”:“Without it, licensing and usage restrictions cannot be determined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:56.958923597+00:00”}

notes text 2147483647 √ null

{“what”:“Free-form notes about the model, e.g., training data or quirks.”,“why”:“Without it, contextual details that don’t fit other columns are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:56.970108998+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp when the model record was created, in UTC.”,“why”:“Without it, audit history and ordering by creation time are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:56.987239821+00:00”}

updated_at timestamptz 35,6 now()

{“what”:“Timestamp of the last update to the model record, in UTC.”,“why”:“Without it, staleness of the record cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:57.006624851+00:00”}

Indexes

Constraint Name Type Sort Column(s)
models_pkey Primary key Asc id
idx_models_family Performance Asc family
models_canonical_slug_key Must be unique Asc canonical_slug

Relationships