wkx-his/script/sql/biz/update.sql

ALTER TABLE sys_user
ADD COLUMN name VARCHAR(100) COMMENT '姓名',
ADD COLUMN alias VARCHAR(50) COMMENT '别名',
ADD COLUMN role VARCHAR(50) COMMENT '角色',
ADD COLUMN dept_code VARCHAR(50) COMMENT '所属科室编码',
ADD COLUMN job_number VARCHAR(50) COMMENT '工号',
ADD COLUMN id_card VARCHAR(18) COMMENT '身份证号码',
ADD COLUMN address VARCHAR(200) COMMENT '现住地址',
ADD COLUMN birth_date DATE COMMENT '出生日期',
ADD COLUMN reg_address VARCHAR(200) COMMENT '户籍地址',
ADD COLUMN nation VARCHAR(20) COMMENT '民族',
ADD COLUMN political VARCHAR(20) COMMENT '政治面貌',
ADD COLUMN marital VARCHAR(10) COMMENT '婚姻状况',
ADD COLUMN title VARCHAR(50) COMMENT '职称',
ADD COLUMN education VARCHAR(20) COMMENT '学历',
ADD COLUMN intro TEXT COMMENT '职工简介',
ADD COLUMN expertise VARCHAR(200) COMMENT '擅长疾病',
ADD COLUMN signature_img VARCHAR(200) COMMENT '签名图片路径';

ALTER TABLE `enteral_nutrition_template` ADD COLUMN `type` tinyint(1) COMMENT '处方类型';
ALTER TABLE `enteral_nutrition_template` ADD COLUMN `template_type` tinyint(1) COMMENT '模板类型(0 个人模板; 1 基础公共模板)';

ALTER TABLE `invoice_setting` ADD COLUMN `drawer_type` tinyint(1) COMMENT '开票人类型(0 固定人员名称; 1 跟随账号名称)';
ALTER TABLE `charge_record` ADD COLUMN `whether_invoice` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已开票(0 否; 1 是)';
ALTER TABLE `consult_patient` ADD COLUMN `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '诊断状态(0 会诊中; 1 已结束)';
ALTER TABLE `consult_patient` MODIFY COLUMN `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '诊断状态(0 待会诊; 1 会诊中; 2 已结束)';
ALTER TABLE `settlement` ADD COLUMN `transaction_id` varchar(32) COMMENT '交易单号';
ALTER TABLE `invoice_record` MODIFY COLUMN `amount` decimal(10, 2) COMMENT '开票金额';