VCDB — Vehicles for base vehicle 170163

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
360183 170163 20 1 4 2023-03-29 15:02:00 Lexus RX350 2024 Base USA United States 4 4 Row
360202 170163 268 1 4 2023-03-31 11:43:00 Lexus RX350 2024 Premium USA United States 4 4 Row
360203 170163 10773 1 4 2023-03-31 11:48:00 Lexus RX350 2024 Premium+ USA United States 4 4 Row
360204 170163 9465 1 4 2023-03-31 11:50:00 Lexus RX350 2024 F Sport Handling USA United States 4 4 Row
360209 170163 392 1 4 2023-03-31 11:29:00 Lexus RX350 2024 Luxury USA United States 4 4 Row
375146 170163 9465 2 4 2023-11-01 14:37:00 Lexus RX350 2024 F Sport Handling CAN Canada 4 4 Row
375147 170163 752 2 4 2023-11-01 14:38:00 Lexus RX350 2024 Executive CAN Canada 4 4 Row
375148 170163 392 2 4 2023-11-01 14:35:00 Lexus RX350 2024 Luxury CAN Canada 4 4 Row
375152 170163 20 2 4 2023-11-01 15:05:00 Lexus RX350 2024 Base CAN Canada 4 4 Row
376203 170163 20 3 4 2023-11-09 23:57:00 Lexus RX350 2024 Base MEX Mexico 4 4 Row