40 lines
12 KiB
SQL
40 lines
12 KiB
SQL
|
|
|||
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|||
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|||
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|||
|
|
/*!50503 SET NAMES utf8mb4 */;
|
|||
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|||
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
|||
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|||
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|||
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|||
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `www_spec_items` (
|
|||
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|||
|
|
`spec_group_id` bigint unsigned NOT NULL COMMENT '所属参数分组 ID',
|
|||
|
|
`name_zh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '参数名称（中文）',
|
|||
|
|
`name_en` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '参数名称（英文）',
|
|||
|
|
`value_zh` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '参数值（中文）',
|
|||
|
|
`value_en` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '参数值（英文）',
|
|||
|
|
`sort_order` int NOT NULL DEFAULT '0' COMMENT '参数排序',
|
|||
|
|
PRIMARY KEY (`id`),
|
|||
|
|
KEY `idx_spec_group` (`spec_group_id`)
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='产品参数规格项';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
/*!40000 ALTER TABLE `www_spec_items` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `www_spec_items` (`id`, `spec_group_id`, `name_zh`, `name_en`, `value_zh`, `value_en`, `sort_order`) VALUES (1,1,'型号','Model','Luxsin X8','Luxsin X8',0),(2,1,'尺寸','Dimensions','236mm (长) × 236.8mm (宽) × 64mm (高)','236mm (L) × 236.8mm (W) × 64mm (H)',1),(3,1,'重量','Weight','2750g','2750g',2),(4,1,'电源输入','Input Power','AC 100–120V/220–240V~50/60Hz','AC 100-120V/220-240V~50/60Hz',3),(5,1,'屏幕','Display','4英寸 LCD（480×960）触摸屏','4\" LCD (480*960) Touchscreen',4),(6,1,'解码','DAC','Cirrus Logic CS43198 × 8','Cirrus Logic CS43198 × 8',5),(7,1,'内部电源','Power Supply','超低底噪可调电压线性电源','Ultra-low-noise, voltage-adjustable Linear Power Supply',6),(8,1,'WiFi','WiFi','支持2.4G/5G双频WiFi','Wi-Fi 2.4GHz / 5GHz',7),(9,1,'蓝牙接收','Bluetooth','Qualcomm SXW5125 (BT 5.1)','Qualcomm SXW5125 (BT 5.1)',8),(10,1,'控制方式','Control Methods','触控屏, 移动设备 APP (Android/iOS), 电脑浏览器, 红外遥控器(选购配件)','Touchscreen, Mobile APP (Android/iOS), Web Browser, IR Remote(Optional)',9),(11,1,'额定功率','Rated Power','25W','25W',10),(12,1,'包装清单','Packing List','电源线×1，USB-B线×1, 3.5mm转6.35mm适配器×1','Power Cable ×1, USB-B cable ×1, 3.5mm to 6.35mm adapter ×1',11),(13,2,'USB-A 输入','USB-A Input','用于本地固件更新','For local firmware update',0),(14,2,'USB-B 输入','USB-B Input','最高支持 PCM 768kHz/32bit; DSD512(Native)','Up to PCM 768kHz/32bit; DSD512(Native)',1),(15,2,'USB-C 输入','USB-C Input','最高支持 PCM 768kHz/32bit; DSD512(Native)','Up to PCM 768kHz/32bit; DSD512(Native)',2),(16,2,'IIS 输入','IIS Input','最高支持 PCM 768kHz/32bit; DSD512(Native)','Up to PCM 768kHz/32bit; DSD512(Native)',3),(17,2,'同轴输入','Coaxial Input','最高支持 PCM 192kHz/24bit','Up to PCM 192kHz/24bit',4),(18,2,'光纤输入','Optical Input','最高支持 PCM 192kHz/24bit','Up to PCM 192kHz/24bit',5),(19,2,'TRIGGER IN','TRIGGER IN','标准3.5mm耳机插座','Standard 3.5mm headphone jack',6),(20,2,'TRIGGER OUT','TRIGGER OUT','标准3.5mm耳机插座','Standard 3.5mm headphone jack',7),(21,2,'模拟输出接口','Analog Output','RCA','RCA',8),(22,2,'数字输出接口','Balanced Output','XLR','XLR',9),(23,2,'耳机输出接口','Headphone Output','6.35mm（非平衡），4.4mm（平衡），4 pin XLR（平衡）','6.35mm (Unbalanced), 4.4mm (Balanced), 4 pin XLR (Balanced)',10),(24,3,'信噪比','SNR','≥129.5dB','≥129.5dB',0),(25,3,'总谐波失真','THD+N','＜−121.8dB @不加权','< -121.8dB @ unweighted',1),(26,3,'声道分离度','Crosstalk','≥133dB (1kHz@200kΩ)','≥133dB (1kHz@200kΩ)',2),(27,3,'底噪','Noise Floor','＜1.1uVrms','< 1.1uVrms',3),(28,3,'线路输出电平','Output Level','4.2Vrms (1kHz@200kΩ)','4.2Vrms (1kHz@200kΩ)',4),(29,4,'信噪比','SNR','≥124.5dB','≥124.5dB',0),(30,4,'总谐波失真','THD+N','＜−120dB @不加权','< -120dB @ unweighted',1),(31,4,'声道分离度','Crosstalk','≥125dB (1kHz@100kΩ)','≥125dB (1kHz@100kΩ)',2),(32,4,'底噪','Noise Floor','＜1.3uVrms','< 1.3uVrms',3),(33,4,'线路输出电平','Output Level','2.1Vrms (1kHz@100kΩ)','2.1Vrms (1kHz@100kΩ)',4),(34,5,'高增益','High Gain','L+R≥4840mW+4840mW（16Ω, THD+N＜1%）','L+R≥4840mW+4840mW (16Ω, THD+N < 1%)',0),(35,5,'输出阻抗','Output Impedance','＜1Ω','< 1Ω',1),(36,5,'总谐波失真','THD+N','＜−117dB (1kHz/0dB@32Ω)','< -117dB (1kHz / 0dB @ 32Ω)',2),(37,5,'信噪比','SNR','≥123dB','≥123dB',3),(38,5,'声道分离度','Crosstalk','≥119dB (1kHz@32Ω)','≥119dB (1kHz @ 32Ω)',4),(39,6,'高增益','High Gain','L+R≥2900mW+2900mW（16Ω，THD+N＜1%）','L+R≥2900mW+2900mW (16Ω, THD+N < 1%)',0),(40,6,'输出阻抗','Output Impedance','＜1Ω','< 1Ω',1),(41,6,'总谐波失真','THD+N','＜−115dB (1kHz/0dB@32Ω)','< -115dB (1kHz/0dB@32Ω)',2),(42,6,'信噪比','SNR','≥121dB','≥121dB',3),(43,8,'型号','Model','X9','X9',0),(44,8,'显示屏','Display','4 英寸 TFT 全贴合触摸屏（960×400）','4-inch TFT Fully Lamina
|
|||
|
|
/*!40000 ALTER TABLE `www_spec_items` ENABLE KEYS */;
|
|||
|
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|||
|
|
|
|||
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|||
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|||
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|||
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|||
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|||
|
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|||
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|||
|
|
|