Каталог автомобилей

Каталог автомобилей

Таблица транспортных средств с характеристиками и идентификаторами ТекДок. Актуальность 12.2021. Формат: SQL.

Схема таблицы:

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;