CREATE TABLE `tj_item_result` (
`id` varchar(34) NOT NULL COMMENT '项目ID',
`group_id` varchar(34) NOT NULL DEFAULT '' COMMENT '组合项目ID',
`dept_id` varchar(34) DEFAULT NULL COMMENT '科室ID',
`record_id` varchar(34) NOT NULL DEFAULT '' COMMENT '体检记录ID',
`item_name` varchar(64) DEFAULT NULL COMMENT '项目名称',
`result_type` varchar(8) DEFAULT NULL COMMENT '结果类型',
`single_code` varchar(64) DEFAULT NULL COMMENT '拼音简码',
`disp_order` int(11) DEFAULT NULL COMMENT '显示排序',
`default_result` varchar(128) DEFAULT NULL COMMENT '默认正常结果',
`tj_value` mediumtext COMMENT '体检结果',
`item_unit` varchar(34) DEFAULT NULL COMMENT '项目单位',
`price` decimal(18,2) DEFAULT NULL COMMENT '单价',
`sample` varchar(64) DEFAULT NULL COMMENT '检验标本',
`inspection_type` varchar(64) DEFAULT NULL COMMENT '检验类型(如:生化、免疫等等)',
`yin_tips` varchar(128) DEFAULT NULL COMMENT '阴性提示(用于阴阳型体检项目)',
`yang_tips` varchar(128) DEFAULT NULL COMMENT '阳性提示(用于阴阳型体检项目)',
`yan_tips_color` varchar(32) DEFAULT NULL COMMENT '阳性提示颜色(用于阴阳型体检项目)',
`tips_content` varchar(128) DEFAULT NULL COMMENT '提示内容(用于检查结果最终提示)',
`tips_color` varchar(32) DEFAULT NULL COMMENT '提示颜色(用于检查结果最终提示)',
`renounce` varchar(8) DEFAULT NULL COMMENT '弃检标识',
`is_yang` varchar(8) DEFAULT NULL COMMENT '是否阳性(1阳性,0阴性)',
`tj_images` varchar(8) DEFAULT NULL COMMENT '影相标识(1有图片,0无图片)',
`item_ident` varchar(32) DEFAULT NULL COMMENT '项目标识(开发用)',
`item_type` varchar(32) DEFAULT NULL COMMENT '项目类型(1检验项目、0非检验项目)',
`item_code` varchar(32) DEFAULT NULL COMMENT '项目代码(lis接口)',
`is_create_summary` varchar(8) DEFAULT NULL COMMENT '生成科室小结标识(1生成,0不生成)',
`is_print_report` varchar(8) DEFAULT NULL COMMENT '报告打印标识(1打印,0不打印)',
`is_empty_belly` varchar(8) DEFAULT NULL COMMENT '空腹标识(1空腹检查,0非空腹检查)',
`is_check` varchar(8) DEFAULT NULL COMMENT '需要检查标识(1检查,0不检查)',
`is_hormone_item` varchar(8) DEFAULT NULL COMMENT '激素项目标识(1激素项目,0非激素项目)',
`is_inquirestherange` varchar(8) DEFAULT NULL COMMENT '是否需要查询范围(1需要,0不需要)',
`is_lineedit` varchar(8) DEFAULT NULL COMMENT '是否需要多行编辑(1需要,0不需要)',
`is_many_range` varchar(8) DEFAULT '0' COMMENT '是否有多个范围(0否 1是)',
`reference_range` varchar(128) DEFAULT NULL COMMENT '参考范围',
`is_have_workstation_report` varchar(8) DEFAULT NULL COMMENT '是否有工作站报告 (0否 1是)',
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
`modify_date` datetime DEFAULT NULL COMMENT '修改时间',
`cost_price` decimal(18,2) DEFAULT NULL COMMENT '成本价',
`summary_remark` varchar(1024) DEFAULT NULL COMMENT '小结备注',
`is_manual` varchar(8) DEFAULT NULL COMMENT '是否为手动判断(1是,0不是)',
`flag` varchar(8) DEFAULT '0' COMMENT '阳性结果是否有效',
`create_year` int(11) NOT NULL COMMENT '分区时间年',
PRIMARY KEY (`id`,`record_id`,`group_id`,`create_year`),
KEY `result_index` (`group_id`,`dept_id`,`id`,`record_id`),
KEY `record_id_index` (`record_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COMMENT='项目检查结果'
/*!50100 PARTITION BY RANGE (create_year)
(PARTITION p0 VALUES LESS THAN (2015) ENGINE = InnoDB,
PARTITION p1 VALUES LESS THAN (2016) ENGINE = InnoDB,
PARTITION p2 VALUES LESS THAN (2017) ENGINE = InnoDB,
PARTITION p3 VALUES LESS THAN (2018) ENGINE = InnoDB,
PARTITION p4 VALUES LESS THAN (2019) ENGINE = InnoDB,
PARTITION p5 VALUES LESS THAN (2020) ENGINE = InnoDB,
PARTITION p6 VALUES LESS THAN (2021) ENGINE = InnoDB,
PARTITION p7 VALUES LESS THAN (2022) ENGINE = InnoDB,
PARTITION p8 VALUES LESS THAN (2023) ENGINE = InnoDB,
PARTITION p9 VALUES LESS THAN (2024) ENGINE = InnoDB,
PARTITION p10 VALUES LESS THAN (2025) ENGINE = InnoDB,
PARTITION p11 VALUES LESS THAN (2026) ENGINE = InnoDB,
PARTITION p12 VALUES LESS THAN (2027) ENGINE = InnoDB,
PARTITION p13 VALUES LESS THAN (2028) ENGINE = InnoDB,
PARTITION p14 VALUES LESS THAN (2029) ENGINE = InnoDB,
PARTITION p15 VALUES LESS THAN (2030) ENGINE = InnoDB,
PARTITION p16 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */