diagbotcloud/docs/031.20200229自诊程序配置/zzcx20200220.sql

ALTER TABLE `zzcx_inquiry_info`
ADD COLUMN `pat_name` varchar(50) NOT NULL DEFAULT '' COMMENT '姓名' after `ip`;

ALTER TABLE `zzcx_inquiry_info`
ADD COLUMN `pat_age` int(8) NOT NULL DEFAULT '0' COMMENT '年龄' after `pat_name`;

ALTER TABLE `zzcx_inquiry_info`
ADD COLUMN `pat_sex` tinyint(4)  NOT NULL DEFAULT '0' COMMENT '性别' after `pat_age`;

ALTER TABLE `zzcx_inquiry_info`
ADD COLUMN `id_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '证件类型(1：身份证，2：护照)' after `pat_sex`;

ALTER TABLE `zzcx_inquiry_info`
ADD COLUMN `id_num` varchar(100) NOT NULL DEFAULT '' COMMENT '证件号' after `id_type`;

ALTER TABLE `zzcx_inquiry_info`
ADD COLUMN `degree` tinyint(4) NOT NULL DEFAULT '0' COMMENT '诊断程度(1：高，2：中，3：低)' after `id_num`;