Liquid capacity

Liquid capacity

Accurate information about what liquids and how much you need to fill in the car. 626851 filling volumes for 18019 modifications of cars.
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`  (
  `volumeDesc` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `addinfo` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `textString` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `unitText` varchar(273) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `volumevalue` varchar(455) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Value',
  `tecdocid` bigint NULL DEFAULT NULL COMMENT 'TecDoc ktype',
  INDEX `tecdocid`(`tecdocid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

CREATE TABLE `CARS`  (
  `makeId` int NULL DEFAULT NULL COMMENT 'Идентификатор марки ТС',
  `modelId` int NULL DEFAULT NULL COMMENT 'Идентификатор модели ТС',
  `tecdocid` bigint NULL DEFAULT NULL COMMENT 'TecDoc ktype',
  `fullName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'Полное название модификации',
  `brand` json NULL COMMENT 'Производитель',
  `model` json NULL COMMENT 'Модель',
  `modification` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'Название',
  `engineCode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'Код двигателя',
  `constructionType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'Кузов',
  `fuel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'Топливо',
  `horsePower` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'Мощность двигателя, ЛС',
  `startDate` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'Начало производства',
  `endDate` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'Окончание производства',
  `engineCapacity` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'Объем двигателя',
  `numberOfCylinders` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'Количество цилиндров',
  `valves` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'Клапаны',
  `valvesTotal` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'Всего клапанов',
  `motorType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'Тип двигателя',
  INDEX `tecdocid`(`tecdocid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

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