Liquid capacity

Liquid capacity

Accurate information about what liquids and how much you need to fill in the car. The data is presented in 3 languages - Russian, English and Bulgarian. 722 004 filling volumes for 28 669 modifications of cars c ID TecRMI and 22 987 with ID AUTO&PARTS (full list of vehicles).
For each modification of the vehicle in the database indicated filling volume hydraulic fluid chassis, hydraulic oil locked rear axle differential, differential oil 1. for rear axle, differential oil 1. for front axle, 2 differential oil. for rear axle, 2 differential oil. for the front axle, fluid gidromehanizm gearshift, clutch fluid, oil in gears 1. rear axle on both sides, oil in gear 1. front axle on both sides, oil in gear 2. rear axle on both sides, oil in gear 2. front axle on both sides, oil in power take-off box, oil in wheel bearings 1. on both sides of the front axle, oil in 2 wheel bearings. on both sides of the front axle, oil wspomagania steering system, differential oil rear axle oil front axle differential oil for automatic transmission, oils for double disc clutch, oil retarder-retarder, oil for the control module in the rear-axle differential, oil for traction on all wheels, oil for the center. hydraulic. system oil extra lift bridge, oil additional drive of the oil sump of the bilateral drive of the rear axle, oil sump bilateral front wheel drive, oil conditioning, oil gearbox, oil dump, oil pre-supercharger, transmission oil distribution, oil Central hydraulic system, engine oil, filter, coolant, coolant, battery, electric/hybrid drive, the coolant for the inverter coolant heating circuit, charge air cooler coolant, traction motor generator coolant, engine oil receiver, fuel additive, brake fluid when replaced, refrigerant for air conditioner.

in Addition to filling volumes, the specifications of hydraulic oil of the locked rear axle differential, hydraulic fluid of the chassis, hydraulic fluid, clutch fluid, automatic transmission oil, power steering oil, oil for the lifting Board, oil for double-disc clutch, oil for differential 1 are specified. rear axle, oil for differential 1. front axle, oil for differential 2. rear axle, oil for differential 2. front axle, oil for the power take - off box, oil for the control module in the rear axle differential, oil for the tilting mechanism, oil for wheel bearings 1. front axle, 2 wheel bearing oils. front axle, rear axle oil, gear oil 1. rear axle, gear oil 1. front axle, gear oil 2. rear axle, gear oil 2. front axle, oil sump bilateral drive rear axle, oil sump bilateral drive of the front axle, the oil of the compressor (boost), oil conditioning, oil power, oil, front axle, all-wheel drive clutch oil, oil pre-supercharger oil speed transmission, oil retarder, engine oil, coolant, coolant for a battery electric hybrid drive, the coolant for the inverter coolant heating circuit, coolant charge air cooler, transfer case, brake fluid, refrigerant.

database Format: CSV, MYSQL.
Weight of mySQL dumps: 835 MB
Weight of ZIP: 95 MB.

table Diagram:

CREATE TABLE `CARVOLUMES`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `AUTO&PARTS id` bigint(11) NULL DEFAULT NULL COMMENT 'AUTO&PARTS  ktype',
  `tecrmiid` int(11) NULL DEFAULT NULL COMMENT 'TecRMI ID',
  `volumevalue` varchar(455) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Value',
  `volumeDescId` int(11) NULL DEFAULT NULL COMMENT 'CARVOLUMES_desc ID',
  `addinfoId` int(11) NULL DEFAULT NULL COMMENT 'CARVOLUMES_addinfo ID',
  `textId` int(11) NULL DEFAULT NULL COMMENT 'CARVOLUMES_texts ID',
  `unitId` int(11) NULL DEFAULT NULL COMMENT 'CARVOLUMES_units ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `AUTO&PARTS id`(`AUTO&PARTS id`) USING BTREE,
  INDEX `tecrmiid`(`tecrmiid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE `CARVOLUMES_addinfo`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `addinfoId` int(11) NULL DEFAULT NULL,
  `addinfo` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `lang` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `addinfo`(`addinfo`) USING BTREE,
  INDEX `addinfoId`(`addinfoId`, `lang`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE `CARVOLUMES_desc`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `volumeDescId` int(11) NULL DEFAULT NULL,
  `volumeDesc` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `lang` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `volumeDesc`(`volumeDesc`, `lang`) USING BTREE,
  INDEX `volumeDescId`(`volumeDescId`, `lang`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE `CARVOLUMES_texts`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `textId` int(11) NULL DEFAULT NULL,
  `textString` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `lang` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `id`(`id`) USING BTREE,
  INDEX `textId`(`textId`, `lang`) USING BTREE,
  INDEX `textString`(`textString`, `lang`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE `CARVOLUMES_units`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unitId` int(11) NULL DEFAULT NULL,
  `unitText` varchar(273) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `lang` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `unitText`(`unitText`, `lang`) USING BTREE,
  INDEX `unitId`(`unitId`, `lang`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE `vehicles`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'hide',
  `carId` bigint NULL DEFAULT NULL,
  `ccmTech` bigint NULL DEFAULT NULL,
  `constructionType` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `cylinder` bigint NULL DEFAULT NULL,
  `cylinderCapacityCcm` bigint NULL DEFAULT NULL,
  `cylinderCapacityLiter` bigint NULL DEFAULT NULL,
  `fuelType` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `fuelTypeProcess` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `impulsionType` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `manuId` bigint NULL DEFAULT NULL,
  `manuName` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `modId` bigint NULL DEFAULT NULL,
  `modelName` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `motorType` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `powerHpFrom` bigint NULL DEFAULT NULL,
  `powerHpTo` bigint NULL DEFAULT NULL,
  `powerKwFrom` bigint NULL DEFAULT NULL,
  `powerKwTo` bigint NULL DEFAULT NULL,
  `typeName` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `typeNumber` bigint NULL DEFAULT NULL,
  `valves` bigint NULL DEFAULT NULL,
  `yearOfConstrFrom` bigint NULL DEFAULT NULL,
  `yearOfConstrTo` bigint NULL DEFAULT NULL,
  `lang` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `axisConfiguration` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  `tonnage` bigint NULL DEFAULT NULL,
  `brakeSystem` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `vehicleDetails_id_uindex`(`id`) USING BTREE,
  INDEX `carId_i`(`carId`) USING BTREE,
  INDEX `manuId_i`(`manuId`) USING BTREE,
  INDEX `lang`(`lang`) USING BTREE,
  INDEX `modId_i`(`modId`, `carId`, `manuId`, `lang`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

ДЕМОНСТРАЦИЯ