id · System / identity
Surrogate primary key (bigint). Auto-incrementing, stable for the lifetime of a row; never reused. This is the join target for the provenance side-table (variant_id) and all external cross-references.
type
int
applies to
all variants
filled
100%
sources
-
Meaning
Surrogate primary key (bigint). Auto-incrementing, stable for the lifetime of a row; never reused. This is the join target for the provenance side-table (variant_id) and all external cross-references.
Export shape
apex fieldjson
{
"id": 123,
"_provenance": {
"id": {
"source": "manual",
"source_record_url": "https://apex-db.org/docs/sources#manual",
"effective": true
}
}
}Provenance
Apex stores source-qualified provenance for exported values. Buyer snapshots and API responses include the upstream source record where redistribution rights allow it, so a downstream model can cite the original regulator or manufacturer feed.
Field-level fill rates are measured across the current variant snapshot. Sparse fields are still documented because they can be important for regulatory, EV, safety, or emissions workflows.