Weights of the autoparts

Weights of the autoparts

mySQL-database weights and dimensions of automotive parts. It was updated 05.06.2024. Self-Assembly AUTODATABASES.RU. The basis of the database provided data from the original catalogues of manufacturers of spare parts, open sources on the Internet and our own sources. Since the accuracy of the information on weight of the auto parts depend directly on financial matters, all data are checked three times manually and if errors occur, corrections are made immediately.
05.06.2024 On our database of 29 072 416 records.
The weight of the dump CSV: 902 MB. The kit also includes a table of dimensions of auto parts, which contains 3,809,063 records on the dimensions of parts.

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;

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