admin/db/0810/www_spec_items.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 Laminated Touchscreen (960X400)',1),(45,8,'硬件方案','Hardware solution','DAC：AK4191EQ+AK4499EX；蓝牙解码：QCC5125','DAC: AK4191EQ+AK4499EX; Bluetooth decoding: QCC5125',2),(46,8,'音频处理器','Audio processor','AKM 7739 DSP','AKM 7739 DSP',3),(47,8,'运放芯片','Op-Amp chip','OPA1612','OPA1612',4),(48,8,'尺寸','dimension','宽：300mm × 长：206mm × 高：65mm','Width: 300mm * Length: 206mm * Height: 65mm',5),(49,8,'电源','Power supply','超低噪声线性电源','Ultra-Low Noise Linear Power Supply',6),(50,8,'额定功率','Rated Power','25W','25W',7),(51,8,'包装清单','Packing list','电源线 ×1、遥控器 ×1、USB-B 线缆 ×1、用户手册 ×1','Power Cable ×1, Remote Controller ×1, USB-B Cable×1, User Manual ×1',8),(52,8,'颜色','Color','银色','Silver',9),(53,8,'重量','Weight','3.72kg','3.72kg',10),(54,8,'操作方式','Operation method','触摸屏、红外 + 蓝牙遥控、Luxsin专用应用程序（兼容 Android 和 iOS）','Touchscreen, Infrared + Bluetooth Remote Control, Luxsin App (compatible with Android and iOS)',11),(55,9,'播放和DAC解码','Play & DAC','支持立体声 DSD512，PCM 768KHz 32位','support DSD512，PCM 768KHz 32-bit',0),(56,9,'蓝牙音频输入','Bluetooth audio input','蓝牙 BT5.0，支持 SBC/AAC','BT5.0，support AAC/SBC',1),(57,9,'USB-B音频输入','USB-B audio input','支持 Windows (10, 11)，Android，IOS。支持立体声 DSD512，PCM 768KHz 32位','support Windows(10, 11)，Android，IOS。support DSD512，PCM 768KHz 32-bit',2),(58,9,'光纤/同轴音频输入','Optical/Coaxial audio input','支持立体声 PCM 192KHz 24位，DoP64','support PCM 192KHz 24-bit，DoP64',3),(59,9,'HDMI ARC','HDMI ARC','支持立体声 PCM 192KHz 24位','support PCM 192KHz 24-bit',4),(60,9,'模拟前级音频输入','Analog input','RCA（非平衡），最大增益 +10dB','RCA (unbalance)，max gain +10dB',5),(61,9,'模拟音频输出接口','Analog audio output interface','XLR（平衡）+ RCA（非平衡）+ 低音炮输出','XLR(balanced)+RCA(unbalanced)+subwoofer output',6),(62,9,'XLR输出音频特性','XLR Audio Output','输出电平：4.2Vrms@0dBFS\n频率响应：20Hz~20KHz (±0.25dB)\n动态范围：> 128dB\n信噪比：>128dB\nTHD+N：<0.000096% (-120.3dB) @ 不计权\n串扰：>-117dB','output level 4.2Vrms@0dBFS\nFrequency Response：20Hz~20KHz(±0.25dB)\nDynamic Range：> 128dB\nSignal-to-Noise Ratio(SNR)：>128dB\nTHD+N：<0.000096%(-120.3dB)@ Unweighted\nCrosstalk：>-117dB',7),(63,9,'RCA输出音频特性','RCA Audio Output','输出电平：2.1Vrms@0dBFS\n频率响应：20Hz~20KHz (±0.25dB)\n动态范围：> 125dB\n信噪比：>125dB\nTHD+N：<0.00010% (-119dB) @ 不计权\n串扰：>-114dB','output level 2.1Vrms@0dBFS\nFrequency Response：20Hz~20KHz(±0.25dB)\nDynamic Range：> 125dB\nSignal-to-Noise Ratio(SNR)：>125dB\nTHD+N：<0.00010%(-119dB)@ Unweighted\nCrosstalk：>-114dB',8),(64,9,'耳机输出音频特性','Headphone Audio Output','输出电平：4-15Vrms@0dBFS\n频率响应：20Hz~20KHz (±0.25dB)\n动态范围：> 128dB\n信噪比：>128dB\nTHD+N：<0.00016% (-116dB) @ 不计权','output level 4-15Vrms@0dBFS\nFrequency Response：20Hz~20KHz(±0.25dB)\nDynamic Range：> 128dB\nSignal-to-Noise Ratio(SNR)：>128dB\nTHD+N：<0.00016%(-116dB)@ Unweighted',9),(65,10,'USB-A Port','USB-A Port','仅限更新固件用','For Firmware Updates Only',0),(66,10,'USB-B Port','USB-B Port','USB Audio系统兼容性: Windows (10, 11)，Android，IOS系统 最高支持立体声 DSD512，PCM 768KHz/32Bit','USB Audio System Compatibility: Windows (10, 11), Android, iOS; Supports up to Stereo DSD512, PCM 768kHz/32-Bit',1),(67,10,'USB Type-C','USB Type-C','USB Audio系统兼容性: Windows (10, 11)，Android，IOS系统 最高支持立体声 DSD512，PCM 768KHz/32Bit','USB Audio System Compatibility: Windows (10, 11), Android, iOS; Supports up to Stereo DSD512, PCM 768kHz/32-Bit',2),(68,10,'模拟单端（输入）','Analog (unbalanced input)','RAC*2（非平衡），最大增益 +10dB','RAC*2 (unbalanced)，Max Gain +10dB',3),(69,10,'光纤','Optical','最高支持立体声 PCM 192KHz 24Bit、DoP64','Support up to PCM 192KHz 24-bit，DoP64',4),(70,10,'同轴','Coaxial','RAC*1','RAC*1',5),(71,10,'蓝牙接收5.0','Bluetooth input','蓝牙BT5.0，支持SBC/AAC','BT5.0，support AAC/SBC',6),(72,10,'HDMI ARC','HDMI ARC','最高支持立体声PCM 192KHz 24Bit','support PCM 192KHz 24-bit',7),(73,10,'TRIGGER接口','TRIGGER Connection','标准3.5mm耳机插座（TRIGGER IN接口*1+TRIGGER OUT接口*1）','3.5mm Headphone Jack (TRIGGER IN ×1 + TRIGGER OUT ×1)',8),(74,10,'WiFi','WiFi','WiFi 2.4G / 5G','WiFi 2.4G / 5G',9),(75,10,'音量旋钮','Volume Knob','编码器旋钮','Encoder Knob',10),(76,10,'开机按钮','Power Button','单按静音，长按待机','Single Press: Mute, Long Press: Standby',11),(77,10,'电源开关','Power Switch','船形开关','Rocker Switch',12),(78,10,'电源','Power Supply','AC 100-240V~50/60Hz','AC 100-240V~50/60Hz',13),(79,10,'遥控器','Controller','红外遥控器12键','12-Button Infrared Remote Control',14),(80,11,'平衡线路输出接口','Balanced Circuit Output','XLR3平衡插座','XLR3 Balanced Socket',0),(81,11,'单端线路输出接口','Unbalanced Circuit Output','RCA插座*2','RCA*2',1),(82,11,'低音炮输出接口','Subwoofer Output','RCA插座*2','RCA*2',2),(83,11,'平衡耳机输出接口','Balanced Headphone Output','标准4.4mm插座*1+XLR4平衡插座*1','4.4mm Socket ×1 + XLR4 Balanced Socket ×1',3),(84,11,'单端耳机输出接口','Unbalanced Headphone Output','标准6.35mm 插座','6.35mm Socket',4);
/*!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 */;