122975
All columns from aaia_vcdb.vehicle (capped at 500 rows), plus manual joins for make/model/year/submodel/region,
and extra columns from every other parent declared as a PostgreSQL foreign key from vehicle (engine, transmission, etc.—when FK metadata exists).
Dynamic columns are prefixed like vcdb_j0_tablename_colname.
Full aaia_vcdb FK listing
· if engine/trans columns are missing, the DB may not define those FKs.
| vehicleid | basevehicleid | submodelid | regionid | source | publicationstageid | publicationstagesource | publicationstagedate | vcdb_make | vcdb_model | vcdb_year | vcdb_submodel | vcdb_region_abbr | vcdb_region_name | vcdb_j0_publicationstage_publicationstagename | vcdb_j1_publicationstage_publicationstagename | Browse |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 199515 | 122975 | 2490 | 3 | 4 | JATO 20120816 | 2012-08-24 09:28:00 | Renault | Clio | 2010 | Comfort | MEX | Mexico | 4 | 4 | Row | |
| 199516 | 122975 | 2751 | 3 | 4 | JATO 20120816 | 2012-08-24 09:28:00 | Renault | Clio | 2010 | Expression | MEX | Mexico | 4 | 4 | Row |