VCDB — Vehicles for base vehicle 1537

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
2537 1537 20 1 OEM 4 2012-01-27 00:00:00 Chrysler PT Cruiser 2003 Base USA United States 4 4 Row
2543 1537 13 1 OEM 4 2012-01-27 00:00:00 Chrysler PT Cruiser 2003 Limited USA United States 4 4 Row
2546 1537 53 1 OEM 4 2012-01-27 00:00:00 Chrysler PT Cruiser 2003 Touring USA United States 4 4 Row
2547 1537 39 1 OEM 4 2012-01-27 00:00:00 Chrysler PT Cruiser 2003 GT USA United States 4 4 Row
78313 1537 20 3 VCdbMexico 4 2012-01-27 00:00:00 Chrysler PT Cruiser 2003 Base MEX Mexico 4 4 Row
78314 1537 2509 3 VCdbMexico 4 2012-01-27 00:00:00 Chrysler PT Cruiser 2003 Dream Edition MEX Mexico 4 4 Row
78315 1537 53 3 VCdbMexico 4 2012-01-27 00:00:00 Chrysler PT Cruiser 2003 Touring MEX Mexico 4 4 Row
148722 1537 13 2 VCDB Bulk 4 2012-01-27 00:00:00 Chrysler PT Cruiser 2003 Limited CAN Canada 4 4 Row
148723 1537 53 2 VCDB Bulk 4 2012-01-27 00:00:00 Chrysler PT Cruiser 2003 Touring CAN Canada 4 4 Row
148724 1537 39 2 VCDB Bulk 4 2012-01-27 00:00:00 Chrysler PT Cruiser 2003 GT CAN Canada 4 4 Row
289559 1537 274 2 4 2021-06-17 12:09:00 Chrysler PT Cruiser 2003 Classic CAN Canada 4 4 Row