Skip to content

Instantly share code, notes, and snippets.

@liuqun
Last active April 26, 2023 13:42
Show Gist options
  • Save liuqun/138b63f9ff57e76aef753f4d356d5d6a to your computer and use it in GitHub Desktop.
Save liuqun/138b63f9ff57e76aef753f4d356d5d6a to your computer and use it in GitHub Desktop.
The Chinese translation of part-types for https://github.com/replaysMike/Binner . A SQL script exported from my MySQL database:
/*
Navicat Premium Data Transfer
Source Server : localhost
Source Server Type : MariaDB
Source Server Version : 100508
Source Host : localhost:3306
Source Schema : binner
Target Server Type : MariaDB
Target Server Version : 100508
File Encoding : 65001
Date: 26/04/2023 21:27:17
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for parttypes
-- ----------------------------
DROP TABLE IF EXISTS `parttypes`;
CREATE TABLE `parttypes` (
`PartTypeId` bigint(20) NOT NULL AUTO_INCREMENT,
`UserId` int(11) NULL DEFAULT NULL,
`ParentPartTypeId` bigint(20) NULL DEFAULT NULL,
`Name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`DateCreatedUtc` datetime(6) NOT NULL DEFAULT utc_timestamp,
`DateModifiedUtc` datetime(6) NOT NULL DEFAULT utc_timestamp,
`OrganizationId` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`PartTypeId`) USING BTREE,
INDEX `IX_PartTypes_Name_UserId`(`Name`, `UserId`) USING BTREE,
INDEX `IX_PartTypes_ParentPartTypeId`(`ParentPartTypeId`) USING BTREE,
INDEX `IX_PartTypes_UserId`(`UserId`) USING BTREE,
CONSTRAINT `FK_PartTypes_PartTypes_ParentPartTypeId` FOREIGN KEY (`ParentPartTypeId`) REFERENCES `parttypes` (`PartTypeId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `FK_PartTypes_Users_UserId` FOREIGN KEY (`UserId`) REFERENCES `users` (`UserId`) ON DELETE SET NULL ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 205 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of parttypes
-- ----------------------------
INSERT INTO `parttypes` VALUES (1, NULL, NULL, '01.电阻', '2023-04-26 02:44:52.267660', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (2, NULL, NULL, '02.电容', '2023-04-26 02:44:52.292438', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (3, NULL, NULL, '03.电感', '2023-04-26 02:44:52.292883', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (4, NULL, NULL, '04.二极管', '2023-04-26 02:44:52.292929', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (5, NULL, NULL, '05.发光二极管', '2023-04-26 02:44:52.292969', '2023-04-26 06:34:40.926407', 1);
INSERT INTO `parttypes` VALUES (6, NULL, NULL, '06.三极管', '2023-04-26 02:44:52.292996', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (7, NULL, NULL, '07.继电器', '2023-04-26 02:44:52.293032', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (8, NULL, NULL, '08.变压器', '2023-04-26 02:44:52.293063', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (9, NULL, NULL, '09.晶振', '2023-04-26 02:44:52.293093', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (10, NULL, NULL, '10.传感器', '2023-04-26 02:44:52.293126', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (11, NULL, NULL, '11.拨码开关', '2023-04-26 02:44:52.293150', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (12, NULL, NULL, '12.线材', '2023-04-26 02:44:52.293173', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (13, NULL, NULL, '13.接插件', '2023-04-26 02:44:52.293195', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (14, NULL, NULL, '14.IC芯片', '2023-04-26 02:44:52.293216', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (15, NULL, NULL, '15.现成模块', '2023-04-26 02:44:52.293240', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (16, NULL, NULL, '16.开发板', '2023-04-26 02:44:52.293263', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (17, NULL, NULL, '17.机械零部件', '2023-04-26 02:44:52.293285', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (18, NULL, NULL, '18.Other', '2023-04-26 02:44:52.293312', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (19, NULL, 14, '19.运放 OpAmp', '2023-04-26 02:44:52.293501', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (20, NULL, 14, '20.Amplifier', '2023-04-26 02:44:52.293584', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (21, NULL, 14, '21.内存颗粒 MemoryIC', '2023-04-26 02:44:52.293673', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (22, NULL, 14, '22.逻辑电路 LogicIC', '2023-04-26 02:44:52.293751', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (23, NULL, 14, '23.接口电路 InterfaceIC', '2023-04-26 02:44:52.293787', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (24, NULL, 14, '24.微控制器 Microcontroller', '2023-04-26 02:44:52.293818', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (25, NULL, 14, '25.时钟 ClockIC', '2023-04-26 02:44:52.293845', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (26, NULL, 14, '26.ADC', '2023-04-26 02:44:52.293872', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (27, NULL, 14, '27.LDO稳压器芯片 Voltage Regulator IC', '2023-04-26 02:44:52.293900', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (28, NULL, 14, '28.能耗计量芯片 Energy Metering IC', '2023-04-26 02:44:52.293930', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (29, NULL, 14, '29.LED驱动芯片', '2023-04-26 02:44:52.293958', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (30, NULL, 14, '30.音频芯片', '2023-04-26 02:44:52.293990', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (31, NULL, 14, '31.比较器 Comparator IC', '2023-04-26 02:44:52.294019', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (32, NULL, 14, '32.计数器 Counter IC', '2023-04-26 02:44:52.294047', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (33, NULL, 14, '33.分压器 Divider IC', '2023-04-26 02:44:52.294075', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (34, NULL, 14, '34.PMIC', '2023-04-26 02:44:52.294102', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (35, NULL, 14, '35.FPGA', '2023-04-26 02:44:52.294129', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (36, NULL, 14, '36.高速采集器Data Acquisition IC', '2023-04-26 02:44:52.294158', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (37, NULL, 14, '37.Embedded IC', '2023-04-26 02:44:52.294186', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (38, NULL, 14, '38.其他专用芯片', '2023-04-26 02:44:52.294214', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (39, NULL, 2, 'Ceramic Capacitor', '2023-04-26 02:44:52.294242', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (40, NULL, 2, 'Electrolytic Capacitor', '2023-04-26 02:44:52.294269', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (41, NULL, 2, 'Film Capacitor', '2023-04-26 02:44:52.294295', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (42, NULL, 2, 'Mica Capacitor', '2023-04-26 02:44:52.294322', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (43, NULL, 2, 'Non-Polarized Capacitor', '2023-04-26 02:44:52.294349', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (44, NULL, 2, 'Supercapacitor Capacitor', '2023-04-26 02:44:52.294376', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (45, NULL, 2, 'Paper Capacitor', '2023-04-26 02:44:52.294404', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (46, NULL, 2, 'Variable Capacitor (可调电容器)', '2023-04-26 02:44:52.294432', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (47, NULL, 1, 'Carbon Film Resistor', '2023-04-26 02:44:52.294458', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (48, NULL, 1, 'Metal Film Resistor', '2023-04-26 02:44:52.294487', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (49, NULL, 1, 'Wirewound Resistor 绕线电阻/滑动变阻器', '2023-04-26 02:44:52.294514', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (50, NULL, 1, 'Metal Oxide Resistor', '2023-04-26 02:44:52.294540', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (51, NULL, 1, 'Metal Strip Resistor', '2023-04-26 02:44:52.294566', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (52, NULL, 1, 'Power Resistor', '2023-04-26 02:44:52.294593', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (53, NULL, 1, 'Resistor Array', '2023-04-26 02:44:52.294618', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (54, NULL, 1, 'Variable Resistor', '2023-04-26 02:44:52.294648', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (55, NULL, 3, 'Air Core Inductor', '2023-04-26 02:44:52.294675', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (56, NULL, 3, 'Iron Core Inductor', '2023-04-26 02:44:52.294703', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (57, NULL, 3, 'Ferrite Core Inductor', '2023-04-26 02:44:52.294730', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (58, NULL, 3, 'Iron Powder Inductor', '2023-04-26 02:44:52.294758', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (59, NULL, 3, 'Laminated CoreInductor', '2023-04-26 02:44:52.294784', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (60, NULL, 3, 'Bobbin Inductor', '2023-04-26 02:44:52.294812', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (61, NULL, 3, 'Toroidal Inductor', '2023-04-26 02:44:52.294837', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (62, NULL, 3, 'MultiLayer Ceramic Inductor', '2023-04-26 02:44:52.294863', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (63, NULL, 4, 'Zener', '2023-04-26 02:44:52.294890', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (64, NULL, 4, 'Schottky', '2023-04-26 02:44:52.294916', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (65, NULL, 4, 'Small Signal Diode', '2023-04-26 02:44:52.294942', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (66, NULL, 4, 'Large Signal Diode', '2023-04-26 02:44:52.294972', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (67, NULL, 4, 'Shockley', '2023-04-26 02:44:52.294999', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (68, NULL, 4, 'Peltier Diode', '2023-04-26 02:44:52.295026', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (69, NULL, 4, 'Gunn Diode', '2023-04-26 02:44:52.295052', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (70, NULL, 4, 'Tunnel Diode', '2023-04-26 02:44:52.295079', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (71, NULL, 4, 'Step Recovery Diode', '2023-04-26 02:44:52.295105', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (72, NULL, 4, 'Varactor Diode', '2023-04-26 02:44:52.295132', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (73, NULL, 4, 'Transient Voltage Suppression Diode', '2023-04-26 02:44:52.295158', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (74, NULL, 4, 'Crystal Diode', '2023-04-26 02:44:52.295184', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (75, NULL, 6, 'MOSFET', '2023-04-26 02:44:52.295211', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (76, NULL, 6, 'IGBT', '2023-04-26 02:44:52.295237', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (77, NULL, 6, 'JFET', '2023-04-26 02:44:52.295264', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (78, NULL, 6, 'SCR', '2023-04-26 02:44:52.295289', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (79, NULL, 6, 'DIAC', '2023-04-26 02:44:52.295316', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (80, NULL, 6, 'TRIAC', '2023-04-26 02:44:52.295343', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (81, NULL, 7, 'Electromagnetic Relay (电磁继电器)', '2023-04-26 02:44:52.295370', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (82, NULL, 7, 'Latching Relay', '2023-04-26 02:44:52.295400', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (83, NULL, 7, 'Solid State Relay', '2023-04-26 02:44:52.295427', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (84, NULL, 7, 'Reed Relay', '2023-04-26 02:44:52.295453', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (85, NULL, 7, 'Time Relay', '2023-04-26 02:44:52.295481', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (86, NULL, 7, 'Thermal Relay', '2023-04-26 02:44:52.295507', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (87, NULL, 7, 'Sequence Relay', '2023-04-26 02:44:52.295535', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (88, NULL, 7, 'Rotary Relay', '2023-04-26 02:44:52.295562', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (89, NULL, 7, 'High Voltage Relay', '2023-04-26 02:44:52.295590', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (90, NULL, 8, 'Step Down Transformer', '2023-04-26 02:44:52.295618', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (91, NULL, 8, 'Step Up Transformer', '2023-04-26 02:44:52.295647', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (92, NULL, 8, 'Isolation Transformer', '2023-04-26 02:44:52.295674', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (93, NULL, 8, 'SolidState Transformer', '2023-04-26 02:44:52.295701', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (94, NULL, 8, 'Rf Transformer', '2023-04-26 02:44:52.295728', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (95, NULL, 8, 'Audio Transformer', '2023-04-26 02:44:52.295756', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (96, NULL, 10, 'Sensor Assembly', '2023-04-26 02:44:52.295781', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (97, NULL, 10, 'Light Sensor 光敏电阻传感器', '2023-04-26 02:44:52.295809', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (98, NULL, 10, 'Imaging Sensor 图片传感器', '2023-04-26 02:44:52.295834', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (99, NULL, 10, 'Current Sensor 电流传感器', '2023-04-26 02:44:52.295866', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (100, NULL, 10, 'Voltage Sensor 电压传感器', '2023-04-26 02:44:52.295894', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (101, NULL, 10, 'Load Sensor 称重传感器', '2023-04-26 02:44:52.295921', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (102, NULL, 10, 'Distance Sensor 距离传感器', '2023-04-26 02:44:52.295968', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (103, NULL, 10, 'Force Sensor 压力应变传感器', '2023-04-26 02:44:52.295998', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (104, NULL, 10, 'Rf Sensor 射频信号传感器', '2023-04-26 02:44:52.296029', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (105, NULL, 10, 'Motion Sensor 运动传感器', '2023-04-26 02:44:52.296058', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (106, NULL, 10, 'Capacitive Sensor 电容传感器', '2023-04-26 02:44:52.296085', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (107, NULL, 10, 'Biometric Sensor 生物识别传感器', '2023-04-26 02:44:52.296113', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (108, NULL, 10, 'Environment Sensor 环境传感器', '2023-04-26 02:44:52.296139', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (109, NULL, 10, 'Radiation Sensor 辐射传感器', '2023-04-26 02:44:52.296166', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (110, NULL, 10, '其他传感器', '2023-04-26 02:44:52.296192', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (111, NULL, 15, 'Wireless Module', '2023-04-26 02:44:52.296219', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (112, NULL, 15, 'CurrentVoltage Module', '2023-04-26 02:44:52.296245', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (113, NULL, 15, 'Experiment Module', '2023-04-26 02:44:52.296273', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (114, NULL, 15, 'Raspberry Pi Shield 扩展板', '2023-04-26 02:44:52.296299', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (115, NULL, 15, 'Arduino Shield 扩展板', '2023-04-26 02:44:52.296326', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (116, NULL, 15, 'Evaluation Module', '2023-04-26 02:44:52.296353', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (117, NULL, 15, 'Other Module', '2023-04-26 02:44:52.296379', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (118, NULL, 16, 'Raspberry Pi (树莓派)', '2023-04-26 02:44:52.296406', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (119, NULL, 16, 'Arduino', '2023-04-26 02:44:52.296431', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (120, NULL, 16, 'Beagle Board', '2023-04-26 02:44:52.296464', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (121, NULL, 16, 'NVidia Jetson', '2023-04-26 02:44:52.296492', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (122, NULL, 16, 'Teensy', '2023-04-26 02:44:52.296518', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (123, NULL, 16, 'Launchpad', '2023-04-26 02:44:52.296546', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (124, NULL, 16, 'Alchitry', '2023-04-26 02:44:52.296572', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (125, NULL, 16, 'Amica', '2023-04-26 02:44:52.296599', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (126, NULL, 16, 'Particle', '2023-04-26 02:44:52.296625', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (127, NULL, 16, 'Sparkfun', '2023-04-26 02:44:52.296652', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (128, NULL, 16, 'Qwiic', '2023-04-26 02:44:52.296679', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (129, NULL, 16, 'Pic', '2023-04-26 02:44:52.296707', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (130, NULL, 16, 'STM32', '2023-04-26 02:44:52.296733', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (131, NULL, 16, 'Mikro Elektronika', '2023-04-26 02:44:52.296761', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (132, NULL, 16, 'Basic Evaluation', '2023-04-26 02:44:52.296787', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (133, NULL, 16, 'Pine', '2023-04-26 02:44:52.296813', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (134, NULL, 16, 'Odriod', '2023-04-26 02:44:52.296840', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (135, NULL, 16, 'Latte Panda', '2023-04-26 02:44:52.296866', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (136, NULL, 16, 'Seeeduino', '2023-04-26 02:44:52.296893', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (137, NULL, 16, 'Silicon Labs', '2023-04-26 02:44:52.296919', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (138, NULL, 16, 'Rock Pi', '2023-04-26 02:44:52.296946', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (139, NULL, 16, 'Udoo', '2023-04-26 02:44:52.296972', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (140, NULL, 16, 'Pocket Beagle', '2023-04-26 02:44:52.296999', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (141, NULL, 16, 'Asus Tinker', '2023-04-26 02:44:52.297025', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (142, NULL, 16, '其他评估板/开发板 Other Evaluation', '2023-04-26 02:44:52.297052', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (143, NULL, 17, '电源适配器 Adapter', '2023-04-26 02:44:52.297078', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (144, NULL, 17, '螺丝钉/螺杆 Screw', '2023-04-26 02:44:52.297105', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (145, NULL, 17, '弹簧垫圈 Washer', '2023-04-26 02:44:52.297131', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (146, NULL, 17, '螺母 Nut', '2023-04-26 02:44:52.297157', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (147, NULL, 17, '立柱 Standoff', '2023-04-26 02:44:52.297191', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (148, NULL, 17, '齿轮 Gear', '2023-04-26 02:44:52.297218', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (149, NULL, 17, '耦合线圈 Coupler', '2023-04-26 02:44:52.297244', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (150, NULL, 17, '轴承 BallBearing', '2023-04-26 02:44:52.297272', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (151, NULL, 17, '托盘 Bracket', '2023-04-26 02:44:52.297298', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (152, NULL, 17, '传动轴 Shaft', '2023-04-26 02:44:52.297326', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (153, NULL, 17, '垫片 Gasket/Spacer', '2023-04-26 02:44:52.297351', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (154, NULL, 17, '管件 Tube', '2023-04-26 02:44:52.297378', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (155, NULL, 17, '板材 Plate', '2023-04-26 02:44:52.297404', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (156, NULL, 17, '耗材 RawMaterial', '2023-04-26 02:44:52.297432', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (157, NULL, 17, 'Mount', '2023-04-26 02:44:52.297457', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (158, NULL, 17, '履带皮带 Belt', '2023-04-26 02:44:52.297484', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (159, NULL, 17, '集线器 Hub', '2023-04-26 02:44:52.297510', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (160, NULL, 17, '风扇 Fan', '2023-04-26 02:44:52.297535', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (161, NULL, 17, '滑轮 Wheel', '2023-04-26 02:44:52.297562', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (162, NULL, 17, '机械臂 Robotics', '2023-04-26 02:44:52.297589', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (163, NULL, 14, 'Flip-Flop IC 数字触发器', '2023-04-26 02:44:52.297616', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (164, NULL, 3, 'Adjustable Inductor (可调电感)', '2023-04-26 02:44:52.297641', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (165, NULL, 10, 'Pressure Sensor 压力传感器', '2023-04-26 02:44:52.297670', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (166, NULL, 10, 'Photo-Diodes 光电二极管', '2023-04-26 02:44:52.297696', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (167, NULL, 10, 'Color Sensor 色敏传感器', '2023-04-26 02:44:52.297723', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (168, NULL, 10, 'Humidity Sensor 湿度传感器', '2023-04-26 02:44:52.297750', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (169, NULL, 10, 'Gas Sensor 气体传感器', '2023-04-26 02:44:52.297778', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (170, NULL, 10, 'Flow Sensor 流量传感器', '2023-04-26 02:44:52.297805', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (171, NULL, 10, 'Tilt Sensor 倾角传感器', '2023-04-26 02:44:52.297832', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (172, NULL, 10, 'Proximity Sensor 接近传感器', '2023-04-26 02:44:52.297858', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (173, NULL, 10, 'Temperature Sensor 温度传感器', '2023-04-26 02:44:52.297884', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (174, NULL, 10, 'Touch Sensor 触摸电容传感器', '2023-04-26 02:44:52.297912', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (175, NULL, 10, 'Ultrasonic Sensor 超声波传感器', '2023-04-26 02:44:52.297939', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (176, NULL, 17, 'Spring', '2023-04-26 02:44:52.297966', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (177, NULL, 17, '孔眼 Grommet', '2023-04-26 02:44:52.298000', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (178, NULL, 6, 'BJT', '2023-04-26 02:44:52.298028', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (179, NULL, 10, 'Audio Sensor 声音传感器', '2023-04-26 02:44:52.298055', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (180, NULL, 10, 'Liquid Sensor 液体传感器', '2023-04-26 02:44:52.298081', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (181, NULL, 10, 'Magnetic Sensor 电磁传感器', '2023-04-26 02:44:52.298109', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (182, NULL, 10, 'Hall Effect Sensor 霍尔效应传感器', '2023-04-26 02:44:52.298135', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (183, NULL, 10, 'Smoke Sensor 烟雾传感器', '2023-04-26 02:44:52.298163', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (184, NULL, 10, 'Air Quality Sensor 空气污染传感器', '2023-04-26 02:44:52.298189', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (185, NULL, 10, 'Acceleration Sensor 加速度传感器', '2023-04-26 02:44:52.298216', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (186, NULL, 10, 'Position Sensor 位置传感器', '2023-04-26 02:44:52.298243', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (187, NULL, 10, 'Gyroscope Sensor 陀螺仪', '2023-04-26 02:44:52.298270', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (188, NULL, 10, 'Incline Sensor 倾斜传感器', '2023-04-26 02:44:52.298296', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (189, NULL, 10, 'Speed Sensor 速度传感器', '2023-04-26 02:44:52.298323', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (190, NULL, 10, 'Vibration Sensor 震动传感器', '2023-04-26 02:44:52.298350', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (191, NULL, 10, 'Infrared Sensor 红外传感器', '2023-04-26 02:44:52.298378', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (192, NULL, 17, '设备箱 Enclosure', '2023-04-26 02:44:52.298404', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (193, NULL, 1, 'Ceramic Resistor', '2023-04-26 02:44:52.298431', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (194, NULL, 1, 'Current Sense Resistor', '2023-04-26 02:44:52.298458', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (195, NULL, 1, 'High Frequency Resistor', '2023-04-26 02:44:52.298484', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (196, NULL, 1, 'Metal Foil Resistor', '2023-04-26 02:44:52.298513', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (197, NULL, 1, '电阻套件 Resistor Kit', '2023-04-26 02:44:52.298540', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (198, NULL, 1, 'Potentiometer', '2023-04-26 02:44:52.298570', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (199, NULL, 2, 'Safety Capacitor', '2023-04-26 02:44:52.298600', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (200, NULL, 2, 'Tantalum Capacitor (钽电容)', '2023-04-26 02:44:52.298628', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (201, NULL, NULL, '套件类', '2023-04-26 02:44:52.298660', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (202, NULL, 2, '电容套件 Capacitor Kit', '2023-04-26 02:44:52.298708', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (203, NULL, 4, '二极管套件 Diode Kit', '2023-04-26 02:44:52.298748', '2023-04-25 03:17:34.000000', 1);
INSERT INTO `parttypes` VALUES (204, NULL, 3, '电感套件 Inductor Kit', '2023-04-26 02:44:52.298782', '2023-04-25 03:17:34.000000', 1);
SET FOREIGN_KEY_CHECKS = 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment