Bearings database

Bearings database

Base of automotive bearings with applicability. Contains up-to-date information on all vehicle modifications and suitable bearings. As of 26.03.2021, there are 189,429 bearings, 175,344 characteristics, 3,087,195 applicability to 92,161 vehicle modifications, and 108,855 bearing photos. Weight of MySQL table dumps: 294MB, weight of images ZIP archive: 1.6GB.

Database DDL

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for _allArticles
-- ----------------------------
DROP TABLE IF EXISTS `_allArticles`;
CREATE TABLE `_allArticles`  (
  `brandName` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `articleNumber` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `partname` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `legacyArticleId` bigint UNSIGNED NOT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'Main bearings base' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for _allCriteria
-- ----------------------------
DROP TABLE IF EXISTS `_allCriteria`;
CREATE TABLE `_allCriteria`  (
  `legacyArticleId` bigint UNSIGNED NOT NULL,
  `Parameters` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `legacyArticleId`(`legacyArticleId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'Bearings info' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for _allPrim
-- ----------------------------
DROP TABLE IF EXISTS `_allPrim`;
CREATE TABLE `_allPrim`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `legacyArticleId` int NULL DEFAULT NULL COMMENT 'Уникальный ID запчасти',
  `linkingTargetId` int NULL DEFAULT NULL COMMENT 'Уникальный ID модификации ТС (KType)',
  `linkingTargetType` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'Тип ТС в соответствии с ТекДок',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `legacyArticleId`(`legacyArticleId`, `linkingTargetId`, `linkingTargetType`) USING BTREE,
  INDEX `legacyArticleId_2`(`legacyArticleId`) USING BTREE,
  INDEX `linkingTargetId`(`linkingTargetId`, `linkingTargetType`) USING BTREE,
  INDEX `linkingTargetId_2`(`linkingTargetId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'Applicability' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for _carPark
-- ----------------------------
DROP TABLE IF EXISTS `_carPark`;
CREATE TABLE `_carPark`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `KType` bigint NULL DEFAULT NULL COMMENT 'Уникальный ID модификации автомобиля',
  `BrandNo` bigint NULL DEFAULT NULL COMMENT 'ID производителя по ТекДок',
  `Brand` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT 'Наименование производителя',
  `Model_no` bigint NULL DEFAULT NULL COMMENT 'ID модели по ТекДок',
  `Sales_designation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT 'Наименование модели ТС',
  `Model_generation` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Поколение ТС',
  `Type_designation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT 'Наименование модификации ТС',
  `Construction_from` bigint NULL DEFAULT NULL COMMENT 'Начало производства',
  `Construction_to` bigint NULL DEFAULT NULL COMMENT 'Окончание производства',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `KType`(`KType`, `BrandNo`, `Model_no`) USING BTREE,
  INDEX `KType_2`(`KType`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'Vehicles' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for _images
-- ----------------------------
DROP TABLE IF EXISTS `_images`;
CREATE TABLE `_images`  (
  `legacyArticleId` int NOT NULL,
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `legacyArticleId`(`legacyArticleId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'Images' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;