Autodatabases.Com
  • Home
  • Databases
    Repair Times Weight and sizes Cars images
    Autodata EAN13 codes Cars catalogue
    All bases
    Cross-reference
  • Offers
  • About us
    • About us
    • Price-list
    • Feedback
  • Chat with support
Car catalogue

Car catalogue

EUR: 288 | USD/USDT: | BTC:

Car catalogue

Table of vehicles with AUTO&PARTS info and identifiers. The relevance 12.2021. Format: SQL.

mySQL table schema:
CREATE TABLE `linkageTargets`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `linkageTargetId` bigint NOT NULL,
  `linkageTargetType` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `mfrId` bigint NOT NULL,
  `mfrName` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `mfrShortName` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `beginYearMonth` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `endYearMonth` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `lang` varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `subLinkageTargetType` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `vehicleModelSeriesId` bigint NOT NULL,
  `vehicleModelSeriesName` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `rmiTypeId` bigint NOT NULL,
  `imageURL50` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `imageURL100` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `imageURL200` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `imageURL400` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `imageURL800` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `0` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `fuelMixtureFormationTypeKey` bigint NOT NULL,
  `fuelMixtureFormationType` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `driveTypeKey` bigint NOT NULL,
  `driveType` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `bodyStyleKey` bigint NOT NULL,
  `bodyStyle` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `valves` bigint NOT NULL,
  `fuelTypeKey` bigint NOT NULL,
  `fuelType` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `engineTypeKey` bigint NOT NULL,
  `engineType` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `horsePowerFrom` bigint NOT NULL,
  `horsePowerTo` bigint NOT NULL,
  `kiloWattsFrom` bigint NOT NULL,
  `kiloWattsTo` bigint NOT NULL,
  `cylinders` bigint NOT NULL,
  `capacityCC` bigint NOT NULL,
  `capacityLiters` double NOT NULL,
  `code` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `axleStyleKey` bigint NOT NULL,
  `axleStyle` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `axleTypeKey` bigint NOT NULL,
  `axleType` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `axleBodyKey` bigint NOT NULL,
  `axleBody` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `wheelMountingKey` bigint NOT NULL,
  `wheelMounting` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `axleLoadToKg` bigint NOT NULL,
  `brakeTypeKey` bigint NOT NULL,
  `brakeType` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `hmdMfrModelId` bigint NOT NULL,
  `hmdMfrModelName` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `aspirationKey` bigint NOT NULL,
  `aspiration` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cylinderDesignKey` bigint NOT NULL,
  `cylinderDesign` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `coolingTypeKey` bigint NOT NULL,
  `coolingType` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `tonnage` bigint NOT NULL,
  `axleConfigurationKey` bigint NOT NULL,
  `axleConfiguration` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `axleLoadFromKg` bigint NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `linkageTargetId`(`linkageTargetId`, `linkageTargetType`, `mfrId`, `subLinkageTargetType`) USING BTREE,
  INDEX `linkageTargetId_2`(`linkageTargetId`, `linkageTargetType`, `lang`) USING BTREE,
  INDEX `lang`(`lang`, `fuelMixtureFormationTypeKey`, `driveTypeKey`, `bodyStyleKey`, `fuelTypeKey`, `engineTypeKey`, `axleStyleKey`, `axleTypeKey`, `axleBodyKey`, `wheelMountingKey`, `brakeTypeKey`, `aspirationKey`, `cylinderDesignKey`, `coolingTypeKey`, `axleConfigurationKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 943318 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

Testing and buying

After submitting this form, You will be given access to a personal section on our FTP server. This is where the products you purchased will be downloaded.
All steps are automatic and take a minimum amount of time.

To purchase "Car catalogue", You just need to enter your e-mail. Payment must be made using VISA, MASTERCARD, MAESTRO, WORLD. Internet payments are protected by SSL certificate and 3D Secure Protocol. JSC "Tinkoff Bank" does not transfer payment data to stores, including card data.



Who we are

  • Company profile

What the price?

  • Price-list

Where are you?

  • Feedback

24/7 support

  • Online chat
  • Write an email
  • Offers
  • User agreement
© Copyright AUTODATABASES.COM, 1996-2022