/*
 Navicat Premium Data Transfer

 Source Server         : MySQL
 Source Server Type    : MySQL
 Source Server Version : 80017 (8.0.17)
 Source Host           : localhost:3306
 Source Schema         : his

 Target Server Type    : MySQL
 Target Server Version : 80017 (8.0.17)
 File Encoding         : 65001

 Date: 06/06/2023 12:30:33
*/


-- ----------------------------
-- Table structure for tb_action
-- ----------------------------
CREATE TABLE `tb_action`  (
  `id` int(10) UNSIGNED NOT NULL COMMENT '主键',
  `action_code` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '行为编号',
  `action_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '行为名称',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_action_name`(`action_name` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '行为表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tb_action
-- ----------------------------
INSERT INTO `tb_action` VALUES (1, 'INSERT', '添加');
INSERT INTO `tb_action` VALUES (2, 'DELETE', '删除');
INSERT INTO `tb_action` VALUES (3, 'UPDATE', '修改');
INSERT INTO `tb_action` VALUES (4, 'SELECT', '查询');
INSERT INTO `tb_action` VALUES (5, 'APPROVAL', '审批');
INSERT INTO `tb_action` VALUES (6, 'EXPORT', '导出');
INSERT INTO `tb_action` VALUES (7, 'BACKUP', '备份');
INSERT INTO `tb_action` VALUES (8, 'ARCHIVE', '归档');

-- ----------------------------
-- Table structure for tb_appointment
-- ----------------------------
CREATE TABLE `tb_appointment`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `uuid` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'UUID',
  `order_id` int(11) NOT NULL COMMENT '订单编号',
  `date` date NOT NULL COMMENT '预约日期',
  `name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '姓名',
  `sex` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '性别',
  `pid` char(18) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '身份证号',
  `birthday` date NOT NULL COMMENT '出生日期',
  `tel` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '电话号码',
  `mailing_address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '体检报告邮寄地址',
  `company` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '企业名称',
  `status` tinyint(4) NOT NULL COMMENT '状态。1未签到，2已签到，3已结束，4已关闭',
  `checkin_time` datetime NULL DEFAULT NULL COMMENT '签到时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_uuid`(`uuid` ASC) USING BTREE,
  INDEX `idx_order_id`(`order_id` ASC) USING BTREE,
  INDEX `idx_date`(`date` ASC) USING BTREE,
  INDEX `idx_pid`(`pid` ASC) USING BTREE,
  INDEX `idx_tel`(`tel` ASC) USING BTREE,
  INDEX `idx_status`(`status` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '体检预约表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tb_appointment
-- ----------------------------

-- ----------------------------
-- Table structure for tb_appointment_restriction
-- ----------------------------
CREATE TABLE `tb_appointment_restriction`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `date` date NOT NULL COMMENT '日期',
  `num_1` int(11) NOT NULL COMMENT '实际限定体检人数',
  `num_2` int(11) NOT NULL COMMENT '每天体检人数上限',
  `num_3` int(11) NOT NULL COMMENT '实际体检人数',
  `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_date`(`date` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '体检预约限流表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tb_appointment_restriction
-- ----------------------------

-- ----------------------------
-- Table structure for tb_checkup_report
-- ----------------------------
CREATE TABLE `tb_checkup_report`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `appointment_id` int(11) NOT NULL COMMENT '体检预约ID',
  `result_id` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '体检结果ID（MongoDB）',
  `status` tinyint(4) NOT NULL COMMENT '体检报告状态。1未生成，2已生成，3已邮寄',
  `file_path` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提交报告存放在Minio服务器上的URL地址',
  `waybill_code` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '快递运单号',
  `waybill_date` date NULL DEFAULT NULL COMMENT '快递发出日期',
  `date` date NOT NULL COMMENT '体检日期',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_appointment_id`(`appointment_id` ASC) USING BTREE,
  UNIQUE INDEX `unq_result_id`(`result_id` ASC) USING BTREE,
  INDEX `idx_status`(`status` ASC) USING BTREE,
  INDEX `idx_waybill_code`(`waybill_code` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '体检报告表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tb_checkup_report
-- ----------------------------

-- ----------------------------
-- Table structure for tb_customer
-- ----------------------------
CREATE TABLE `tb_customer`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `sex` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
  `tel` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '电话',
  `photo` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '照片URL',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `idx_tel`(`tel` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tb_customer
-- ----------------------------

-- ----------------------------
-- Table structure for tb_customer_im
-- ----------------------------
CREATE TABLE `tb_customer_im`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `customer_id` int(11) NOT NULL COMMENT '客户ID',
  `login_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_customer_id`(`customer_id` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户IM帐户表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tb_customer_im
-- ----------------------------

-- ----------------------------
-- Table structure for tb_customer_location
-- ----------------------------
CREATE TABLE `tb_customer_location`  (
  `id` int(11) NOT NULL COMMENT '主键',
  `customer_id` int(11) NOT NULL COMMENT '客户ID',
  `blue_uuid` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '蓝牙信标UUID',
  `place_id` int(11) NOT NULL COMMENT '科室ID',
  `create_time` datetime NOT NULL COMMENT '日期时间',
  PRIMARY KEY (`id`) USING HASH
) ENGINE = MEMORY AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户位置表' ROW_FORMAT = FIXED;

-- ----------------------------
-- Records of tb_customer_location
-- ----------------------------

-- ----------------------------
-- Table structure for tb_dept
-- ----------------------------
CREATE TABLE `tb_dept`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
  `dept_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '部门名称',
  `tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门电话',
  `email` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门邮箱',
  `desc` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_dept_name`(`dept_name` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tb_dept
-- ----------------------------
INSERT INTO `tb_dept` VALUES (1, '总经理办公室', NULL, NULL, NULL);
INSERT INTO `tb_dept` VALUES (2, '财务部', NULL, NULL, NULL);
INSERT INTO `tb_dept` VALUES (3, '人事部', NULL, NULL, NULL);
INSERT INTO `tb_dept` VALUES (4, '体检部', NULL, '106135489@qq.com', NULL);
INSERT INTO `tb_dept` VALUES (5, '市场部', NULL, NULL, NULL);
INSERT INTO `tb_dept` VALUES (6, '客服部', NULL, NULL, NULL);
INSERT INTO `tb_dept` VALUES (7, '后勤部', NULL, NULL, NULL);
INSERT INTO `tb_dept` VALUES (8, '保安部', NULL, NULL, NULL);
INSERT INTO `tb_dept` VALUES (9, '采购部', NULL, NULL, NULL);
INSERT INTO `tb_dept` VALUES (10, '工程部', NULL, NULL, NULL);
INSERT INTO `tb_dept` VALUES (11, '运营部', NULL, NULL, NULL);

-- ----------------------------
-- Table structure for tb_flow_regulation
-- ----------------------------
CREATE TABLE `tb_flow_regulation`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `place` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '科室名称',
  `real_num` int(11) NOT NULL DEFAULT 0 COMMENT '排队人数',
  `max_num` int(11) NOT NULL COMMENT '最大人数',
  `weight` tinyint(4) NOT NULL DEFAULT 1 COMMENT '权重（自动调流使用）',
  `priority` tinyint(4) NOT NULL DEFAULT 1 COMMENT '优先级（手动调流使用）',
  `blue_uuid` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '蓝牙信标ID',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_place`(`place` ASC) USING BTREE,
  UNIQUE INDEX `unq_blue_uuid`(`blue_uuid` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '人员调流表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tb_flow_regulation
-- ----------------------------
INSERT INTO `tb_flow_regulation` VALUES (1, '眼科', 0, 50, 2, 0, '10389E4158194F77BF25F7E870FB8031');
INSERT INTO `tb_flow_regulation` VALUES (2, '一般检查室', 0, 70, 3, 0, '5284CDE4C3324A76AF1E53185CFDF8B4');
INSERT INTO `tb_flow_regulation` VALUES (3, '内科', 0, 50, 5, 0, '705E7957B5A94CDD80E35BE49EE515C3');
INSERT INTO `tb_flow_regulation` VALUES (4, '动脉硬化检测室', 0, 70, 3, 0, 'DCD0127BAF02415FA57AD7F1537DF2B2');
INSERT INTO `tb_flow_regulation` VALUES (5, '外科', 0, 50, 5, 0, '71B36996898340319C827411CC22C988');
INSERT INTO `tb_flow_regulation` VALUES (6, '耳鼻喉科', 0, 50, 1, 0, '59720B45128F4EEFA787FDC0213908AC');
INSERT INTO `tb_flow_regulation` VALUES (7, '口腔科', 0, 50, 3, 0, '898B174283DA4C7BBEC53738516A9AB1');
INSERT INTO `tb_flow_regulation` VALUES (8, '心电图室', 0, 30, 5, 0, '7256B5401FE341EBBACA647DDF3B3574');
INSERT INTO `tb_flow_regulation` VALUES (9, '采血室', 0, 80, 10, 1, '3463C908B85942EAB8334689797202A5');
INSERT INTO `tb_flow_regulation` VALUES (10, '尿常规室', 0, 50, 2, 0, '446F3C85F1AC483D8542029FD7E4D3D8');
INSERT INTO `tb_flow_regulation` VALUES (11, '骨密度检查室', 0, 30, 1, 0, '\r\n497509887736488CBC170315332B83EB');
INSERT INTO `tb_flow_regulation` VALUES (12, '放射科', 0, 50, 8, 0, '7DD3438252474E81BA597D548B1D2228');
INSERT INTO `tb_flow_regulation` VALUES (13, '妇科', 0, 30, 5, 0, '0DA2F46D909C47549E5367AEA25A5B12');
INSERT INTO `tb_flow_regulation` VALUES (14, '男科', 0, 30, 5, 0, '02CF99A88652403081FE00AC84055200');

-- ----------------------------
-- Table structure for tb_goods
-- ----------------------------
CREATE TABLE `tb_goods`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `code` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号',
  `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品标题',
  `description` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品描述',
  `checkup_1` json NULL COMMENT '科室检查',
  `checkup_2` json NULL COMMENT '实验室检查',
  `checkup_3` json NULL COMMENT '医技检查',
  `checkup_4` json NULL COMMENT '其他检查',
  `checkup` json NULL COMMENT '检查内容',
  `image` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品封面',
  `initial_price` decimal(10, 2) NOT NULL COMMENT '原价',
  `current_price` decimal(10, 2) NOT NULL COMMENT '现价',
  `sales_volume` int(11) NOT NULL DEFAULT 0 COMMENT '销量',
  `type` enum('不限','父母体检','入职体检','职场白领','个人高端','中青年体检') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '套餐类型',
  `tag` json NULL COMMENT '套餐标签',
  `part_id` tinyint(4) NULL DEFAULT NULL COMMENT '1活动专区，2热卖套餐，3新品推荐，4孝敬父母，5,白领精英',
  `rule_id` int(11) NULL DEFAULT NULL COMMENT '促销优惠规则的ID',
  `status` tinyint(1) NOT NULL COMMENT '状态(1上架，0下架)',
  `md5` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'MD5信息',
  `update_time` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_code`(`code` ASC) USING BTREE,
  INDEX `idx_type`(`type` ASC) USING BTREE,
  INDEX `idx_status`(`status` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '体检套餐表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tb_goods
-- ----------------------------
INSERT INTO `tb_goods` VALUES (1, '117GWMN00', '新感恩敬老中级体检套餐', '「感恩季到检钜惠」适合人群：适用于中、老年人及血管疾病人群 （参加第二件0元活动 需加入购物车后数量选2）', '[{\"title\": \"一般健康检查\", \"content\": \"身高、体重、血压、心、肺、肝、脾、神经系统 ；甲状腺、乳腺、肛门、直肠\"}]', '[{\"title\": \"C反应蛋白\", \"content\": \"升高常见于：急性炎症、组织坏死、恶性肿瘤、风湿病等疾病\"}, {\"title\": \"肝功10项\", \"content\": \"丙氨酸氨基转移酶(ALT)测定 ；天门冬氨酸氨基转移酶(AST)测定；总蛋白(TP)测定 ；白蛋白(Alb)测定 ；碱性磷酸酶(ALP)测定 ;γ-谷氨酰基转移酶(GGT)测定;总胆红素(T-Bil)测定;直接胆红素(D-Bil)测定 ；总胆汁酸(TBA)测定 ；胆碱脂酶(ChE)测定\"}, {\"title\": \"甲功七项\", \"content\": \"三碘甲状腺原氨酸(T3)测定 ；甲状腺素(T4)测定 ；促甲状腺激素(TSH)测定 ；游离三碘甲状腺原氨酸(FT3)测定 ；游离甲状腺素(FT4)测定 ；抗甲状腺球蛋白抗体(TGAb)测定 ；抗甲状腺过氧化物酶抗体(TPOAb)测定\"}, {\"title\": \"尿常规\", \"content\": \"尿常规化学分析；尿有形成分分析\"}, {\"title\": \"肾功5项\", \"content\": \"尿素(Urea)测定 ；肌酐(Cr)测定 ；葡萄糖(Glu)测定 ；尿酸(UA)测定 ；β2微球蛋白(β2-MG)测定\"}, {\"title\": \" 糖化血红蛋白\", \"content\": \"检测近2-3个月内的平均血糖水平、用于糖尿病疗效观察\"}, {\"title\": \" 同型半胱氨酸\", \"content\": \"HCY升高是心血管疾病的重要危险因素\"}, {\"title\": \"肌红蛋白\", \"content\": \"肌红蛋白可作为急性心肌梗死(AMI) 诊断的早期最灵敏的指标\"}, {\"title\": \"肌钙蛋白\", \"content\": \"肌钙蛋白\"}, {\"title\": \"心肌酶谱\", \"content\": \"肌酸激酶(CK)测定 ；肌酸激酶-MB同工酶活性(CK-MB)测定 ；乳酸脱氢酶(LD)测定 ；α羟基丁酸脱氢酶(α-HBD)测定\"}, {\"title\": \"全血细胞分析\", \"content\": \"全血细胞分析（五分类），有无贫血、感染、凝血功能是否正常等\"}, {\"title\": \"血脂6项\", \"content\": \"血脂6项：总胆固醇(TC)测定 ；甘油三酯(TG)测定 ；高密度脂蛋白胆固醇(HDL-C)测定 ；低密度脂蛋白胆固醇(LDL-C)测定 ；载脂蛋白AⅠ(apoAⅠ)测定 ；载脂蛋白B(apoB)测定\"}, {\"title\": \"幽门螺杆菌抗体测定\", \"content\": \"细菌抗体测定\"}, {\"title\": \"恶性肿瘤特异性生长因子\", \"content\": \"筛查早期肿瘤\"}]', '[{\"title\": \"泌尿系彩色多普勒超声检查\", \"content\": \"双肾、肾盂、输尿管、膀胱壁、[前列腺（男）]\"}, {\"title\": \"肝胆胰脾彩色多普勒超声检查\", \"content\": \"肝胆胰脾彩色多普勒超声检查\"}, {\"title\": \"数字化摄影（指CR/DR)\", \"content\": \"心、肺、膈等\"}, {\"title\": \"超声骨密度检测\", \"content\": \"超声仪检查骨量情况，无骨质疏松、骨量减少\"}, {\"title\": \"心电图\", \"content\": \"检查心脏有否器官功能性病变，如：窦性心动过速、过缓、不齐以及各种心脏病的筛查\"}]', '[{\"title\": \"肿物标记物（男）\", \"content\": \" 男：甲胎蛋白(AFP)测定 ；癌胚抗原(CEA)测定 ;游离前列腺特异性抗原(FPSA)测定 ；总前列腺特异性抗原(TPSA)测定 ；糖类抗原CA-199测定\"}]', '[{\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(左)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(右)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裂隙灯检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"眼底检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"色觉检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"色盲#色弱#正常\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"身高\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"体重\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"血压\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心肝脾肺\", \"name\": \"内科检查\", \"type\": \"录入\", \"place\": \"内科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"动脉硬化检测\", \"name\": \"动脉硬化检查\", \"type\": \"录入\", \"place\": \"动脉硬化检测室\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"淋巴结\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"甲状腺\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"脊柱四肢\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"鼻\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"耳朵\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"咽喉\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"听力\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"正常#偏弱#弱#听力障碍\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙齿\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#龋齿#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙周\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#牙周炎#牙结石#牙周病#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"A1101\", \"item\": \"心电图(十二导联)\", \"name\": \"心电图检查\", \"type\": \"导入\", \"place\": \"心电图室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1001\", \"item\": \"血常规检查\", \"name\": \"血常规检查\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1002\", \"item\": \"空腹血糖(FBG)\", \"name\": \"空腹血糖\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1003\", \"item\": \"前列腺特异性抗原(PSA)\", \"name\": \"前列腺特异性抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1004\", \"item\": \"碱性磷酸酶(ALP)\", \"name\": \"碱性磷酸酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1005\", \"item\": \"肾功能3项\", \"name\": \"肾功能3项\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1006\", \"item\": \"糖类抗原(CA199)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1007\", \"item\": \"糖类抗原(CA153)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1008\", \"item\": \"糖类抗原(CA125)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1009\", \"item\": \"丙氨酸氨基转氨酶(ALT)\", \"name\": \"丙氨酸氨基转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1010\", \"item\": \"白蛋白\", \"name\": \"白蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1011\", \"item\": \"总胆红素(TBil)\", \"name\": \"总胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1012\", \"item\": \"直接胆红素(DBIL)\", \"name\": \"直接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1013\", \"item\": \"间接胆红素(IBIL)\", \"name\": \"间接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1014\", \"item\": \"球蛋白\", \"name\": \"球蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1015\", \"item\": \"总蛋白(TP)\", \"name\": \"总蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1016\", \"item\": \"谷氨酰转肽酶(GGT)\", \"name\": \"谷氨酰转肽酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1017\", \"item\": \"谷草转氨酶（AST）\", \"name\": \"谷草转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1018\", \"item\": \"总胆固醇(TC)\", \"name\": \"总胆固醇(TC)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1019\", \"item\": \"甘油三脂（TG）\", \"name\": \"甘油三脂（TG）\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1020\", \"item\": \"高密度脂蛋白(HDL)\", \"name\": \"高密度脂蛋白(HDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1021\", \"item\": \"低密度脂蛋白(LDL)\", \"name\": \"低密度脂蛋白(LDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1022\", \"item\": \"甲胎蛋白定量(AFP)\", \"name\": \"甲胎蛋白定量(AFP)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1023\", \"item\": \"癌胚抗原定量(CEA)\", \"name\": \"癌胚抗原定量(CEA)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"N1001\", \"item\": \"尿常规\", \"name\": \"尿常规\", \"type\": \"导入\", \"place\": \"尿常规室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"男\", \"code\": \"C1001\", \"item\": \"彩超（前列腺）\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1002\", \"item\": \"彩超(膀胱及输尿管)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1003\", \"item\": \"彩超(肝胆脾胰肾)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"骨密度检测\", \"name\": \"骨密度检测\", \"type\": \"录入\", \"place\": \"骨密度检查室\\t\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"两肺\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心脏\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"纵隔\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"膈\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"胸膜\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"无\", \"item\": \"妇科常规\", \"name\": \"妇科常规\", \"type\": \"录入\", \"place\": \"妇科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"B1201\", \"item\": \"白带常规\", \"name\": \"白带常规\", \"type\": \"导入\", \"place\": \"妇科\", \"value\": \"\", \"template\": \"模板2\"}]', 'front/goods/3510fb377af44dc3a2320e7bfa81e8f1.jpg', 2249.00, 2142.00, 0, '父母体检', '[\"中老年\", \"女性\", \"男性\"]', 1, 1, 1, '99C64407FCA0D2DE192C9179FC70316E', '2023-06-06 12:21:44', '2023-06-06 12:20:59');
INSERT INTO `tb_goods` VALUES (2, '114GWMN00', '新粉红佳人体检套餐', '「感恩季到检钜惠」关注妇科炎症、宫颈病变、乳腺疾病、卵巢肿瘤等疾病筛查', '[{\"title\": \"耳鼻喉科\", \"content\": \"外耳道 鼓膜 鼻中隔 鼻甲 鼻道 咽喉\"}, {\"title\": \"妇科（非经期，尿排净，已婚查）\", \"content\": \"1、白带常规 2、外阴 阴道 宫颈 子宫 双侧输卵管 双侧卵巢 3、妇科液基薄层细胞学检查与诊断 TCT 宫颈炎症和癌前病变检测\"}, {\"title\": \"人乳头瘤病毒分型检测 HPV\", \"content\": \"人乳头瘤病毒分型检测 HPV\"}, {\"title\": \"口腔科\", \"content\": \"唇 舌 腭 牙齿 牙周 粘膜\"}, {\"title\": \"内科\", \"content\": \"血压 心率 心律 心脏杂音 心界 肺脏 肝脏 脾脏 肠鸣音 神经系统\"}, {\"title\": \"外科\", \"content\": \"身高 体重 甲状腺 脊柱 四肢关节 浅表淋巴结 肛诊\"}, {\"title\": \"眼科\", \"content\": \"（裂隙灯）视力 色觉 眼睑 结膜 巩膜 角膜 泪器 晶状体 玻璃体 眼底 眼压\"}, {\"title\": \"中医经络检测\", \"content\": \"中医经络检测\"}, {\"title\": \"中医经络会诊\", \"content\": \" 中医经络会诊\"}, {\"title\": \"体质辨识（赠送）\", \"content\": \"计算机模拟诊断，焦虑自评量表测评，抑郁自评量表测评\"}]', '[{\"title\": \"便潜血\", \"content\": \"直肠肿物筛查\"}, {\"title\": \"生化检查（20）\", \"content\": \" 谷丙转氨酶 谷草转氨酶 总蛋白 白蛋白 总胆红素 碱性磷酸酶 转肽酶 胆汁酸,尿素氮 血肌酐 尿酸 ,甘油三酯，总胆固醇，高密度脂蛋白，低密度脂蛋白,乳酸脱氢酶 羟丁酸脱氢酶 肌酸激酶 肌酸激酶同工酶\"}, {\"title\": \"传染病监测\", \"content\": \"甲肝病毒监测 乙肝病毒监测 丙肝病毒监测等\"}, {\"title\": \"甲状腺功能及抗体\", \"content\": \"总三碘甲腺原氨酸 总甲状腺素 游离三碘甲腺原氨酸 游离甲状腺素 促甲状腺激素\"}, {\"title\": \" 尿常规10项 尿沉渣检查\", \"content\": \"尿蛋白 尿糖 尿比重 尿酮体 尿胆红脂 尿胆元 亚硝酸盐 酸碱度 红细胞 白细胞等\"}, {\"title\": \"胃三项\", \"content\": \" 幽门螺杆菌分型检测\"}, {\"title\": \"甲胎蛋白（AFP）\", \"content\": \"诊断早期结肠癌和直肠癌的特异性标志物。癌胚抗原升高常见于大肠癌、胰腺癌、胃癌、乳腺癌、甲状腺髓样癌、肝癌以及卵巢癌等恶性肿瘤当中。但是，吸烟、妊娠期、结肠炎、胰腺炎、肝硬化等良性疾病当中也可以出现癌胚抗原的升高。\"}, {\"title\": \"血清CA19-9\", \"content\": \"血清CA19-9\"}, {\"title\": \" 血清骨胶素CYFRA21-1\", \"content\": \"血清骨胶素CYFRA21-1\"}, {\"title\": \"血清CA724\", \"content\": \"血清CA724\"}, {\"title\": \" 血清CA125（女性）\", \"content\": \" 血清CA125（女性）\"}, {\"title\": \"血清CA153（女性）\", \"content\": \"血清CA153（女性）\"}, {\"title\": \"NSE\", \"content\": \" NSE\"}, {\"title\": \" 肿瘤特异性生长因子TSGF\", \"content\": \" 肿瘤特异性生长因子TSGF\"}]', '[{\"title\": \"乳腺彩超\", \"content\": \" 已未婚均做（男女）\"}, {\"title\": \"甲状腺彩超\", \"content\": \" 男女均做\"}, {\"title\": \"颈动脉彩超\", \"content\": \" 男女均做\"}, {\"title\": \"盆腔超声\", \"content\": \"女：子宫 双侧输卵管 双侧卵巢（已未婚均做）已婚：阴式，未婚：憋尿\"}, {\"title\": \"超声心动\", \"content\": \"心脏结构\"}, {\"title\": \"腹部彩超（空腹）\", \"content\": \"肝 胆 胰 脾 （男女均做）\"}, {\"title\": \"脑血流图\", \"content\": \"脑血管血流情况\"}, {\"title\": \"骨密度\", \"content\": \" 骨质疏松情况\"}, {\"title\": \"胸部CT三维\", \"content\": \" 心、肺、横隔\"}, {\"title\": \"心电图\", \"content\": \"心脏传导、供血等情况\"}]', '[{\"title\": \" 糖尿病筛查\", \"content\": \" 血糖 糖化白蛋白\"}, {\"title\": \"泌尿系(膀胱充盈）\", \"content\": \"女： 双肾 输尿管 膀胱\"}]', '[{\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(左)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(右)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裂隙灯检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"眼底检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"色觉检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"色盲#色弱#正常\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"身高\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"体重\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"血压\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心肝脾肺\", \"name\": \"内科检查\", \"type\": \"录入\", \"place\": \"内科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"动脉硬化检测\", \"name\": \"动脉硬化检查\", \"type\": \"录入\", \"place\": \"动脉硬化检测室\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"淋巴结\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"甲状腺\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"脊柱四肢\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"鼻\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"耳朵\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"咽喉\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"听力\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"正常#偏弱#弱#听力障碍\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙齿\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#龋齿#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙周\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#牙周炎#牙结石#牙周病#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"A1101\", \"item\": \"心电图(十二导联)\", \"name\": \"心电图检查\", \"type\": \"导入\", \"place\": \"心电图室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1001\", \"item\": \"血常规检查\", \"name\": \"血常规检查\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1002\", \"item\": \"空腹血糖(FBG)\", \"name\": \"空腹血糖\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1003\", \"item\": \"前列腺特异性抗原(PSA)\", \"name\": \"前列腺特异性抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1004\", \"item\": \"碱性磷酸酶(ALP)\", \"name\": \"碱性磷酸酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1005\", \"item\": \"肾功能3项\", \"name\": \"肾功能3项\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1006\", \"item\": \"糖类抗原(CA199)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1007\", \"item\": \"糖类抗原(CA153)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1008\", \"item\": \"糖类抗原(CA125)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1009\", \"item\": \"丙氨酸氨基转氨酶(ALT)\", \"name\": \"丙氨酸氨基转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1010\", \"item\": \"白蛋白\", \"name\": \"白蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1011\", \"item\": \"总胆红素(TBil)\", \"name\": \"总胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1012\", \"item\": \"直接胆红素(DBIL)\", \"name\": \"直接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1013\", \"item\": \"间接胆红素(IBIL)\", \"name\": \"间接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1014\", \"item\": \"球蛋白\", \"name\": \"球蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1015\", \"item\": \"总蛋白(TP)\", \"name\": \"总蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1016\", \"item\": \"谷氨酰转肽酶(GGT)\", \"name\": \"谷氨酰转肽酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1017\", \"item\": \"谷草转氨酶（AST）\", \"name\": \"谷草转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1018\", \"item\": \"总胆固醇(TC)\", \"name\": \"总胆固醇(TC)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1019\", \"item\": \"甘油三脂（TG）\", \"name\": \"甘油三脂（TG）\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1020\", \"item\": \"高密度脂蛋白(HDL)\", \"name\": \"高密度脂蛋白(HDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1021\", \"item\": \"低密度脂蛋白(LDL)\", \"name\": \"低密度脂蛋白(LDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1022\", \"item\": \"甲胎蛋白定量(AFP)\", \"name\": \"甲胎蛋白定量(AFP)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1023\", \"item\": \"癌胚抗原定量(CEA)\", \"name\": \"癌胚抗原定量(CEA)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"N1001\", \"item\": \"尿常规\", \"name\": \"尿常规\", \"type\": \"导入\", \"place\": \"尿常规室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"男\", \"code\": \"C1001\", \"item\": \"彩超（前列腺）\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1002\", \"item\": \"彩超(膀胱及输尿管)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1003\", \"item\": \"彩超(肝胆脾胰肾)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"骨密度检测\", \"name\": \"骨密度检测\", \"type\": \"录入\", \"place\": \"骨密度检查室\\t\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"两肺\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心脏\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"纵隔\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"膈\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"胸膜\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"无\", \"item\": \"妇科常规\", \"name\": \"妇科常规\", \"type\": \"录入\", \"place\": \"妇科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"B1201\", \"item\": \"白带常规\", \"name\": \"白带常规\", \"type\": \"导入\", \"place\": \"妇科\", \"value\": \"\", \"template\": \"模板2\"}]', 'front/goods/bd93c20072b74f40bb336d1dbce26018.jpg', 2611.00, 2488.00, 0, '中青年体检', '[\"女性\", \"白领精英\"]', 1, 2, 1, 'AF299C4C90761B0C37227142175B79B1', '2023-06-06 12:21:45', '2023-06-06 12:20:59');
INSERT INTO `tb_goods` VALUES (3, '115GWMN00', '新亚健康高级体检套餐', '「感恩季到检钜惠」适用人群：青中年商务白领、职场人群、针对经常坐着上班的人群', '[{\"title\": \"内科\", \"content\": \"身高、体重、BMI、血压、询问病史等\"}, {\"title\": \"外科\", \"content\": \"甲状腺、皮肤、淋巴结、乳腺、肛诊等\"}, {\"title\": \"眼科\", \"content\": \" 视力、外眼检查、色觉、裂隙灯检查、彩色眼底照相（不含胶片费）、非接触性眼压（进口机器）\"}]', '[{\"title\": \" 粪便常规（外观及镜检）\", \"content\": \"了解有无寄生虫病及肠道炎症\"}, {\"title\": \"便潜血检查\", \"content\": \" 早期发现消化道疾病，如溃疡、炎症、肿瘤等\"}, {\"title\": \" 红细胞沉降率（ESR）\", \"content\": \"炎症、结核、风湿活动期、心梗一周内、恶性肿瘤等均可升高\"}, {\"title\": \"肝功能11项\", \"content\": \"丙氨酸氨基转移酶（ALT）、天冬氨酸氨基转移酶（AST）、总蛋白定量（TP）、白蛋白定量（ALB）、球蛋白、球/白蛋白对比、总胆红素（TBIL 、直接胆红素（DBIL）、r-谷氨酰转肽酶（GGT）、碱性磷酸酶（ALP）、乳酸脱氢酶（LD）；了解蛋白质代谢、肝脏功能情况，是否有肝功能损害及损伤的程度、胆道梗阻及肝间质病变等\"}, {\"title\": \" 尿常规10项+尿沉渣（镜检）\", \"content\": \"了解尿路有无感染、结石等，了解有无尿蛋白、尿糖等\"}, {\"title\": \"肾功能及电解质\", \"content\": \" 尿酸（UA）、肌苷（CRE）、尿素氮（BUN）、血钠Na、血钾K、血氯CL、血钙Cａ、血磷P、血镁Mg、二氧化碳CO2；主要用于肾功能及电解质平衡的评价\"}, {\"title\": \"糖化血红蛋白（HbA1c）\", \"content\": \"了解近期血糖情况（1-3月的血糖平均值）,用于诊断糖尿病和评估血糖控制情况\"}, {\"title\": \"血糖（GLU）\", \"content\": \" 了解血糖情况\"}, {\"title\": \" 同型半胱氨酸（HCY）\", \"content\": \"对心脑血管疾病的危险度及预后进行评估\"}, {\"title\": \" 铁三项检测（Fe、TIBC、Fet）\", \"content\": \"括有血清铁 (Fe)、总铁结合力 (TIBC)、铁饱和度IS (Fe/TIBC) 、铁蛋白(Fet)。铁是人体的必需元素，具有生理活性的铁除以血浆的转铁蛋白形式存在外，主要以血红蛋白的形式存在，因此，缺铁会引起贫血。其明显增高或减低与急慢性炎症、血液系统、消化性系统、内分泌系统、免疫系统、肿瘤等疾病相关\"}, {\"title\": \"胃功能四项\", \"content\": \"G-17、PGⅠ、PGⅡ、PGⅠ/PGⅡ;用于反映胃体、胃窦粘膜的整体分泌状态\"}, {\"title\": \"全血细胞分析\", \"content\": \"了解有无感染、贫血、血液系统疾病等\"}, {\"title\": \"血脂7项\", \"content\": \"总胆固醇（CHO）、甘油三酯（TG）、高密度脂蛋白胆固醇 HDL-C、低密度脂蛋白胆固醇（LDL-C） 、小而密低密度脂蛋白胆固醇(sdLDL-C)、载脂蛋白A1(ApoA1)、载脂蛋白B（ApoB）；用于了解体内血脂情况，对动脉粥样硬化性疾病危险程度进行预测以及营养学评估\"}, {\"title\": \"碳-13呼气试验\", \"content\": \"检测胃内有无幽门螺旋杆菌感染，对反复慢性胃炎、溃疡、癌前病变有辅助诊治意义\"}, {\"title\": \"甲胎蛋白 (AFP)\", \"content\": \"主要用于肝癌早期筛查\"}, {\"title\": \"癌胚抗原(CEA)\", \"content\": \"主要用于肿瘤早期筛查\"}]', '[{\"title\": \" 泌尿系彩超（憋尿）\", \"content\": \"检查双肾及前列腺的大小、回声、有无结石及占位性病变，双侧输尿管有无扩张及占位性病变，膀胱壁及腔内情况\"}, {\"title\": \" 肝、胆、胰、脾（空腹）彩超\", \"content\": \"了解肝、胆、胰、脾各脏器的大小、结构是否正常，有无结石、炎症、肿物等病变\"}, {\"title\": \"颈动脉彩超\", \"content\": \"了解有无颈动脉硬化、斑块形成、管腔狭窄、痉挛等，评估动脉血管粥样硬化危险程度及辅助预测心脑血管疾病\"}, {\"title\": \"甲状腺彩超\", \"content\": \"了解甲状腺有无肿物、结节、肿大、炎症等\"}, {\"title\": \"动脉检测\", \"content\": \"肢体动脉检查+测量；了解肢体周围动脉硬化及血流情况，是评价动脉硬化程度的有效指标\"}, {\"title\": \"骨密度检查\", \"content\": \" 了解有无骨质减少、骨质疏松，预测骨折危险性\"}, {\"title\": \"DR胸部检查（不含胶片费）\", \"content\": \"了解双肺、心脏、纵隔情况\"}, {\"title\": \"人体成分检测\", \"content\": \"根据您目前的体重、体型、肌肉、骨骼等检测值评估个人身体状态，进行综合评价\"}, {\"title\": \"心电图（多导联）\", \"content\": \"通过了解心肌电活动，对冠心病及其他心脏病的诊断有提示作用，并可观察其转归，是诊断心律失常的基本手段\"}]', '[{\"title\": \" CTM-PEM检查\", \"content\": \"了解中医体质类型和心理健康程度\"}]', '[{\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(左)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(右)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裂隙灯检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"眼底检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"色觉检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"色盲#色弱#正常\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"身高\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"体重\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"血压\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心肝脾肺\", \"name\": \"内科检查\", \"type\": \"录入\", \"place\": \"内科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"动脉硬化检测\", \"name\": \"动脉硬化检查\", \"type\": \"录入\", \"place\": \"动脉硬化检测室\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"淋巴结\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"甲状腺\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"脊柱四肢\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"鼻\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"耳朵\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"咽喉\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"听力\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"正常#偏弱#弱#听力障碍\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙齿\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#龋齿#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙周\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#牙周炎#牙结石#牙周病#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"A1101\", \"item\": \"心电图(十二导联)\", \"name\": \"心电图检查\", \"type\": \"导入\", \"place\": \"心电图室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1001\", \"item\": \"血常规检查\", \"name\": \"血常规检查\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1002\", \"item\": \"空腹血糖(FBG)\", \"name\": \"空腹血糖\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1003\", \"item\": \"前列腺特异性抗原(PSA)\", \"name\": \"前列腺特异性抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1004\", \"item\": \"碱性磷酸酶(ALP)\", \"name\": \"碱性磷酸酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1005\", \"item\": \"肾功能3项\", \"name\": \"肾功能3项\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1006\", \"item\": \"糖类抗原(CA199)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1007\", \"item\": \"糖类抗原(CA153)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1008\", \"item\": \"糖类抗原(CA125)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1009\", \"item\": \"丙氨酸氨基转氨酶(ALT)\", \"name\": \"丙氨酸氨基转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1010\", \"item\": \"白蛋白\", \"name\": \"白蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1011\", \"item\": \"总胆红素(TBil)\", \"name\": \"总胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1012\", \"item\": \"直接胆红素(DBIL)\", \"name\": \"直接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1013\", \"item\": \"间接胆红素(IBIL)\", \"name\": \"间接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1014\", \"item\": \"球蛋白\", \"name\": \"球蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1015\", \"item\": \"总蛋白(TP)\", \"name\": \"总蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1016\", \"item\": \"谷氨酰转肽酶(GGT)\", \"name\": \"谷氨酰转肽酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1017\", \"item\": \"谷草转氨酶（AST）\", \"name\": \"谷草转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1018\", \"item\": \"总胆固醇(TC)\", \"name\": \"总胆固醇(TC)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1019\", \"item\": \"甘油三脂（TG）\", \"name\": \"甘油三脂（TG）\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1020\", \"item\": \"高密度脂蛋白(HDL)\", \"name\": \"高密度脂蛋白(HDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1021\", \"item\": \"低密度脂蛋白(LDL)\", \"name\": \"低密度脂蛋白(LDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1022\", \"item\": \"甲胎蛋白定量(AFP)\", \"name\": \"甲胎蛋白定量(AFP)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1023\", \"item\": \"癌胚抗原定量(CEA)\", \"name\": \"癌胚抗原定量(CEA)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"N1001\", \"item\": \"尿常规\", \"name\": \"尿常规\", \"type\": \"导入\", \"place\": \"尿常规室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"男\", \"code\": \"C1001\", \"item\": \"彩超（前列腺）\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1002\", \"item\": \"彩超(膀胱及输尿管)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1003\", \"item\": \"彩超(肝胆脾胰肾)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"骨密度检测\", \"name\": \"骨密度检测\", \"type\": \"录入\", \"place\": \"骨密度检查室\\t\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"两肺\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心脏\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"纵隔\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"膈\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"胸膜\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"无\", \"item\": \"妇科常规\", \"name\": \"妇科常规\", \"type\": \"录入\", \"place\": \"妇科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"B1201\", \"item\": \"白带常规\", \"name\": \"白带常规\", \"type\": \"导入\", \"place\": \"妇科\", \"value\": \"\", \"template\": \"模板2\"}]', 'front/goods/a7d14a952d7c47a186ae4f411865053f.jpg', 3005.00, 2862.00, 4, '职场白领', '[\"男性\", \"女性\", \"白领精英\"]', 1, NULL, 1, '81FCC286401953B53F0E0A00BAE0488E', '2023-06-06 12:21:46', '2023-06-06 12:20:59');
INSERT INTO `tb_goods` VALUES (4, '116GWMN00', '新感恩敬老高级体检套餐', '「感恩季到检钜惠」适合人群：适用于中、老年人及血管疾病人群 （参加第二件0元活动 需加入购物车后数量选2）', '[{\"title\": \"内科查体\", \"content\": \"问诊（个人史、家族史、生活方式等）及一般状况、心肺、腹部、神经系统检查\"}, {\"title\": \"外科查体\", \"content\": \"皮肤、浅表淋巴结、头、颈部（甲状腺）、胸部（乳房）、脊柱、四肢关节、直肠指诊、男性外生殖器\"}, {\"title\": \"眼科\", \"content\": \"视功能检测、裂隙灯检查、小瞳孔眼底检查\"}, {\"title\": \"一般项目\", \"content\": \"身高、体重、BMI、血压、脉搏\"}]', '[{\"title\": \"便常规+潜血\", \"content\": \"用于对消化道疾病隐形出血如溃疡、肿瘤等检查\"}, {\"title\": \"离子组合\", \"content\": \"钙、磷、镁、铁\"}, {\"title\": \"电解质\", \"content\": \"钾、钠、氯、二氧化碳结合力\"}, {\"title\": \"乙肝五项\", \"content\": \"HBsAg、HBsAb、HBeAg、HBeAb、HBcAb\"}, {\"title\": \"丙肝抗体\", \"content\": \"检查是否有丙肝抗体\"}, {\"title\": \"甲功五项\", \"content\": \"FT3、FT4、T3、T4、TSH\"}, {\"title\": \"抗甲状腺自身抗体三项\", \"content\": \" ANTI-TG、ANTI-TPO、ANTR-TSHR\"}, {\"title\": \"尿液分析\", \"content\": \"尿常规10项+镜检\"}, {\"title\": \"凝血四项\", \"content\": \"反映血液的凝血功能及黏稠度\"}, {\"title\": \"尿肾功能\", \"content\": \" MALB、β2-MG、NAG更能主要反映肾脏的早期病变\"}, {\"title\": \"生化全项\", \"content\": \"生化检查内容包括肝功能、肾功能、血脂、血糖、心肌酶、电解质等\"}, {\"title\": \"糖化血红蛋白检测\", \"content\": \"监测血糖代谢，对糖尿病的早期诊断具有重要的意义，也是心脑血管疾病诊断及风险评估重要指标\"}, {\"title\": \"性激素六项\", \"content\": \" 促卵泡激素(FSH)/促黄体生成素(LH)/催乳素(PRL)/孕酮(PROG)/睾酮(TEST)/雌二醇(E2)\"}, {\"title\": \"血液分析\", \"content\": \"血常规23项（红细胞、白细胞、血小板系统）\"}, {\"title\": \"血型鉴定组合\", \"content\": \"ABO、RH(D)\"}, {\"title\": \"男肿标全项\", \"content\": \"FPSA、TPSA、FPSA/TPSA、NSE、CYFRA21-1（细胞角蛋白）、TG-M、AFP、CA125、CA19-9、CA72-4、CEA、Pro-CRP、SCC\"}]', '[{\"title\": \" 腹部彩超（肝、胆、脾、胰）\", \"content\": \"肝脏、胆囊、胰腺、脾脏的超声检查。\"}, {\"title\": \"男性泌尿系超声\", \"content\": \"双肾、双侧输尿管、膀胱、前列腺、双侧精囊腺\"}, {\"title\": \"颈动脉彩超\", \"content\": \" 人体中最早发生动脉硬化，也是硬化斑块危害最大，最严重的部位，可直接引起脑梗死，心梗等\"}, {\"title\": \"心脏彩超\", \"content\": \" 通过彩色超声检查心脏形态、结构及血流情况及功能，判定是否有各种先心病，心肌病，心瓣膜病，心包积液，心脏肿瘤等 \"}, {\"title\": \"甲状腺彩超\", \"content\": \"通过彩色超声仪检查甲状腺的形态、大小及血流情况、 判定是否有甲状腺肿大、结节、囊肿、肿瘤等 \"}, {\"title\": \"动脉硬化检测\", \"content\": \"肢体动脉检查+测量\"}, {\"title\": \"骨密度检测\", \"content\": \"判断骨质疏松、预测骨折风险,尤其适用于中老年人\"}, {\"title\": \"经颅多普勒\", \"content\": \" 大脑中动脉、椎动脉、基底动脉的血流速度\"}, {\"title\": \"肺部CT\", \"content\": \" 反映肺脏的形态，发现异常状态，如病灶大小，形态，部位，数目及其有无病灶内出血、坏死等。从病灶边沿情况可以了解其浸润性情况\"}, {\"title\": \"颈椎正侧斜位片\", \"content\": \"检查颈椎结构是否正常，有无异常病变\"}, {\"title\": \"腰椎正侧斜位片\", \"content\": \"可筛查腰椎有无骨质病变，关节关系是否正常，椎间孔大小有无异常，椎体有无异常等腰椎病变\"}, {\"title\": \"多导联心电图\", \"content\": \" 检测心脏电生理异常\"}, {\"title\": \"贫血三项\", \"content\": \"贫血的筛查\"}]', '[{\"title\": \"自身抗体五项\", \"content\": \"ANA、ANTI-AMA、ANTI-SMA、ANTI-PCA、ANTI-LKM\"}, {\"title\": \"胰岛功能两项\", \"content\": \"胰岛素、血清C肽\"}, {\"title\": \"糖化白蛋白\", \"content\": \"反映过去2-3周平均血糖水平的一项指标，在治疗效果的确认以及临床用药量的调整方面有重要指导作用\"}, {\"title\": \"心血管风险因子\", \"content\": \"检查是否存在心脑血管疾病\"}, {\"title\": \"C13幽门螺旋杆菌呼气检测\", \"content\": \"判断有无幽门螺杆菌的感染\"}, {\"title\": \"胃癌早期预警\", \"content\": \"胃蛋白酶原I（PGI）；胃蛋白酶原II（PGII）\"}]', '[{\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(左)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(右)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裂隙灯检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"眼底检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"色觉检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"色盲#色弱#正常\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"身高\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"体重\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"血压\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心肝脾肺\", \"name\": \"内科检查\", \"type\": \"录入\", \"place\": \"内科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"动脉硬化检测\", \"name\": \"动脉硬化检查\", \"type\": \"录入\", \"place\": \"动脉硬化检测室\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"淋巴结\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"甲状腺\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"脊柱四肢\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"鼻\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"耳朵\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"咽喉\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"听力\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"正常#偏弱#弱#听力障碍\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙齿\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#龋齿#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙周\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#牙周炎#牙结石#牙周病#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"A1101\", \"item\": \"心电图(十二导联)\", \"name\": \"心电图检查\", \"type\": \"导入\", \"place\": \"心电图室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1001\", \"item\": \"血常规检查\", \"name\": \"血常规检查\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1002\", \"item\": \"空腹血糖(FBG)\", \"name\": \"空腹血糖\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1003\", \"item\": \"前列腺特异性抗原(PSA)\", \"name\": \"前列腺特异性抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1004\", \"item\": \"碱性磷酸酶(ALP)\", \"name\": \"碱性磷酸酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1005\", \"item\": \"肾功能3项\", \"name\": \"肾功能3项\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1006\", \"item\": \"糖类抗原(CA199)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1007\", \"item\": \"糖类抗原(CA153)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1008\", \"item\": \"糖类抗原(CA125)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1009\", \"item\": \"丙氨酸氨基转氨酶(ALT)\", \"name\": \"丙氨酸氨基转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1010\", \"item\": \"白蛋白\", \"name\": \"白蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1011\", \"item\": \"总胆红素(TBil)\", \"name\": \"总胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1012\", \"item\": \"直接胆红素(DBIL)\", \"name\": \"直接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1013\", \"item\": \"间接胆红素(IBIL)\", \"name\": \"间接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1014\", \"item\": \"球蛋白\", \"name\": \"球蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1015\", \"item\": \"总蛋白(TP)\", \"name\": \"总蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1016\", \"item\": \"谷氨酰转肽酶(GGT)\", \"name\": \"谷氨酰转肽酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1017\", \"item\": \"谷草转氨酶（AST）\", \"name\": \"谷草转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1018\", \"item\": \"总胆固醇(TC)\", \"name\": \"总胆固醇(TC)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1019\", \"item\": \"甘油三脂（TG）\", \"name\": \"甘油三脂（TG）\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1020\", \"item\": \"高密度脂蛋白(HDL)\", \"name\": \"高密度脂蛋白(HDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1021\", \"item\": \"低密度脂蛋白(LDL)\", \"name\": \"低密度脂蛋白(LDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1022\", \"item\": \"甲胎蛋白定量(AFP)\", \"name\": \"甲胎蛋白定量(AFP)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1023\", \"item\": \"癌胚抗原定量(CEA)\", \"name\": \"癌胚抗原定量(CEA)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"N1001\", \"item\": \"尿常规\", \"name\": \"尿常规\", \"type\": \"导入\", \"place\": \"尿常规室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"男\", \"code\": \"C1001\", \"item\": \"彩超（前列腺）\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1002\", \"item\": \"彩超(膀胱及输尿管)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1003\", \"item\": \"彩超(肝胆脾胰肾)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"骨密度检测\", \"name\": \"骨密度检测\", \"type\": \"录入\", \"place\": \"骨密度检查室\\t\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"两肺\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心脏\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"纵隔\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"膈\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"胸膜\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"无\", \"item\": \"妇科常规\", \"name\": \"妇科常规\", \"type\": \"录入\", \"place\": \"妇科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"B1201\", \"item\": \"白带常规\", \"name\": \"白带常规\", \"type\": \"导入\", \"place\": \"妇科\", \"value\": \"\", \"template\": \"模板2\"}]', 'front/goods/93c2d55b4ee54ef6943608e22118aae4.jpg', 3546.00, 3377.00, 23, '父母体检', '[\"男性\", \"女性\", \"中老年\"]', 1, NULL, 1, '91B3E37A7ED7F11CE7C65F8CEF70F182', '2023-06-06 12:21:47', '2023-06-06 12:20:59');
INSERT INTO `tb_goods` VALUES (5, '111GWMN00', '新孝心父母体检套餐', '「感恩季到检钜惠」适合人群：适用于中、老年人及血管疾病人群【需加入购物车数量选2哦】', '[{\"title\": \"内科\", \"content\": \"视诊、触诊、叩诊、听诊等物理诊断检查\"}, {\"title\": \"外科\", \"content\": \" 触摸淋巴结、甲状腺、脊柱、淋巴结发现临床疾病\"}]', '[{\"title\": \"大便潜血检查\", \"content\": \"排查肠道出血性疾病\"}, {\"title\": \"肝功4项\", \"content\": \"谷丙转氨酶 谷草转氨酶 碱性磷酸酶 谷氨酰转肽酶\"}, {\"title\": \"骨钙素-N肽\", \"content\": \"定量检测、特异性最高，反映了骨代谢现症情况\"}, {\"title\": \"淋巴细胞亚群\", \"content\": \"检测机体细胞免疫功能的重要指标，且对某些疾病(如自身免疫病、免疫缺陷病、恶性肿瘤、血液病、变态反应性疾病等)的辅助诊断\"}, {\"title\": \"尿常规\", \"content\": \"初步检查泌尿系统疾病\"}, {\"title\": \"肾功3项\", \"content\": \"尿素、肌酐、尿酸\"}, {\"title\": \"糖化血红蛋白检测\", \"content\": \"反映抽血前120天内的平均血糖水平，用于辅助诊断、评价治疗效果\"}, {\"title\": \"空腹血糖\", \"content\": \" 检查血糖，筛查糖尿病\"}, {\"title\": \"同型半胱氨酸\", \"content\": \"冠脉硬化和心梗危险指标\"}, {\"title\": \"血小板功能分析\", \"content\": \"脑梗、心梗等心脑血管疾病的高风险筛查手段\"}, {\"title\": \"血常规\", \"content\": \"检查血液系统各项常规指标\"}, {\"title\": \"血脂4项\", \"content\": \"甘油三酯 总胆固醇 高密度脂蛋白 低密度脂蛋白 检测体内血脂成分，血脂升高易患冠心病、动脉硬化等疾病\"}, {\"title\": \"甲胎蛋白\", \"content\": \"甲胎蛋白\"}, {\"title\": \"癌胚抗原\", \"content\": \"癌胚抗原\"}, {\"title\": \"前列腺特异性抗原（PSA）\", \"content\": \"前列腺特异性抗原（PSA）\"}]', '[{\"title\": \"彩超检查\", \"content\": \"甲状腺彩超 颈动脉彩超 肝脏、胆囊、胰腺、脾脏、肾脏、膀胱 前列腺彩超\"}, {\"title\": \"动脉硬化检测\", \"content\": \"诊断外周动脉是否存在粥样硬化及其严重程度\"}, {\"title\": \"骨密度\", \"content\": \"是骨骼强度的的重要指标\"}, {\"title\": \" 胸部平扫CT\", \"content\": \"发现肺部早期恶性肿瘤、肺部炎症\"}, {\"title\": \"人体成分分析\", \"content\": \"测定体脂肪含量、水含量、肌肉含量，指示身体健康状况\"}, {\"title\": \"12导心电图\", \"content\": \"初步筛查心律失常及心肌缺血\"}, {\"title\": \"眼底照相\", \"content\": \"检查视网膜（包括视乳头、黄斑、视网膜血管及除黄斑以外的视网膜）\"}, {\"title\": \"乳腺超声\", \"content\": \"乳腺超声\"}, {\"title\": \"子宫附件超声\", \"content\": \"子宫附件超声\"}]', '[{\"title\": \"脂蛋白相关磷脂酶A2\", \"content\": \"是血管炎症反应的特异性标志物，能动态反映动脉粥样硬化的严重程度，对预防心脑血管突发事件具有重要意义。检测结果升高标明动脉硬化斑块不稳定容易破裂，可能会诱发严重的心脑血管疾病。用于心脑血管疾病风险的早期预测\"}, {\"title\": \"膀胱肿瘤抗原检测\", \"content\": \"膀胱泌尿系统肿瘤筛查\"}]', '[{\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(左)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(右)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裂隙灯检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"眼底检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"色觉检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"色盲#色弱#正常\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"身高\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"体重\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"血压\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心肝脾肺\", \"name\": \"内科检查\", \"type\": \"录入\", \"place\": \"内科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"动脉硬化检测\", \"name\": \"动脉硬化检查\", \"type\": \"录入\", \"place\": \"动脉硬化检测室\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"淋巴结\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"甲状腺\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"脊柱四肢\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"鼻\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"耳朵\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"咽喉\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"听力\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"正常#偏弱#弱#听力障碍\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙齿\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#龋齿#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙周\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#牙周炎#牙结石#牙周病#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"A1101\", \"item\": \"心电图(十二导联)\", \"name\": \"心电图检查\", \"type\": \"导入\", \"place\": \"心电图室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1001\", \"item\": \"血常规检查\", \"name\": \"血常规检查\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1002\", \"item\": \"空腹血糖(FBG)\", \"name\": \"空腹血糖\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1003\", \"item\": \"前列腺特异性抗原(PSA)\", \"name\": \"前列腺特异性抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1004\", \"item\": \"碱性磷酸酶(ALP)\", \"name\": \"碱性磷酸酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1005\", \"item\": \"肾功能3项\", \"name\": \"肾功能3项\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1006\", \"item\": \"糖类抗原(CA199)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1007\", \"item\": \"糖类抗原(CA153)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1008\", \"item\": \"糖类抗原(CA125)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1009\", \"item\": \"丙氨酸氨基转氨酶(ALT)\", \"name\": \"丙氨酸氨基转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1010\", \"item\": \"白蛋白\", \"name\": \"白蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1011\", \"item\": \"总胆红素(TBil)\", \"name\": \"总胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1012\", \"item\": \"直接胆红素(DBIL)\", \"name\": \"直接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1013\", \"item\": \"间接胆红素(IBIL)\", \"name\": \"间接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1014\", \"item\": \"球蛋白\", \"name\": \"球蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1015\", \"item\": \"总蛋白(TP)\", \"name\": \"总蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1016\", \"item\": \"谷氨酰转肽酶(GGT)\", \"name\": \"谷氨酰转肽酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1017\", \"item\": \"谷草转氨酶（AST）\", \"name\": \"谷草转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1018\", \"item\": \"总胆固醇(TC)\", \"name\": \"总胆固醇(TC)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1019\", \"item\": \"甘油三脂（TG）\", \"name\": \"甘油三脂（TG）\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1020\", \"item\": \"高密度脂蛋白(HDL)\", \"name\": \"高密度脂蛋白(HDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1021\", \"item\": \"低密度脂蛋白(LDL)\", \"name\": \"低密度脂蛋白(LDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1022\", \"item\": \"甲胎蛋白定量(AFP)\", \"name\": \"甲胎蛋白定量(AFP)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1023\", \"item\": \"癌胚抗原定量(CEA)\", \"name\": \"癌胚抗原定量(CEA)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"N1001\", \"item\": \"尿常规\", \"name\": \"尿常规\", \"type\": \"导入\", \"place\": \"尿常规室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"男\", \"code\": \"C1001\", \"item\": \"彩超（前列腺）\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1002\", \"item\": \"彩超(膀胱及输尿管)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1003\", \"item\": \"彩超(肝胆脾胰肾)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"骨密度检测\", \"name\": \"骨密度检测\", \"type\": \"录入\", \"place\": \"骨密度检查室\\t\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"两肺\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心脏\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"纵隔\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"膈\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"胸膜\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"无\", \"item\": \"妇科常规\", \"name\": \"妇科常规\", \"type\": \"录入\", \"place\": \"妇科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"B1201\", \"item\": \"白带常规\", \"name\": \"白带常规\", \"type\": \"导入\", \"place\": \"妇科\", \"value\": \"\", \"template\": \"模板2\"}]', 'front/goods/fadbcfc08aca42d2896ea227ea5656f7.jpg', 2305.00, 2195.00, 0, '父母体检', '[\"中老年\", \"女性\", \"男性\"]', 2, NULL, 1, 'D7C8E2580DB645F441784AC2E735CEB2', '2023-06-06 12:21:49', '2023-06-06 12:20:59');
INSERT INTO `tb_goods` VALUES (6, '112GWMN00', '新精选男士体检套餐', '「感恩季到检钜惠」适合中青年人群、职场白领人士、针对经常坐着上班的人群', '[{\"title\": \"耳鼻喉科\", \"content\": \"耳、鼻、鼻窦、咽喉\"}, {\"title\": \"口腔科\", \"content\": \" 齿、龈、唇、颊、腭、舌\"}, {\"title\": \"内科、外科\", \"content\": \" 内科、外科\"}, {\"title\": \"眼科\", \"content\": \"裂隙灯、外眼、眼底、眼压、视力、辨色力\"}]', '[{\"title\": \"风湿组合\", \"content\": \" C-反应蛋白、抗“O”、血沉、类风湿因子\"}, {\"title\": \"肝功十项\", \"content\": \"可了解肝细胞有否损害，检查肝胆相关疾病等\"}, {\"title\": \"甲功5项\", \"content\": \"甲功五项（TSH/T4/T3/FT4/FT3)\"}, {\"title\": \"尿液分析\", \"content\": \"可提示有无泌尿系统疾患可能，如肾炎、肾盂肾炎、膀胱炎、尿道炎、泌尿系统结石、肾及膀胱肿瘤、糖尿病等\"}, {\"title\": \"肾功能3项\", \"content\": \"判断是否痛风及肾功能损害程度\"}, {\"title\": \"血糖\", \"content\": \"空腹血糖是最常用的检测指标，反应胰岛β细胞基础胰岛素的分泌功能。增高见于糖尿病、甲亢；降低见于饥饿、营养不良、糖代谢异常、严重肝病等\"}, {\"title\": \"心肌酶4项\", \"content\": \"检查心脏功能，检查是否有心肌缺血或者是心肌坏死\"}, {\"title\": \"血常规\", \"content\": \"通过血液分析可发现有无贫血、细菌感染、病毒感染、白血病等系统疾病\"}, {\"title\": \"血脂四项\", \"content\": \"检查有无高脂血症,评估动脉硬化和冠心病的重要指标 \"}, {\"title\": \"幽门螺旋杆菌抗体检测\", \"content\": \"幽门螺旋杆菌(Hp)胃内感染, 1994年国际癌肿瘤研究机构和世界卫生组织将(Hp)列为第I类致癌因子\"}, {\"title\": \" 鳞状上皮细胞癌相关抗原\", \"content\": \"有助于鳞状上皮细胞起源癌的诊断和监测，如阴道癌、宫颈癌、肺癌、食管癌等\"}, {\"title\": \"糖类抗原CA-199\", \"content\": \"胰腺癌、胃癌、结直肠癌等辅助诊断。有些良性的病变例如胰腺炎等，也可能会导致糖类抗原199升高\"}, {\"title\": \"前列腺抗原2项\", \"content\": \"TPSA、FPSA\"}]', '[{\"title\": \"颈动脉彩超\", \"content\": \" 颈动脉彩超\"}, {\"title\": \" 甲状腺超声检查\", \"content\": \"是对甲状腺肿瘤的检查\"}, {\"title\": \" 肝、胆、胰、脾、双肾彩超\", \"content\": \" 检查相应脏器大小、形态、结构、声像，了解有无各种良恶性病变，可筛查脂肪肝、结石、囊肿、肿瘤、血管瘤、肝硬化等病变，是腹部脏器必查的项目\"}, {\"title\": \"前列腺彩超\", \"content\": \"彩色超声检查前列腺有无增生、肥大、囊肿、钙化等\"}, {\"title\": \"心电图\", \"content\": \"检查心脏有否器官功能性病变，如：窦性心动过速、过缓、不齐以及各种心脏病的筛查\"}]', '[{\"title\": \"肿瘤2项\", \"content\": \"甲胎蛋白（AFP）：肝癌较有价值的辅助诊断指标。癌胚抗原（CEA）：存在远处转移的结直肠癌90％CEA增高，早期患者CEA升高者低于10％。胰腺、胃、肝、肺、乳腺、甲状腺、大肠及卵巢等恶性肿瘤时也可升高，CEA属广谱“肿瘤标志物”\"}]', '[{\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(左)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(右)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裂隙灯检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"眼底检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"色觉检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"色盲#色弱#正常\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"身高\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"体重\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"血压\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心肝脾肺\", \"name\": \"内科检查\", \"type\": \"录入\", \"place\": \"内科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"动脉硬化检测\", \"name\": \"动脉硬化检查\", \"type\": \"录入\", \"place\": \"动脉硬化检测室\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"淋巴结\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"甲状腺\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"脊柱四肢\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"鼻\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"耳朵\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"咽喉\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"听力\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"正常#偏弱#弱#听力障碍\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙齿\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#龋齿#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙周\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#牙周炎#牙结石#牙周病#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"A1101\", \"item\": \"心电图(十二导联)\", \"name\": \"心电图检查\", \"type\": \"导入\", \"place\": \"心电图室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1001\", \"item\": \"血常规检查\", \"name\": \"血常规检查\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1002\", \"item\": \"空腹血糖(FBG)\", \"name\": \"空腹血糖\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1003\", \"item\": \"前列腺特异性抗原(PSA)\", \"name\": \"前列腺特异性抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1004\", \"item\": \"碱性磷酸酶(ALP)\", \"name\": \"碱性磷酸酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1005\", \"item\": \"肾功能3项\", \"name\": \"肾功能3项\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1006\", \"item\": \"糖类抗原(CA199)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1007\", \"item\": \"糖类抗原(CA153)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1008\", \"item\": \"糖类抗原(CA125)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1009\", \"item\": \"丙氨酸氨基转氨酶(ALT)\", \"name\": \"丙氨酸氨基转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1010\", \"item\": \"白蛋白\", \"name\": \"白蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1011\", \"item\": \"总胆红素(TBil)\", \"name\": \"总胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1012\", \"item\": \"直接胆红素(DBIL)\", \"name\": \"直接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1013\", \"item\": \"间接胆红素(IBIL)\", \"name\": \"间接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1014\", \"item\": \"球蛋白\", \"name\": \"球蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1015\", \"item\": \"总蛋白(TP)\", \"name\": \"总蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1016\", \"item\": \"谷氨酰转肽酶(GGT)\", \"name\": \"谷氨酰转肽酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1017\", \"item\": \"谷草转氨酶（AST）\", \"name\": \"谷草转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1018\", \"item\": \"总胆固醇(TC)\", \"name\": \"总胆固醇(TC)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1019\", \"item\": \"甘油三脂（TG）\", \"name\": \"甘油三脂（TG）\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1020\", \"item\": \"高密度脂蛋白(HDL)\", \"name\": \"高密度脂蛋白(HDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1021\", \"item\": \"低密度脂蛋白(LDL)\", \"name\": \"低密度脂蛋白(LDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1022\", \"item\": \"甲胎蛋白定量(AFP)\", \"name\": \"甲胎蛋白定量(AFP)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1023\", \"item\": \"癌胚抗原定量(CEA)\", \"name\": \"癌胚抗原定量(CEA)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"N1001\", \"item\": \"尿常规\", \"name\": \"尿常规\", \"type\": \"导入\", \"place\": \"尿常规室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"男\", \"code\": \"C1001\", \"item\": \"彩超（前列腺）\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1002\", \"item\": \"彩超(膀胱及输尿管)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1003\", \"item\": \"彩超(肝胆脾胰肾)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"骨密度检测\", \"name\": \"骨密度检测\", \"type\": \"录入\", \"place\": \"骨密度检查室\\t\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"两肺\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心脏\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"纵隔\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"膈\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"胸膜\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"无\", \"item\": \"妇科常规\", \"name\": \"妇科常规\", \"type\": \"录入\", \"place\": \"妇科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"B1201\", \"item\": \"白带常规\", \"name\": \"白带常规\", \"type\": \"导入\", \"place\": \"妇科\", \"value\": \"\", \"template\": \"模板2\"}]', 'front/goods/4615505384b840de88af021c9f1dbd02.jpg', 3005.00, 2862.00, 0, '职场白领', '[\"男性\"]', 2, NULL, 1, 'B8E9A878DD2DCC829B633A2AE7678F58', '2023-06-06 12:21:50', '2023-06-06 12:20:59');
INSERT INTO `tb_goods` VALUES (7, '113GWMN00', '新精选女士体检套餐', '「感恩季到检钜惠」女性专项，重点关注妇科炎症、宫颈病变、乳腺疾病、卵巢', '[{\"title\": \"耳鼻喉科\", \"content\": \"耳鼻喉科：耳、鼻、喉检查\"}, {\"title\": \"HPV病毒筛查\", \"content\": \" HPV病毒筛查\"}, {\"title\": \"宫颈防癌超薄涂片\", \"content\": \" 宫颈防癌超薄涂片\"}, {\"title\": \"妇科内诊\", \"content\": \"通过检查发现外阴皮肤有无异常；阴道有无出血、溃疡；宫颈有无充血和异常分泌物等；子宫有无异常；双侧附件有无肿块及压痛等\"}, {\"title\": \"内科\", \"content\": \"心、肺、肝、脾、神经系统检查\"}, {\"title\": \"肛门指诊\", \"content\": \"经肛门进行直肠癌筛查 \"}, {\"title\": \"外科\", \"content\": \"皮肤、浅表淋巴结、甲状腺、头颈、乳腺、脊柱、四肢、肛门、外生殖器、病史采集\"}, {\"title\": \"眼科\", \"content\": \"视力、辨色力、眼压、眼底照相、裂隙灯\"}, {\"title\": \"基本检查\", \"content\": \"身高体重血压检查极其比值，初步评定是否营养不良或营养过剩，检测是否有高血压以及低血压\"}, {\"title\": \"中医体检\", \"content\": \"中医体质辨识、中医经络辨识、中医健康调养咨询\"}]', '[{\"title\": \"大便常规+OB\", \"content\": \" 有无肠道感染、潜血 \"}, {\"title\": \"肝功能\", \"content\": \"肝功能（谷丙转氨酶、谷草转氨酶、谷氨酰转肽酶、总胆红素、直接胆红素、间接胆红素）\"}, {\"title\": \"甲状腺功能3项\", \"content\": \"是反应甲状腺功能状态的主要指标，用于甲状腺功能亢进或甲状腺功能减低等筛查\"}, {\"title\": \"尿常规+流式\", \"content\": \"有无泌尿系疾病、糖尿病、急慢性肾病\"}, {\"title\": \"肾功能\", \"content\": \"肾功能（肌酐、尿素氮、尿酸、β2-微球蛋白、血钙）\"}, {\"title\": \"血糖\", \"content\": \"血糖\"}, {\"title\": \"糖化血红蛋白检测\", \"content\": \"监测血糖代谢，对糖尿病的早期诊断具有重要的意义，也是心脑血管疾病诊断及风险评估重要指标\"}, {\"title\": \"同型半胱氨酸\", \"content\": \"冠脉硬化和心梗危险指标\"}, {\"title\": \"血常规\", \"content\": \"全血细胞分析，有无感染、贫血、凝血异常 \"}, {\"title\": \"血脂\", \"content\": \"血脂（总胆固醇、低密度脂蛋白胆固醇、高密度脂蛋白胆固醇、甘油三酯）\"}, {\"title\": \"幽门螺杆菌\", \"content\": \"经便探查幽门螺杆菌抗原\"}, {\"title\": \"防癌筛查女\", \"content\": \"癌胚抗原CEA、甲胎蛋白AFP、女性肿瘤：乳腺癌CA153、卵巢癌CA125\"}]', '[{\"title\": \"乳腺彩超\", \"content\": \"乳腺增生和结节情况\"}, {\"title\": \"腹部彩超\", \"content\": \"肝、胆、胰、脾彩超\"}, {\"title\": \"经腹部妇科彩超\", \"content\": \"经腹部妇科：子宫附件\"}, {\"title\": \"颈动脉+椎动脉彩超\", \"content\": \"颈部血管形态及斑块\"}, {\"title\": \"甲状腺彩超\", \"content\": \"甲状腺形态及血流改变\"}, {\"title\": \"泌尿系彩超\", \"content\": \"肾脏、膀胱、输尿管\"}, {\"title\": \"胸部正侧位\", \"content\": \"多方位检查心脏、两肺、纵隔、膈、胸膜，更好地发现和判断有无炎症、肿瘤等\"}, {\"title\": \"心电图\", \"content\": \"心脏电传导功能 \"}]', NULL, '[{\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(左)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(右)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裂隙灯检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"眼底检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"色觉检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"色盲#色弱#正常\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"身高\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"体重\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"血压\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心肝脾肺\", \"name\": \"内科检查\", \"type\": \"录入\", \"place\": \"内科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"动脉硬化检测\", \"name\": \"动脉硬化检查\", \"type\": \"录入\", \"place\": \"动脉硬化检测室\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"淋巴结\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"甲状腺\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"脊柱四肢\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"鼻\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"耳朵\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"咽喉\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"听力\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"正常#偏弱#弱#听力障碍\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙齿\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#龋齿#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙周\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#牙周炎#牙结石#牙周病#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"A1101\", \"item\": \"心电图(十二导联)\", \"name\": \"心电图检查\", \"type\": \"导入\", \"place\": \"心电图室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1001\", \"item\": \"血常规检查\", \"name\": \"血常规检查\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1002\", \"item\": \"空腹血糖(FBG)\", \"name\": \"空腹血糖\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1003\", \"item\": \"前列腺特异性抗原(PSA)\", \"name\": \"前列腺特异性抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1004\", \"item\": \"碱性磷酸酶(ALP)\", \"name\": \"碱性磷酸酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1005\", \"item\": \"肾功能3项\", \"name\": \"肾功能3项\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1006\", \"item\": \"糖类抗原(CA199)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1007\", \"item\": \"糖类抗原(CA153)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1008\", \"item\": \"糖类抗原(CA125)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1009\", \"item\": \"丙氨酸氨基转氨酶(ALT)\", \"name\": \"丙氨酸氨基转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1010\", \"item\": \"白蛋白\", \"name\": \"白蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1011\", \"item\": \"总胆红素(TBil)\", \"name\": \"总胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1012\", \"item\": \"直接胆红素(DBIL)\", \"name\": \"直接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1013\", \"item\": \"间接胆红素(IBIL)\", \"name\": \"间接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1014\", \"item\": \"球蛋白\", \"name\": \"球蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1015\", \"item\": \"总蛋白(TP)\", \"name\": \"总蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1016\", \"item\": \"谷氨酰转肽酶(GGT)\", \"name\": \"谷氨酰转肽酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1017\", \"item\": \"谷草转氨酶（AST）\", \"name\": \"谷草转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1018\", \"item\": \"总胆固醇(TC)\", \"name\": \"总胆固醇(TC)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1019\", \"item\": \"甘油三脂（TG）\", \"name\": \"甘油三脂（TG）\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1020\", \"item\": \"高密度脂蛋白(HDL)\", \"name\": \"高密度脂蛋白(HDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1021\", \"item\": \"低密度脂蛋白(LDL)\", \"name\": \"低密度脂蛋白(LDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1022\", \"item\": \"甲胎蛋白定量(AFP)\", \"name\": \"甲胎蛋白定量(AFP)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1023\", \"item\": \"癌胚抗原定量(CEA)\", \"name\": \"癌胚抗原定量(CEA)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"N1001\", \"item\": \"尿常规\", \"name\": \"尿常规\", \"type\": \"导入\", \"place\": \"尿常规室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"男\", \"code\": \"C1001\", \"item\": \"彩超（前列腺）\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1002\", \"item\": \"彩超(膀胱及输尿管)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1003\", \"item\": \"彩超(肝胆脾胰肾)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"骨密度检测\", \"name\": \"骨密度检测\", \"type\": \"录入\", \"place\": \"骨密度检查室\\t\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"两肺\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心脏\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"纵隔\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"膈\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"胸膜\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"无\", \"item\": \"妇科常规\", \"name\": \"妇科常规\", \"type\": \"录入\", \"place\": \"妇科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"B1201\", \"item\": \"白带常规\", \"name\": \"白带常规\", \"type\": \"导入\", \"place\": \"妇科\", \"value\": \"\", \"template\": \"模板2\"}]', 'front/goods/4a3d89d6c7e748caa6f6d1e897035291.jpg', 3302.00, 3467.00, 0, '职场白领', '[\"女性\", \"白领精英\"]', 2, NULL, 1, '3B7559857F6D870090716F2C8A20B4CA', '2023-06-06 12:21:51', '2023-06-06 12:20:59');
INSERT INTO `tb_goods` VALUES (8, '110GWMN00', '新孝心甄选体检套餐', '「感恩季到检钜惠」适合人群：适用于中、老年人及血管疾病人群【需加入购物车数量选2哦】', '[{\"title\": \"内科\", \"content\": \"通过视、触、叩、听检查心、肺、肝、脾等重要脏器的基本状况，发现常见疾病的相关征兆，或初步排除常见疾病。\"}, {\"title\": \"口腔科\", \"content\": \"口腔常规检查，全面了解口腔健康状况，及时发现口腔科常见疾病\"}, {\"title\": \"外科\", \"content\": \"通过体格检查，检查皮肤、甲状腺、脊柱四肢、前列腺、外生殖器等重要脏器基本情况，发现常见外科疾病的相关征兆，或初步排除外科常见疾病\"}, {\"title\": \"妇科常规\", \"content\": \"通过妇科触诊及仪器检查方法，发现常见妇科疾病的相关征兆，或初步排除妇科常见疾病\"}, {\"title\": \"眼科检查\", \"content\": \"视力；辨色力；眼底检查；裂隙灯检查；眼压\"}]', '[{\"title\": \"白带常规\", \"content\": \"用于检查阴道内有无滴虫、念珠菌，同时还可确定阴道清洁度，是筛查阴道炎的有效手段\"}, {\"title\": \"宫颈超薄细胞检测（TCT）\", \"content\": \"即液基薄层细胞学检查。是筛查宫颈早期病变较先进的检测方法，同时还能发现部分癌前病变，微生物感染如霉菌、滴虫、病毒、衣原体、人乳头瘤病毒等\"}, {\"title\": \"肝功八项\", \"content\": \"了解肝脏功能情况的基本检查 。（谷丙转氨酶(ALT),谷草转氨酶(AST),总胆红素(TBIL),直接胆红素(DBIL),间接胆红素(IBIL),球蛋白(GLB),白蛋白(ALB),前白蛋白(PAB））\"}, {\"title\": \"甲状腺功能五项\", \"content\": \"了解甲状腺功能，辅助筛查有无甲亢、甲减等疾病\"}, {\"title\": \"尿常规\", \"content\": \"流式尿沉渣全自动分析加尿10项；筛查泌尿系感染及肾脏疾病\"}, {\"title\": \"肾功三项\", \"content\": \"尿素(UREA),肌酐(CREA),尿酸(URIC)了解肾脏功能情况\"}, {\"title\": \"糖化血红蛋白\", \"content\": \"了解2-3个月内血糖控制情况，辅助糖尿病早期筛查\"}, {\"title\": \"胃功能组合\", \"content\": \"胃蛋白酶原Ⅰ,胃蛋白酶原Ⅱ,人胃蛋白酶原I/II,胃泌素-17；协助诊断胃溃疡和萎缩，预测胃癌风险\"}, {\"title\": \"血常规\", \"content\": \"全血细胞五分类及网织红细胞；是筛查血液疾病和感染性疾病最基本的检查\"}, {\"title\": \"血脂六项\", \"content\": \"了解血脂，反应体内脂代谢情况，是评估心、脑血管风险因素的指标\"}, {\"title\": \"癌胚抗原\", \"content\": \"辅助筛查结肠癌、直肠癌、肺癌等\"}, {\"title\": \"甲胎蛋白\", \"content\": \"辅助筛查原发性肝癌\"}]', '[{\"title\": \"动脉硬化检测\", \"content\": \"检测四肢动脉硬化程度\"}, {\"title\": \"骨质疏松评估\", \"content\": \"25-羟基维生素D检测 、超声骨密度检查\"}, {\"title\": \"电脑多导联心电图\", \"content\": \"辅助筛查心脏类疾病\"}, {\"title\": \"前列腺超声\", \"content\": \"了解肾、输尿管、膀胱、前列腺结构病变(需要憋尿）\"}, {\"title\": \"甲状腺彩色多普勒超声扫描\", \"content\": \"了解甲状腺结构和病变\"}, {\"title\": \"双侧颈动脉彩色多普勒超声\", \"content\": \"了解中型动脉粥样硬化情况，预测冠脉粥样硬化风险\"}]', NULL, '[{\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(左)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(右)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裂隙灯检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"眼底检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"色觉检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"色盲#色弱#正常\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"身高\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"体重\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"血压\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心肝脾肺\", \"name\": \"内科检查\", \"type\": \"录入\", \"place\": \"内科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"动脉硬化检测\", \"name\": \"动脉硬化检查\", \"type\": \"录入\", \"place\": \"动脉硬化检测室\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"淋巴结\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"甲状腺\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"脊柱四肢\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"鼻\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"耳朵\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"咽喉\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"听力\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"正常#偏弱#弱#听力障碍\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙齿\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#龋齿#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙周\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#牙周炎#牙结石#牙周病#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"A1101\", \"item\": \"心电图(十二导联)\", \"name\": \"心电图检查\", \"type\": \"导入\", \"place\": \"心电图室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1001\", \"item\": \"血常规检查\", \"name\": \"血常规检查\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1002\", \"item\": \"空腹血糖(FBG)\", \"name\": \"空腹血糖\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1003\", \"item\": \"前列腺特异性抗原(PSA)\", \"name\": \"前列腺特异性抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1004\", \"item\": \"碱性磷酸酶(ALP)\", \"name\": \"碱性磷酸酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1005\", \"item\": \"肾功能3项\", \"name\": \"肾功能3项\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1006\", \"item\": \"糖类抗原(CA199)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1007\", \"item\": \"糖类抗原(CA153)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1008\", \"item\": \"糖类抗原(CA125)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1009\", \"item\": \"丙氨酸氨基转氨酶(ALT)\", \"name\": \"丙氨酸氨基转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1010\", \"item\": \"白蛋白\", \"name\": \"白蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1011\", \"item\": \"总胆红素(TBil)\", \"name\": \"总胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1012\", \"item\": \"直接胆红素(DBIL)\", \"name\": \"直接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1013\", \"item\": \"间接胆红素(IBIL)\", \"name\": \"间接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1014\", \"item\": \"球蛋白\", \"name\": \"球蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1015\", \"item\": \"总蛋白(TP)\", \"name\": \"总蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1016\", \"item\": \"谷氨酰转肽酶(GGT)\", \"name\": \"谷氨酰转肽酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1017\", \"item\": \"谷草转氨酶（AST）\", \"name\": \"谷草转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1018\", \"item\": \"总胆固醇(TC)\", \"name\": \"总胆固醇(TC)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1019\", \"item\": \"甘油三脂（TG）\", \"name\": \"甘油三脂（TG）\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1020\", \"item\": \"高密度脂蛋白(HDL)\", \"name\": \"高密度脂蛋白(HDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1021\", \"item\": \"低密度脂蛋白(LDL)\", \"name\": \"低密度脂蛋白(LDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1022\", \"item\": \"甲胎蛋白定量(AFP)\", \"name\": \"甲胎蛋白定量(AFP)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1023\", \"item\": \"癌胚抗原定量(CEA)\", \"name\": \"癌胚抗原定量(CEA)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"N1001\", \"item\": \"尿常规\", \"name\": \"尿常规\", \"type\": \"导入\", \"place\": \"尿常规室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"男\", \"code\": \"C1001\", \"item\": \"彩超（前列腺）\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1002\", \"item\": \"彩超(膀胱及输尿管)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1003\", \"item\": \"彩超(肝胆脾胰肾)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"骨密度检测\", \"name\": \"骨密度检测\", \"type\": \"录入\", \"place\": \"骨密度检查室\\t\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"两肺\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心脏\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"纵隔\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"膈\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"胸膜\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"无\", \"item\": \"妇科常规\", \"name\": \"妇科常规\", \"type\": \"录入\", \"place\": \"妇科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"B1201\", \"item\": \"白带常规\", \"name\": \"白带常规\", \"type\": \"导入\", \"place\": \"妇科\", \"value\": \"\", \"template\": \"模板2\"}]', 'front/goods/99e79494a71849d0831948fd8586de26.jpg', 3750.00, 3938.00, 0, '父母体检', '[\"中老年\", \"男性\", \"女性\"]', 2, NULL, 1, 'BA782D9872BA4C1D19EA0A5A338E271D', '2023-06-06 12:21:54', '2023-06-06 12:20:59');
INSERT INTO `tb_goods` VALUES (9, '109GWMN00', '婚前体检套餐', '婚前疾病筛查，本套餐仅出具体检报告，不出具婚前检查医学证明', '[{\"title\": \"白带常规(女性项目)\", \"content\": \"对阴道分泌物检查，判断有无霉菌、滴虫感染及阴道炎\"}, {\"title\": \"妇科检查(女性项目)\", \"content\": \") 了解外阴、阴道、宫颈、宫体、双侧附件等常见疾病和肿瘤\"}, {\"title\": \" 内科常规检查\", \"content\": \"通过对人体视、触、叩、听等物理方法，了解心、肺、肝、脾等内脏情，可筛查先心病、气管炎、及肝脾肿大等\"}, {\"title\": \"外科常规检查\", \"content\": \"常规皮肤、脊椎、四肢、甲状腺、乳房、浅表淋巴结等检查，发现外科病症与体征\"}, {\"title\": \"基础检查\", \"content\": \"身高、体重、体重指数、血压、心率是生命体征的基本信息，汇总分析身体健康状况的基础指标\"}]', '[{\"title\": \"肝功能三项\", \"content\": \"含谷草转氨酶、谷丙转氨酶、总胆红素三项检查，了解肝细胞新陈代谢，判断肝细胞损伤程度\"}, {\"title\": \"梅毒抗体检测\", \"content\": \"判断是否感染梅毒螺旋体\"}, {\"title\": \"艾滋病病毒检测\", \"content\": \"判断是否感染艾滋病病毒\"}, {\"title\": \"结核杆菌抗体\", \"content\": \"辅助诊断肺结核及其他部位结核\"}, {\"title\": \"丙肝抗体\", \"content\": \"作为HCV感染的标志，辅助诊断丙肝\"}, {\"title\": \"乙肝五项\", \"content\": \"是检查乙肝病毒及抗体的常用方法，辅助诊断乙型肝炎，指导乙肝疫苗的接种\"}, {\"title\": \"尿常规11项\", \"content\": \"检测尿液的成分、酸碱度、清洁度等，了解有无泌尿系感染，泌尿系肿瘤，急、慢性肾炎，糖尿病及其它全身性疾病等\"}, {\"title\": \"肾功能三项\", \"content\": \"含肾功二项、血尿酸，判断肾功能损害程度、有无痛风等\"}, {\"title\": \"空腹血糖\", \"content\": \"有无糖尿病及是否低血糖，筛检糖尿病最基本的方法\"}, {\"title\": \"血常规24项\", \"content\": \"检测血红蛋白、血细胞的数量和比例，了解有无贫血、感染及血液系统疾病\"}, {\"title\": \"血脂二项\", \"content\": \"含总胆固醇、甘油三酯，可判断高血脂症、肥胖综合症等\"}]', '[{\"title\": \" 盆腔彩超(女性项目)\", \"content\": \"检查子宫、附件、膀胱及周围组织，发现相关疾病及病变\"}, {\"title\": \"前列腺彩超(男性项目)\", \"content\": \"检查前列腺的炎性、囊性、增生、实性病变，发现有无良、恶性肿瘤\"}, {\"title\": \"腹部彩超\", \"content\": \"含肝、胆、胰、脾、双肾检查，诊断脂相关疾病及病变\"}, {\"title\": \"胸部透视\", \"content\": \"了解心脏、肺、胸膜、纵膈、膈肌、肋骨等发育及病理改变，及时发现炎症、结核、肿瘤等\"}, {\"title\": \"12导联心电图\", \"content\": \"描记心脏释放的生物电，了解心脏工作状态，是体检必查项目\"}]', '[{\"title\": \"红外线乳透(女性项目)\", \"content\": \"通过红外线透视，了解乳腺发育，对乳腺增生、肿块进行筛查\"}]', '[{\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(左)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(右)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裂隙灯检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"眼底检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"色觉检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"色盲#色弱#正常\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"身高\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"体重\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"血压\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心肝脾肺\", \"name\": \"内科检查\", \"type\": \"录入\", \"place\": \"内科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"动脉硬化检测\", \"name\": \"动脉硬化检查\", \"type\": \"录入\", \"place\": \"动脉硬化检测室\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"淋巴结\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"甲状腺\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"脊柱四肢\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"鼻\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"耳朵\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"咽喉\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"听力\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"正常#偏弱#弱#听力障碍\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙齿\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#龋齿#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙周\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#牙周炎#牙结石#牙周病#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"A1101\", \"item\": \"心电图(十二导联)\", \"name\": \"心电图检查\", \"type\": \"导入\", \"place\": \"心电图室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1001\", \"item\": \"血常规检查\", \"name\": \"血常规检查\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1002\", \"item\": \"空腹血糖(FBG)\", \"name\": \"空腹血糖\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1003\", \"item\": \"前列腺特异性抗原(PSA)\", \"name\": \"前列腺特异性抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1004\", \"item\": \"碱性磷酸酶(ALP)\", \"name\": \"碱性磷酸酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1005\", \"item\": \"肾功能3项\", \"name\": \"肾功能3项\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1006\", \"item\": \"糖类抗原(CA199)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1007\", \"item\": \"糖类抗原(CA153)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1008\", \"item\": \"糖类抗原(CA125)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1009\", \"item\": \"丙氨酸氨基转氨酶(ALT)\", \"name\": \"丙氨酸氨基转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1010\", \"item\": \"白蛋白\", \"name\": \"白蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1011\", \"item\": \"总胆红素(TBil)\", \"name\": \"总胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1012\", \"item\": \"直接胆红素(DBIL)\", \"name\": \"直接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1013\", \"item\": \"间接胆红素(IBIL)\", \"name\": \"间接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1014\", \"item\": \"球蛋白\", \"name\": \"球蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1015\", \"item\": \"总蛋白(TP)\", \"name\": \"总蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1016\", \"item\": \"谷氨酰转肽酶(GGT)\", \"name\": \"谷氨酰转肽酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1017\", \"item\": \"谷草转氨酶（AST）\", \"name\": \"谷草转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1018\", \"item\": \"总胆固醇(TC)\", \"name\": \"总胆固醇(TC)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1019\", \"item\": \"甘油三脂（TG）\", \"name\": \"甘油三脂（TG）\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1020\", \"item\": \"高密度脂蛋白(HDL)\", \"name\": \"高密度脂蛋白(HDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1021\", \"item\": \"低密度脂蛋白(LDL)\", \"name\": \"低密度脂蛋白(LDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1022\", \"item\": \"甲胎蛋白定量(AFP)\", \"name\": \"甲胎蛋白定量(AFP)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1023\", \"item\": \"癌胚抗原定量(CEA)\", \"name\": \"癌胚抗原定量(CEA)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"N1001\", \"item\": \"尿常规\", \"name\": \"尿常规\", \"type\": \"导入\", \"place\": \"尿常规室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"男\", \"code\": \"C1001\", \"item\": \"彩超（前列腺）\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1002\", \"item\": \"彩超(膀胱及输尿管)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1003\", \"item\": \"彩超(肝胆脾胰肾)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"骨密度检测\", \"name\": \"骨密度检测\", \"type\": \"录入\", \"place\": \"骨密度检查室\\t\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"两肺\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心脏\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"纵隔\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"膈\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"胸膜\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"无\", \"item\": \"妇科常规\", \"name\": \"妇科常规\", \"type\": \"录入\", \"place\": \"妇科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"B1201\", \"item\": \"白带常规\", \"name\": \"白带常规\", \"type\": \"导入\", \"place\": \"妇科\", \"value\": \"\", \"template\": \"模板2\"}]', 'front/goods/885728b98910435abcac6807f02ddafb.jpg', 1583.00, 905.00, 0, '中青年体检', '[\"中青年\", \"未婚\", \"男性\"]', 3, NULL, 1, 'E1C58055083569AAB6E4A0F8756B4E8A', '2023-06-06 12:21:59', '2023-06-06 12:20:59');
INSERT INTO `tb_goods` VALUES (10, '101GWMN00', '熬夜党体检套餐', '熬夜党人群首选体检套餐【感恩季2022.12.20-2023.12.20期间到检享加赠或升级！】', '[{\"title\": \"耳鼻喉科\", \"content\": \"耳、鼻、鼻窦、咽喉\"}, {\"title\": \"口腔科\", \"content\": \"齿、龈、唇、颊、腭、舌\"}, {\"title\": \"内科、外科\", \"content\": \"一般检查、测血压、中医体质辨识\"}, {\"title\": \"眼科\", \"content\": \"裂隙灯、外眼、眼底、眼压、视力、辨色力\"}]', '[{\"title\": \"肝功十项\", \"content\": \"可了解肝细胞有否损害，检查肝胆相关疾病等\"}, {\"title\": \"尿液分析\", \"content\": \"可提示有无泌尿系统疾患可能，如肾炎、肾盂肾炎、膀胱炎、尿道炎、泌尿系统结石、肾及膀胱肿瘤、糖尿病等\"}, {\"title\": \"肾功能3项\", \"content\": \"判断是否痛风及肾功能损害程度\"}, {\"title\": \"血糖\", \"content\": \"空腹血糖是最常用的检测指标，反应胰岛β细胞基础胰岛素的分泌功能。增高见于糖尿病、甲亢；降低见于饥饿、营养不良、糖代谢异常、严重肝病等\"}, {\"title\": \"血常规（18项）\", \"content\": \"判定是否有感染、贫血、血液疾病等\"}, {\"title\": \"血脂四项\", \"content\": \"检查有无高脂血症,评估动脉硬化和冠心病的重要指标\"}, {\"title\": \"幽门螺旋杆菌抗体检测\", \"content\": \"幽门螺旋杆菌(Hp)胃内感染, 1994年国际癌肿瘤研究机构和世界卫生组织将(Hp)列为第I类致癌因子\"}, {\"title\": \"T-PSA（男）\", \"content\": \"主要用于男性前列腺癌以及其它前列腺疾病的早期诊断\"}]', '[{\"title\": \"乳腺彩超（女）\", \"content\": \" 筛查乳腺小叶增生、肿瘤等\"}, {\"title\": \"妇科彩超（女）\", \"content\": \"妇科彩超\"}, {\"title\": \" 甲状腺彩超\", \"content\": \"甲状腺彩超\"}, {\"title\": \"肝、胆、胰、脾、双肾彩超\", \"content\": \"检查相应脏器大小、形态、结构、声像，了解有无各种良恶性病变，可筛查脂肪肝、结石、囊肿、肿瘤、血管瘤、肝硬化等病变，是腹部脏器必查的项目\"}, {\"title\": \"前列腺彩超（男）\", \"content\": \"彩色超声检查前列腺有无增生、肥大、囊肿、钙化等\"}, {\"title\": \"胸部彩超\", \"content\": \"检查心脏、两肺、纵隔、膈、胸膜，判断有无炎症、肿瘤等\"}, {\"title\": \"心电图\", \"content\": \"检查心脏有否器官功能性病变，如：窦性心动过速、过缓、不齐以及各种心脏病的筛查\"}, {\"title\": \"肿瘤2项\", \"content\": \"甲胎蛋白（AFP）：肝癌较有价值的辅助诊断指标。癌胚抗原（CEA）：存在远处转移的结直肠癌90％CEA增高，早期患者CEA升高者低于10％。胰腺、胃、肝、肺、乳腺、甲状腺、大肠及卵巢等恶性肿瘤时也可升高，CEA属广谱“肿瘤标志物”\"}]', NULL, '[{\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(左)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(右)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裂隙灯检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"眼底检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"色觉检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"色盲#色弱#正常\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"身高\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"体重\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"血压\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心肝脾肺\", \"name\": \"内科检查\", \"type\": \"录入\", \"place\": \"内科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"动脉硬化检测\", \"name\": \"动脉硬化检查\", \"type\": \"录入\", \"place\": \"动脉硬化检测室\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"淋巴结\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"甲状腺\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"脊柱四肢\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"鼻\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"耳朵\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"咽喉\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"听力\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"正常#偏弱#弱#听力障碍\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙齿\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#龋齿#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙周\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#牙周炎#牙结石#牙周病#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"A1101\", \"item\": \"心电图(十二导联)\", \"name\": \"心电图检查\", \"type\": \"导入\", \"place\": \"心电图室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1001\", \"item\": \"血常规检查\", \"name\": \"血常规检查\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1002\", \"item\": \"空腹血糖(FBG)\", \"name\": \"空腹血糖\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1003\", \"item\": \"前列腺特异性抗原(PSA)\", \"name\": \"前列腺特异性抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1004\", \"item\": \"碱性磷酸酶(ALP)\", \"name\": \"碱性磷酸酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1005\", \"item\": \"肾功能3项\", \"name\": \"肾功能3项\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1006\", \"item\": \"糖类抗原(CA199)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1007\", \"item\": \"糖类抗原(CA153)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1008\", \"item\": \"糖类抗原(CA125)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1009\", \"item\": \"丙氨酸氨基转氨酶(ALT)\", \"name\": \"丙氨酸氨基转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1010\", \"item\": \"白蛋白\", \"name\": \"白蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1011\", \"item\": \"总胆红素(TBil)\", \"name\": \"总胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1012\", \"item\": \"直接胆红素(DBIL)\", \"name\": \"直接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1013\", \"item\": \"间接胆红素(IBIL)\", \"name\": \"间接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1014\", \"item\": \"球蛋白\", \"name\": \"球蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1015\", \"item\": \"总蛋白(TP)\", \"name\": \"总蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1016\", \"item\": \"谷氨酰转肽酶(GGT)\", \"name\": \"谷氨酰转肽酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1017\", \"item\": \"谷草转氨酶（AST）\", \"name\": \"谷草转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1018\", \"item\": \"总胆固醇(TC)\", \"name\": \"总胆固醇(TC)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1019\", \"item\": \"甘油三脂（TG）\", \"name\": \"甘油三脂（TG）\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1020\", \"item\": \"高密度脂蛋白(HDL)\", \"name\": \"高密度脂蛋白(HDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1021\", \"item\": \"低密度脂蛋白(LDL)\", \"name\": \"低密度脂蛋白(LDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1022\", \"item\": \"甲胎蛋白定量(AFP)\", \"name\": \"甲胎蛋白定量(AFP)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1023\", \"item\": \"癌胚抗原定量(CEA)\", \"name\": \"癌胚抗原定量(CEA)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"N1001\", \"item\": \"尿常规\", \"name\": \"尿常规\", \"type\": \"导入\", \"place\": \"尿常规室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"男\", \"code\": \"C1001\", \"item\": \"彩超（前列腺）\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1002\", \"item\": \"彩超(膀胱及输尿管)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1003\", \"item\": \"彩超(肝胆脾胰肾)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"骨密度检测\", \"name\": \"骨密度检测\", \"type\": \"录入\", \"place\": \"骨密度检查室\\t\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"两肺\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心脏\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"纵隔\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"膈\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"胸膜\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"无\", \"item\": \"妇科常规\", \"name\": \"妇科常规\", \"type\": \"录入\", \"place\": \"妇科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"B1201\", \"item\": \"白带常规\", \"name\": \"白带常规\", \"type\": \"导入\", \"place\": \"妇科\", \"value\": \"\", \"template\": \"模板2\"}]', 'front/goods/0a03844155794e92b45956a795c95608.jpg', 1793.00, 1025.00, 0, '中青年体检', '[\"男性\", \"女性\", \"中青年\"]', 3, NULL, 1, '9EB6A22E86DA43D2AAE77D286A3B1FB5', '2023-06-06 12:22:02', '2023-06-06 12:20:59');
INSERT INTO `tb_goods` VALUES (11, '107GWMN00', '情侣体检套餐', '情人节专属特惠，两份仅2599元【感恩季2022.12.20-2023.4.20期间到检享加赠或升级！】', '[{\"title\": \" 五官科检查\", \"content\": \"耳、鼻、鼻咽、喉、扁桃体检查等 \"}, {\"title\": \"内科\", \"content\": \" 心、肺听诊、腹部触诊等 \"}, {\"title\": \"外科\", \"content\": \"浅表淋巴结、甲状腺、乳房、脊柱、四肢、外生殖器、前列腺、肛指等 \"}, {\"title\": \"眼科\", \"content\": \"外眼、晶体、眼底检查等 \"}, {\"title\": \"一般检查\", \"content\": \"血压 \"}, {\"title\": \"阴道分泌物检查\", \"content\": \"白带清洁度及霉菌、滴虫感染检查\"}]', '[{\"title\": \"肝功能\", \"content\": \"谷丙转氨酶、胆红素测定，提示肝胆系统疾病\"}, {\"title\": \"甲状腺功能全套\", \"content\": \"诊断有无甲状腺机能亢进或甲状腺机能低下等疾病\"}, {\"title\": \"尿常规+沉渣\", \"content\": \"了解泌尿系统代谢功能、筛查肾炎、尿路感染、尿血、糖尿病等\"}, {\"title\": \" 肾功能\", \"content\": \"肌酐、尿素氮、尿酸、痛风等诊断指标 \"}, {\"title\": \"血糖\", \"content\": \"空腹血糖测定，了解是否有低血糖、糖尿病等疾病\"}, {\"title\": \"血同型半胱氨酸\", \"content\": \"血同型半胱氨酸测定，及早发现有无心梗、脑梗的危险因素\"}, {\"title\": \"血常规\", \"content\": \"白细胞计数、红细胞计数、血红蛋白含量、血小板等检测 \"}, {\"title\": \"血粘度\", \"content\": \"血液粘稠度测定，提示脑中风、高黏滞综合征等疾病\"}, {\"title\": \"血脂检测\", \"content\": \"甘油三酯、胆固醇测定，及早发现高血压、冠心病、脂肪肝、动脉硬化、胆结石等疾病，高、低密度脂蛋白测定，是监测血管硬化的重要指标\"}, {\"title\": \"尿核基质蛋白\", \"content\": \"尿核基质蛋白测定，及早发现有无膀胱癌的危险因素\"}, {\"title\": \"前列腺\", \"content\": \"前列腺：PSA、FPSA\"}, {\"title\": \"肺部肿瘤\", \"content\": \"肺部：CY211、NSE\"}, {\"title\": \"甲胎蛋白\", \"content\": \"AFP（甲胎蛋白）\"}]', '[{\"title\": \"甲状腺B超\", \"content\": \"了解甲状腺有无结节、肿大、肿块等\"}, {\"title\": \"腹部B超\", \"content\": \"肝、胆、胰、脾、肾疾病的诊断：如脂肪肝、肝囊肿、胆囊炎、胆石症、肾结石、肾囊肿等\"}, {\"title\": \"颈动脉B超\", \"content\": \"是诊断和评估颈动脉壁病变的有效手段，可检测早期动脉内膜有无粥样病变的存在\"}, {\"title\": \"头颅核磁共振\", \"content\": \"了解脑部有无病变，如脑血管疾病、脑肿瘤、脑出血、脑水肿等疾病\"}, {\"title\": \"骨密度\", \"content\": \"骨质密度测定，及早发现有无骨质疏松\"}, {\"title\": \"低剂量肺部CT平扫\", \"content\": \"低剂量肺部CT平扫\"}, {\"title\": \"心电图\", \"content\": \"心血管系统疾病的的诊断：如有无心律失常、心肌缺血、心肌病、冠心病等 \"}, {\"title\": \"消化道肿瘤\", \"content\": \"消化道：CEA、CA199、CA724、CA50、CA242\"}, {\"title\": \"乳腺彩超\", \"content\": \"筛查乳腺小叶增生、肿瘤等\"}, {\"title\": \"子宫、双附件彩超\", \"content\": \"通过彩色超声仪器更清晰地观察子宫及附件（卵巢、输卵管）大小、形态结构及内部回声的情况，鉴别正常和异常，了解病变的性质，判别有无恶性病变，以便尽早处置。\"}]', NULL, '[{\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(左)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(右)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裂隙灯检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"眼底检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"色觉检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"色盲#色弱#正常\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"身高\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"体重\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"血压\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心肝脾肺\", \"name\": \"内科检查\", \"type\": \"录入\", \"place\": \"内科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"动脉硬化检测\", \"name\": \"动脉硬化检查\", \"type\": \"录入\", \"place\": \"动脉硬化检测室\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"淋巴结\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"甲状腺\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"脊柱四肢\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"鼻\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"耳朵\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"咽喉\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"听力\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"正常#偏弱#弱#听力障碍\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙齿\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#龋齿#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙周\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#牙周炎#牙结石#牙周病#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"A1101\", \"item\": \"心电图(十二导联)\", \"name\": \"心电图检查\", \"type\": \"导入\", \"place\": \"心电图室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1001\", \"item\": \"血常规检查\", \"name\": \"血常规检查\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1002\", \"item\": \"空腹血糖(FBG)\", \"name\": \"空腹血糖\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1003\", \"item\": \"前列腺特异性抗原(PSA)\", \"name\": \"前列腺特异性抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1004\", \"item\": \"碱性磷酸酶(ALP)\", \"name\": \"碱性磷酸酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1005\", \"item\": \"肾功能3项\", \"name\": \"肾功能3项\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1006\", \"item\": \"糖类抗原(CA199)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1007\", \"item\": \"糖类抗原(CA153)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1008\", \"item\": \"糖类抗原(CA125)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1009\", \"item\": \"丙氨酸氨基转氨酶(ALT)\", \"name\": \"丙氨酸氨基转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1010\", \"item\": \"白蛋白\", \"name\": \"白蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1011\", \"item\": \"总胆红素(TBil)\", \"name\": \"总胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1012\", \"item\": \"直接胆红素(DBIL)\", \"name\": \"直接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1013\", \"item\": \"间接胆红素(IBIL)\", \"name\": \"间接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1014\", \"item\": \"球蛋白\", \"name\": \"球蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1015\", \"item\": \"总蛋白(TP)\", \"name\": \"总蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1016\", \"item\": \"谷氨酰转肽酶(GGT)\", \"name\": \"谷氨酰转肽酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1017\", \"item\": \"谷草转氨酶（AST）\", \"name\": \"谷草转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1018\", \"item\": \"总胆固醇(TC)\", \"name\": \"总胆固醇(TC)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1019\", \"item\": \"甘油三脂（TG）\", \"name\": \"甘油三脂（TG）\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1020\", \"item\": \"高密度脂蛋白(HDL)\", \"name\": \"高密度脂蛋白(HDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1021\", \"item\": \"低密度脂蛋白(LDL)\", \"name\": \"低密度脂蛋白(LDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1022\", \"item\": \"甲胎蛋白定量(AFP)\", \"name\": \"甲胎蛋白定量(AFP)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1023\", \"item\": \"癌胚抗原定量(CEA)\", \"name\": \"癌胚抗原定量(CEA)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"N1001\", \"item\": \"尿常规\", \"name\": \"尿常规\", \"type\": \"导入\", \"place\": \"尿常规室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"男\", \"code\": \"C1001\", \"item\": \"彩超（前列腺）\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1002\", \"item\": \"彩超(膀胱及输尿管)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1003\", \"item\": \"彩超(肝胆脾胰肾)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"骨密度检测\", \"name\": \"骨密度检测\", \"type\": \"录入\", \"place\": \"骨密度检查室\\t\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"两肺\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心脏\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"纵隔\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"膈\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"胸膜\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"无\", \"item\": \"妇科常规\", \"name\": \"妇科常规\", \"type\": \"录入\", \"place\": \"妇科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"B1201\", \"item\": \"白带常规\", \"name\": \"白带常规\", \"type\": \"导入\", \"place\": \"妇科\", \"value\": \"\", \"template\": \"模板2\"}]', 'front/goods/e568212a4e564620bf4478e2ca386d60.jpg', 2854.00, 2166.00, 0, '中青年体检', '[\"中青年\", \"男性\", \"女性\"]', 3, NULL, 1, '454E10D9019FB1B499204182C5D2B7F4', '2023-06-06 12:22:03', '2023-06-06 12:20:59');
INSERT INTO `tb_goods` VALUES (12, '131GWMN00', '白领精英高级体检套餐', '适合白领精英人群，升级胸部CT，亚健康基础项目全面升级【感恩季2022.12.20-2023.12.20期间到检享加赠或升级！】', '[{\"title\": \"耳鼻喉科\", \"content\": \"耳、鼻、喉、咽等有无异常\"}, {\"title\": \"内科\", \"content\": \"检查各种心脏病、心律失常及肺部疾病，炎症，肝脾有无肿大，肾病等\"}, {\"title\": \"外科\", \"content\": \"浅表淋巴结有无肿大，甲状腺、乳腺、前列腺、肛肠有无异常\"}, {\"title\": \"眼科\", \"content\": \"检查视力是否正常，有无屈光不正、色盲等\"}, {\"title\": \"一般检查\", \"content\": \"体重是否正常，有无体重不足、超重或肥胖，有无血压异常等\"}]', '[{\"title\": \"肝功能全套\", \"content\": \"全面评价肝胆代谢及解毒功能\"}, {\"title\": \"甲功3项\", \"content\": \"FT3+FT4+TSH 用于了解甲状腺功能状态\"}, {\"title\": \"尿沉渣\", \"content\": \"泌尿系统感染及肾脏疾病的初步筛查\"}, {\"title\": \"肾功能4项\", \"content\": \"尿素氮（BUN)、肌酐（CRE)、尿素氮/肌酐（BUN/CR）、尿酸(UA)\"}, {\"title\": \"空腹血糖\", \"content\": \"评价人体空腹状态下糖代谢是否正常，评估糖尿病患者空腹血糖控制是否达标。空腹血糖是诊断糖代谢紊乱的最常用和最重要指标\"}, {\"title\": \"血常规\", \"content\": \"通过血常规检查发现血液方面的问题，评价骨髓功能，有助于临床急慢性感染，病毒性疾病的判断；有助于了解有无贫血及贫血分类；有助于出血性疾病的诊断等\"}, {\"title\": \"血脂四项\", \"content\": \"检查有无高脂血症,评估动脉硬化和冠心病的重要指标\"}, {\"title\": \"幽门螺杆菌分型\", \"content\": \"幽门螺旋杆菌是1类致癌物，主要是判断机体是否存在该病菌的感染\"}, {\"title\": \"甲胎蛋白\", \"content\": \"原发性肝癌的重要指标\"}, {\"title\": \"糖链抗原CA199\", \"content\": \"筛查胰腺癌、胆囊癌、胃癌等肿瘤的辅助诊断\"}, {\"title\": \"糖链抗原\", \"content\": \"筛查胰腺癌和直结肠癌的肿瘤标志物。胃、结肠、肝、胰腺和胆管的非肿瘤性疾病时也有部分增高\"}, {\"title\": \"癌胚抗原\", \"content\": \"癌胚抗原CEA是空腔器官如胃肠道、呼吸道、泌尿道、乳腺、卵巢等的肿瘤标志物\"}]', '[{\"title\": \"乳腺彩超\", \"content\": \"筛查乳腺小叶增生、肿瘤等\"}, {\"title\": \"肝胆脾胰彩超\", \"content\": \"检查相应脏器大小、形态、结构、声像，了解有无各种良恶性病变，可筛查脂肪肝、结石、囊肿、肿瘤、血管瘤、肝硬化等病变，是腹部脏器必查的项目\"}, {\"title\": \"甲状腺彩超\", \"content\": \"通过彩色超声仪检查甲状腺的形态、大小及血流情况、 判定是否有甲状腺肿大、结节、囊肿、肿瘤等\"}, {\"title\": \"子宫、双附件彩超\", \"content\": \"通过彩色超声仪器更清晰地观察子宫及附件（卵巢、输卵管）大小、形态结构及内部回声的情况，鉴别正常和异常，了解病变的性质，判别有无恶性病变，以便尽早处置\"}, {\"title\": \"胸部CT\", \"content\": \"筛查肺部和纵膈肿瘤，以及气管、支气管、肺部疾病，评估心脏形态大小（备孕及怀孕期间暂禁检查） \"}, {\"title\": \"心电图\", \"content\": \"检查有无心律失常、缺血性心脏病、心肌病变等心脏缺血缺氧性疾病\"}, {\"title\": \"前列腺彩超\", \"content\": \"在膀胱充盈时通过彩色超声仪器检查。更清晰地观察前列腺大小、形态、结构等情况，判断有无前列腺增大、囊肿、结石，恶性病变等\"}]', NULL, '[{\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(左)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裸眼视力(右)\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"裂隙灯检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"眼底检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"色觉检查\", \"name\": \"眼科检查\", \"type\": \"录入\", \"place\": \"眼科\", \"value\": \"色盲#色弱#正常\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"身高\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"体重\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"血压\", \"name\": \"血压身高体重\", \"type\": \"录入\", \"place\": \"一般检查室\", \"value\": \"无\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心肝脾肺\", \"name\": \"内科检查\", \"type\": \"录入\", \"place\": \"内科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"动脉硬化检测\", \"name\": \"动脉硬化检查\", \"type\": \"录入\", \"place\": \"动脉硬化检测室\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"淋巴结\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"甲状腺\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"脊柱四肢\", \"name\": \"外科检查\", \"type\": \"录入\", \"place\": \"外科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"鼻\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"耳朵\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"咽喉\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"听力\", \"name\": \"耳鼻喉检查\", \"type\": \"录入\", \"place\": \"耳鼻喉科\", \"value\": \"正常#偏弱#弱#听力障碍\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙齿\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#龋齿#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"牙周\", \"name\": \"口腔检查\", \"type\": \"录入\", \"place\": \"口腔科\", \"value\": \"未见异常#牙周炎#牙结石#牙周病#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"A1101\", \"item\": \"心电图(十二导联)\", \"name\": \"心电图检查\", \"type\": \"导入\", \"place\": \"心电图室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1001\", \"item\": \"血常规检查\", \"name\": \"血常规检查\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1002\", \"item\": \"空腹血糖(FBG)\", \"name\": \"空腹血糖\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1003\", \"item\": \"前列腺特异性抗原(PSA)\", \"name\": \"前列腺特异性抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1004\", \"item\": \"碱性磷酸酶(ALP)\", \"name\": \"碱性磷酸酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1005\", \"item\": \"肾功能3项\", \"name\": \"肾功能3项\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1006\", \"item\": \"糖类抗原(CA199)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1007\", \"item\": \"糖类抗原(CA153)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"女\", \"code\": \"X1008\", \"item\": \"糖类抗原(CA125)\", \"name\": \"糖类抗原\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1009\", \"item\": \"丙氨酸氨基转氨酶(ALT)\", \"name\": \"丙氨酸氨基转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1010\", \"item\": \"白蛋白\", \"name\": \"白蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1011\", \"item\": \"总胆红素(TBil)\", \"name\": \"总胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1012\", \"item\": \"直接胆红素(DBIL)\", \"name\": \"直接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1013\", \"item\": \"间接胆红素(IBIL)\", \"name\": \"间接胆红素\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1014\", \"item\": \"球蛋白\", \"name\": \"球蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1015\", \"item\": \"总蛋白(TP)\", \"name\": \"总蛋白\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1016\", \"item\": \"谷氨酰转肽酶(GGT)\", \"name\": \"谷氨酰转肽酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1017\", \"item\": \"谷草转氨酶（AST）\", \"name\": \"谷草转氨酶\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1018\", \"item\": \"总胆固醇(TC)\", \"name\": \"总胆固醇(TC)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1019\", \"item\": \"甘油三脂（TG）\", \"name\": \"甘油三脂（TG）\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1020\", \"item\": \"高密度脂蛋白(HDL)\", \"name\": \"高密度脂蛋白(HDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1021\", \"item\": \"低密度脂蛋白(LDL)\", \"name\": \"低密度脂蛋白(LDL)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1022\", \"item\": \"甲胎蛋白定量(AFP)\", \"name\": \"甲胎蛋白定量(AFP)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"X1023\", \"item\": \"癌胚抗原定量(CEA)\", \"name\": \"癌胚抗原定量(CEA)\", \"type\": \"导入\", \"place\": \"采血室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"N1001\", \"item\": \"尿常规\", \"name\": \"尿常规\", \"type\": \"导入\", \"place\": \"尿常规室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"男\", \"code\": \"C1001\", \"item\": \"彩超（前列腺）\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1002\", \"item\": \"彩超(膀胱及输尿管)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"C1003\", \"item\": \"彩超(肝胆脾胰肾)\", \"name\": \"彩超\", \"type\": \"导入\", \"place\": \"超声检查室\", \"value\": \"\", \"template\": \"模板2\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"骨密度检测\", \"name\": \"骨密度检测\", \"type\": \"录入\", \"place\": \"骨密度检查室\\t\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"两肺\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"心脏\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"纵隔\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"膈\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"无\", \"code\": \"无\", \"item\": \"胸膜\", \"name\": \"胸部正位检查\", \"type\": \"录入\", \"place\": \"放射科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"无\", \"item\": \"妇科常规\", \"name\": \"妇科常规\", \"type\": \"录入\", \"place\": \"妇科\", \"value\": \"未见异常#其他\", \"template\": \"模板1\"}, {\"sex\": \"女\", \"code\": \"B1201\", \"item\": \"白带常规\", \"name\": \"白带常规\", \"type\": \"导入\", \"place\": \"妇科\", \"value\": \"\", \"template\": \"模板2\"}]', 'front/goods/4cb475a1daef478293a643aff34eafe4.jpg', 2869.00, 1639.00, 0, '职场白领', '[\"白领精英\", \"中青年\", \"男性\", \"女性\"]', 3, NULL, 1, 'CE1148079472F80E5280BE742B41D2F3', '2023-06-06 12:22:05', '2023-06-06 12:20:59');

-- ----------------------------
-- Table structure for tb_module
-- ----------------------------
CREATE TABLE `tb_module`  (
  `id` int(10) UNSIGNED NOT NULL COMMENT '主键',
  `module_code` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模块编号',
  `module_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模块名称',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_module_id`(`module_code` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '模块资源表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tb_module
-- ----------------------------
INSERT INTO `tb_module` VALUES (1, 'ROLE', '角色管理');
INSERT INTO `tb_module` VALUES (2, 'USER', '用户管理');
INSERT INTO `tb_module` VALUES (3, 'DEPT', '部门管理');
INSERT INTO `tb_module` VALUES (4, 'GOODS', '体检套餐管理');
INSERT INTO `tb_module` VALUES (5, 'RULE', '促销规则管理');
INSERT INTO `tb_module` VALUES (6, 'CUSTOMER', '客户档案管理');
INSERT INTO `tb_module` VALUES (7, 'ORDER', '订单管理');
INSERT INTO `tb_module` VALUES (8, 'CUSTOMER_IM', '客服模块');
INSERT INTO `tb_module` VALUES (9, 'APPOINTMENT', '体检预约管理');
INSERT INTO `tb_module` VALUES (10, 'CUSTOMER_CHECKIN', '体检签到');
INSERT INTO `tb_module` VALUES (11, 'APPOINTMENT_RESTRICTION', '体检预约设置');
INSERT INTO `tb_module` VALUES (12, 'CHECKUP', '医生检查');
INSERT INTO `tb_module` VALUES (13, 'CHECKUP_REPORT', '体检报告管理');
INSERT INTO `tb_module` VALUES (14, 'FLOW_REGULATION', '人员限流管理');

-- ----------------------------
-- Table structure for tb_order
-- ----------------------------
CREATE TABLE `tb_order`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `customer_id` int(11) NOT NULL COMMENT '客户ID',
  `goods_id` int(11) NOT NULL COMMENT '商品ID',
  `snapshot_id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品快照ID',
  `goods_title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品标题',
  `goods_price` decimal(10, 2) NOT NULL COMMENT '商品价格',
  `number` int(11) NOT NULL COMMENT '购买数量',
  `amount` decimal(10, 2) NOT NULL COMMENT '付款金额',
  `goods_image` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品封面',
  `goods_description` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品描述',
  `out_trade_no` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单流水号',
  `transaction_id` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '付款单ID',
  `out_refund_no` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '退款单流水号',
  `status` tinyint(4) NOT NULL COMMENT '订单状态。1未付款，2已关闭，3已付款，4已退款，5已预约，6已结束',
  `create_date` date NOT NULL COMMENT '下单日期',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '下单日期时间',
  `refund_date` date NULL DEFAULT NULL COMMENT '退款日期',
  `refund_time` datetime NULL DEFAULT NULL COMMENT '退款日期时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_prepay_id`(`out_trade_no` ASC) USING BTREE,
  UNIQUE INDEX `unq_out_trade_no`(`out_trade_no` ASC) USING BTREE,
  UNIQUE INDEX `unq_transaction_id`(`transaction_id` ASC) USING BTREE,
  INDEX `idx_customer_id`(`customer_id` ASC) USING BTREE,
  INDEX `idx_goods_id`(`goods_id` ASC) USING BTREE,
  INDEX `idx_snapshot_id`(`snapshot_id` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tb_order
-- ----------------------------

-- ----------------------------
-- Table structure for tb_permission
-- ----------------------------
CREATE TABLE `tb_permission`  (
  `id` int(10) UNSIGNED NOT NULL COMMENT '主键',
  `permission_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '权限',
  `module_id` int(10) UNSIGNED NOT NULL COMMENT '模块ID',
  `action_id` int(10) UNSIGNED NOT NULL COMMENT '行为ID',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_permission`(`permission_name` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tb_permission
-- ----------------------------
INSERT INTO `tb_permission` VALUES (0, 'ROOT', 0, 0);
INSERT INTO `tb_permission` VALUES (1, 'ROLE:INSERT', 1, 1);
INSERT INTO `tb_permission` VALUES (2, 'ROLE:DELETE', 1, 2);
INSERT INTO `tb_permission` VALUES (3, 'ROLE:UPDATE', 1, 3);
INSERT INTO `tb_permission` VALUES (4, 'ROLE:SELECT', 1, 4);
INSERT INTO `tb_permission` VALUES (5, 'USER:INSERT', 2, 1);
INSERT INTO `tb_permission` VALUES (6, 'USER:DELETE', 2, 2);
INSERT INTO `tb_permission` VALUES (7, 'USER:UPDATE', 2, 3);
INSERT INTO `tb_permission` VALUES (8, 'USER:SELECT', 2, 4);
INSERT INTO `tb_permission` VALUES (9, 'DEPT:INSERT', 3, 1);
INSERT INTO `tb_permission` VALUES (10, 'DEPT:DELETE', 3, 2);
INSERT INTO `tb_permission` VALUES (11, 'DEPT:UPDATE', 3, 3);
INSERT INTO `tb_permission` VALUES (12, 'DEPT:SELECT', 3, 4);
INSERT INTO `tb_permission` VALUES (13, 'GOODS:INSERT', 4, 1);
INSERT INTO `tb_permission` VALUES (14, 'GOODS:DELETE', 4, 2);
INSERT INTO `tb_permission` VALUES (15, 'GOODS:UPDATE', 4, 3);
INSERT INTO `tb_permission` VALUES (16, 'GOODS:SELECT', 4, 4);
INSERT INTO `tb_permission` VALUES (17, 'RULE:INSERT', 5, 1);
INSERT INTO `tb_permission` VALUES (18, 'RULE:DELETE', 5, 2);
INSERT INTO `tb_permission` VALUES (19, 'RULE:UPDATE', 5, 3);
INSERT INTO `tb_permission` VALUES (20, 'RULE:SELECT', 5, 4);
INSERT INTO `tb_permission` VALUES (21, 'CUSTOMER:INSERT', 6, 1);
INSERT INTO `tb_permission` VALUES (22, 'CUSTOMER:DELETE', 6, 2);
INSERT INTO `tb_permission` VALUES (23, 'CUSTOMER:UPDATE', 6, 3);
INSERT INTO `tb_permission` VALUES (24, 'CUSTOMER:SELECT', 6, 4);
INSERT INTO `tb_permission` VALUES (25, 'ORDER:INSERT', 7, 1);
INSERT INTO `tb_permission` VALUES (26, 'ORDER:DELETE', 7, 2);
INSERT INTO `tb_permission` VALUES (27, 'ORDER:UPDATE', 7, 3);
INSERT INTO `tb_permission` VALUES (28, 'ORDER:SELECT', 7, 4);
INSERT INTO `tb_permission` VALUES (29, 'CUSTOMER_IM:INSERT', 8, 1);
INSERT INTO `tb_permission` VALUES (30, 'CUSTOMER_IM:DELETE', 8, 2);
INSERT INTO `tb_permission` VALUES (31, 'CUSTOMER_IM:UPDATE', 8, 3);
INSERT INTO `tb_permission` VALUES (32, 'CUSTOMER_IM:SELECT', 8, 4);
INSERT INTO `tb_permission` VALUES (33, 'APPOINTMENT:INSERT', 9, 1);
INSERT INTO `tb_permission` VALUES (34, 'APPOINTMENT:DELETE', 9, 2);
INSERT INTO `tb_permission` VALUES (35, 'APPOINTMENT:UPDATE', 9, 3);
INSERT INTO `tb_permission` VALUES (36, 'APPOINTMENT:SELECT', 9, 4);
INSERT INTO `tb_permission` VALUES (37, 'CUSTOMER_CHECKIN:INSERT', 10, 1);
INSERT INTO `tb_permission` VALUES (38, 'CUSTOMER_CHECKIN:DELETE', 10, 2);
INSERT INTO `tb_permission` VALUES (39, 'CUSTOMER_CHECKIN:UPDATE', 10, 3);
INSERT INTO `tb_permission` VALUES (40, 'CUSTOMER_CHECKIN:SELECT', 10, 4);
INSERT INTO `tb_permission` VALUES (41, 'APPOINTMENT_RESTRICTION:INSERT', 11, 1);
INSERT INTO `tb_permission` VALUES (42, 'APPOINTMENT_RESTRICTION:DELETE', 11, 2);
INSERT INTO `tb_permission` VALUES (43, 'APPOINTMENT_RESTRICTION:UPDATE', 11, 3);
INSERT INTO `tb_permission` VALUES (44, 'APPOINTMENT_RESTRICTION:SELECT', 11, 4);
INSERT INTO `tb_permission` VALUES (45, 'CHECKUP:INSERT', 12, 1);
INSERT INTO `tb_permission` VALUES (46, 'CHECKUP:DELETE', 12, 2);
INSERT INTO `tb_permission` VALUES (47, 'CHECKUP:UPDATE', 12, 3);
INSERT INTO `tb_permission` VALUES (48, 'CHECKUP:SELECT', 12, 4);
INSERT INTO `tb_permission` VALUES (49, 'CHECKUP_REPORT:INSERT', 13, 1);
INSERT INTO `tb_permission` VALUES (50, 'CHECKUP_REPORT:DELETE', 13, 2);
INSERT INTO `tb_permission` VALUES (51, 'CHECKUP_REPORT:UPDATE', 13, 3);
INSERT INTO `tb_permission` VALUES (52, 'CHECKUP_REPORT:SELECT', 13, 4);
INSERT INTO `tb_permission` VALUES (53, 'FLOW_REGULATION:INSERT', 14, 1);
INSERT INTO `tb_permission` VALUES (54, 'FLOW_REGULATION:DELETE', 14, 2);
INSERT INTO `tb_permission` VALUES (55, 'FLOW_REGULATION:UPDATE', 14, 3);
INSERT INTO `tb_permission` VALUES (56, 'FLOW_REGULATION:SELECT', 14, 4);

-- ----------------------------
-- Table structure for tb_role
-- ----------------------------
CREATE TABLE `tb_role`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
  `role_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称',
  `permissions` json NOT NULL COMMENT '权限集合',
  `desc` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `default_permissions` json NULL COMMENT '系统角色内置权限',
  `systemic` tinyint(1) NULL DEFAULT 0 COMMENT '是否为系统内置角色',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_role_name`(`role_name` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tb_role
-- ----------------------------
INSERT INTO `tb_role` VALUES (0, '超级管理员', '[0]', '超级管理员用户不能删除和修改', '[0]', 1);
INSERT INTO `tb_role` VALUES (1, '总经理', '[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 20, 21, 22, 23, 24, 25, 26, 27, 28]', NULL, '[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 27]', 1);
INSERT INTO `tb_role` VALUES (2, '部门经理', '[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14]', NULL, '[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 17, 27]', 1);
INSERT INTO `tb_role` VALUES (3, '普通员工', '[1, 2, 3, 4, 5, 6, 7, 8, 9, 10]', NULL, '[1, 2, 3, 4, 5, 6, 7, 8]', 1);
INSERT INTO `tb_role` VALUES (4, 'HR', '[1, 2, 3, 4, 5, 6, 7, 8, 27, 28, 29, 30, 31, 32]', NULL, '[1, 2, 3, 4, 5, 6, 7, 8, 28, 27]', 1);
INSERT INTO `tb_role` VALUES (5, '财务', '[1, 2, 3, 4, 5, 6, 7, 8, 13, 14, 17]', NULL, '[1, 2, 3, 4, 5, 6, 7, 8, 28, 36, 17]', 1);

UPDATE tb_role SET id=0 WHERE role_name="超级管理员";
-- ----------------------------
-- Table structure for tb_rule
-- ----------------------------
CREATE TABLE `tb_rule`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '规则名称',
  `rule` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '价格计算规则',
  `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_name`(`name` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '规则表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tb_rule
-- ----------------------------
INSERT INTO `tb_rule` VALUES (1, '两件五折', 'import java.math.BigDecimal;   \r\n\r\np = new BigDecimal(price);\r\nn = new BigDecimal(number);\r\n\r\nresult = new BigDecimal(number/2).multiply(new BigDecimal(\"0.5\")).multiply(p).multiply(new BigDecimal(\"2\")).add(new BigDecimal(number%2).multiply(p));', '每购买两个相同套餐，两个套餐都享受半价');
INSERT INTO `tb_rule` VALUES (2, '第二件半价', 'import java.math.BigDecimal;   \r\n\r\np = new BigDecimal(price);\r\nn = new BigDecimal(number);\r\n\r\nresult = n.multiply(p).subtract(new BigDecimal(number / 2).multiply(new BigDecimal(\"0.5\")).multiply(p)).toString();', '每购买两个相同套餐，第二个套餐半价');

-- ----------------------------
-- Table structure for tb_system
-- ----------------------------
CREATE TABLE `tb_system`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `item` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '设置项',
  `value` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '设定值',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tb_system
-- ----------------------------
INSERT INTO `tb_system` VALUES (1, 'appointment_number', '200', '每天预约体检人数上限');
INSERT INTO `tb_system` VALUES (2, 'auto_flow regulation', 'false', '体检自动调流');

-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
CREATE TABLE `tb_user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `open_id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '长期授权字符串',
  `photo` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像网址',
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '姓名',
  `sex` enum('男','女') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '性别',
  `tel` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '手机号码',
  `email` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '邮箱',
  `hiredate` date NULL DEFAULT NULL COMMENT '入职日期',
  `role` json NOT NULL COMMENT '角色',
  `root` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否是超级管理员',
  `dept_id` int(11) NULL DEFAULT NULL COMMENT '部门编号',
  `status` tinyint(4) NOT NULL COMMENT '状态',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_username`(`username` ASC) USING BTREE,
  UNIQUE INDEX `unq_open_id`(`open_id` ASC) USING BTREE,
  INDEX `idx_dept_id`(`dept_id` ASC) USING BTREE,
  INDEX `idx_status`(`status` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tb_user
-- ----------------------------
INSERT INTO `tb_user` VALUES (1, 'admin', '061575F43E456772015C0032C0531EDF', NULL, NULL, '超级管理员', '男', '13312345678', 'admin@163.com', '2023-03-15', '[0]', 1, 1, 1, '2023-02-17 14:51:11');

