Car batteries catalogue with cross-references

Car batteries catalogue with cross-references

Battery catalog with characteristics, diagrams of the installation location, and applicability. The database contains 25,815 unique records. Relevance: February 2022.

CREATE TABLE `akb` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `capacity` varchar(255) DEFAULT '' COMMENT 'Емкость батареи [Ач]',
  `caseSize` varchar(255) DEFAULT '' COMMENT 'Размер корпуса',
  `cca` varchar(255) DEFAULT '' COMMENT 'Ток холодной прокрутки EN [в А]',
  `height` varchar(255) DEFAULT '' COMMENT 'Высота',
  `length` varchar(255) DEFAULT '' COMMENT 'Длина',
  `technology` varchar(255) DEFAULT '' COMMENT 'Технология',
  `voltage` varchar(255) DEFAULT '' COMMENT 'Напряжение [В]',
  `weight` varchar(255) DEFAULT '' COMMENT 'Масса (в залитом виде)',
  `width` varchar(255) DEFAULT '' COMMENT 'Ширина',
  `startStop` varchar(255) DEFAULT NULL,
  `workTime` varchar(255) DEFAULT '' COMMENT 'Время установки',
  `layout` varchar(255) DEFAULT '' COMMENT 'Полярность: 0 - прямая, 1 - обратная',
  `terminalTypes` varchar(255) DEFAULT '' COMMENT 'Токовыводы',
  `ktypeNo` varchar(255) DEFAULT NULL COMMENT 'Идентификатор модификации ТС по версии ТекДок',
  `complexityIndicator` varchar(255) DEFAULT NULL COMMENT 'Особенности установки и замены',
  `mounting` varchar(255) DEFAULT NULL COMMENT 'Крепление',
  `crossBrand` varchar(50) NOT NULL COMMENT 'Бренд запчасти-кросса',
  `crossNumber` varchar(50) DEFAULT NULL COMMENT 'Номер запчасти-кросса',
  PRIMARY KEY (`id`),
  KEY `ktypeNo` (`ktypeNo`),
  KEY `crossBrand` (`crossBrand`,`crossNumber`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `akbCrosses`  (
  `brand` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `crossBrand` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `crossNumber` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `brand`(`brand`, `number`) USING BTREE,
  INDEX `crossBrand`(`crossBrand`, `crossNumber`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6378 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE `cars`  (
  `carId` bigint NOT NULL,
  `carType` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `motorCode` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `mfrId` bigint NOT NULL,
  `mfrShortName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `mfrName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `beginYearMonth` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `endYearMonth` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `subLinkageTargetType` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `vehicleModelSeriesId` bigint NOT NULL,
  `vehicleModelSeriesName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `fuelMixtureFormationType` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `driveType` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `bodyStyle` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `valves` bigint NOT NULL,
  `fuelType` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `engineType` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_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,
  `axleStyle` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `axleType` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `axleBody` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `wheelMounting` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `axleLoadToKg` bigint NOT NULL,
  `brakeType` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `hmdMfrModelId` bigint NOT NULL,
  `hmdMfrModelName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `aspirationKey` bigint NOT NULL,
  `aspiration` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `cylinderDesign` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `coolingType` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `tonnage` bigint NOT NULL,
  `axleConfiguration` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `axleLoadFromKg` bigint NOT NULL,
  INDEX `carId`(`carId`, `carType`) USING BTREE,
  INDEX `motorCode`(`motorCode`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

В каталог вошли характеристики штатных АКБ для автомобилей ABARTH, AC, AIXAM, ALFA ROMEO, ALPINA, ALPINE, ARO, ARTEGA, ASIA MOTORS, ASTON MARTIN, AUDI, AUSTIN, AUSTIN-HEALEY, AUTO UNION, AUTOBIANCHI, BARKAS, BEDFORD, BENTLEY, BERTONE, BITTER, BMW, BRILLIANCE, BRISTOL, BUGATTI, BUICK, CADILLAC, CATERHAM, CHEVROLET, CHRYSLER, CITROËN, DACIA, DAEWOO, DAF, DAIHATSU, DAIMLER, DFSK, DODGE, DS, FERRARI, FIAT, FISKER, FORD, FORD USA, FSO, GAZ, GEELY, GLAS, HONDA, HUMMER, HYUNDAI, INFINITI, INNOCENTI, IRMSCHER, ISUZU, IVECO, JAGUAR, JEEP, KIA, KTM, LADA, LAMBORGHINI, LANCIA, LAND ROVER, LANDWIND (JMC), LDV, LEXUS, LIGIER, LOTUS, LTI, MAHINDRA, MAN, MARCOS, MASERATI, MAYBACH, MAZDA, MERCEDES-BENZ, METROCAB, MG, MICROCAR, MINI, MITSUBISHI, MORGAN, MORRIS, MOSKVICH, NISSAN, NSU, OPEL, PEUGEOT, PIAGGIO, PININFARINA, PLYMOUTH, PONTIAC, PORSCHE, PROTON, PUCH, RENAULT, RENAULT TRUCKS, RILEY, ROLLS-ROYCE, ROVER, SAAB, SANTANA, SEAT, SKODA, SMART, SSANGYONG, STEYR, STREETSCOOTER, SUBARU, SUZUKI, TALBOT, TATA, TESLA, TOYOTA, TRABANT, TRIUMPH, TVR, UAZ, VAUXHALL, VOLVO, VW, WARTBURG, WIESMANN, ZASTAVA, ZAZ, ZUENDAPP

DATABASE DEMOCROSS-REFERENCE DEMO