Weights of the autoparts

Weights of the autoparts

MySQL is a database of weights and dimensions of auto parts. Updated on 01.2026. Custom assembly AUTODATABASES.RU . The database is based on data from original catalogs of spare parts manufacturers, open sources on the Internet and our own sources. Since financial issues directly depend on the accuracy of information about the weight of the part, all data is checked manually three times, and if errors occur, corrections are made immediately.
There are 14,416,322 and 5,379,453 records of spare parts dimensions in the database of unique weight records.

CREATE TABLE `weightdb` (
  `id` int NOT NULL AUTO_INCREMENT,
  `brand` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sku` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `weight` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `unit` varchar(2) COLLATE utf8mb4_general_ci DEFAULT 'g'
  PRIMARY KEY (`id`),
  UNIQUE KEY `brand` (`brand`,`sku`,`weight`,`unit`) USING BTREE,
  KEY `brand_2` (`brand`,`sku`))
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `GABARIT` (
  `brand` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sku` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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