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 '签名图片路径';