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 batteries catalogue with cross-references

Car batteries catalogue with cross-references

EUR: 331 | USD/USDT: | BTC:

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

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 batteries catalogue with cross-references", 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