ALTER TABLE `uc_demension` CHANGE `DEM_NAME_` `DEM_NAME_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '维度名称';
ALTER TABLE `uc_demension` CHANGE `CODE_` `CODE_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '维度代码';
ALTER TABLE `uc_demension` CHANGE `IS_DEFAULT_` `IS_DEFAULT_` int(11)    null  DEFAULT null    COMMENT  '是否默认(1:默认,0:非默认)';
ALTER TABLE `uc_demension` CHANGE `DEM_DESC_` `DEM_DESC_` varchar(255)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '描述';
ALTER TABLE `uc_demension` CHANGE `ORGAN_ID_` `ORGAN_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '机构id';
ALTER TABLE `uc_demension` CHANGE `IS_DELE_` `IS_DELE_` char(1)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT '0'   COMMENT  '是否已删，1已删除，0未删除';
ALTER TABLE `uc_demension` CHANGE `VERSION_` `VERSION_` int(11)    null  DEFAULT null    COMMENT  '版本号';
ALTER TABLE `uc_operate_log` CHANGE `REQ_IP_` `REQ_IP_` varchar(255)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '请求ip地址';
ALTER TABLE `uc_operate_log` CHANGE `REQ_TYPE_` `REQ_TYPE_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '请求方式';
ALTER TABLE `uc_operate_log` CHANGE `REQ_URL_` `REQ_URL_` varchar(200)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '请求地址';
ALTER TABLE `uc_operate_log` CHANGE `OPERATOR_NAME_` `OPERATOR_NAME_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '操作人';
ALTER TABLE `uc_operate_log` CHANGE `NOTE_` `NOTE_` varchar(2000)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '说明';
ALTER TABLE `uc_operate_log` CHANGE `SUCCESS_` `SUCCESS_` int(11)    null  DEFAULT null    COMMENT  '是否成功';
ALTER TABLE `uc_operate_log` CHANGE `FAIL_REASON_` `FAIL_REASON_` varchar(2000)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '失败原因';
ALTER TABLE `uc_operate_log` CHANGE `IS_DELE_` `IS_DELE_` char(1)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT '0'   COMMENT  '是否已删，1已删除，0未删除';
ALTER TABLE `uc_org` CHANGE `NAME_` `NAME_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '名称';
ALTER TABLE `uc_org` CHANGE `PARENT_ID_` `PARENT_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '父组织id';
ALTER TABLE `uc_org` CHANGE `ORDER_NO_` `ORDER_NO_` int(11)    null  DEFAULT null    COMMENT  '排序号';
ALTER TABLE `uc_org` CHANGE `CODE_` `CODE_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  NOT NULL     COMMENT  '组织代码';
ALTER TABLE `uc_org` CHANGE `GRADE_` `GRADE_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '级别';
ALTER TABLE `uc_org` CHANGE `PATH_` `PATH_` varchar(512)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '组织id路径，包含层级关系';
ALTER TABLE `uc_org` CHANGE `PATH_NAME_` `PATH_NAME_` varchar(512)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '组织名路径，包含层级关系';
ALTER TABLE `uc_org` CHANGE `DEM_ID_` `DEM_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '维度id';
ALTER TABLE `uc_org` CHANGE `IS_DELE_` `IS_DELE_` char(1)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT '0'   COMMENT  '是否已删，1已删除，0未删除';
ALTER TABLE `uc_org` CHANGE `VERSION_` `VERSION_` int(11)    null  DEFAULT null    COMMENT  '版本号';
ALTER TABLE `uc_org` CHANGE `LIMIT_NUM_` `LIMIT_NUM_` int(11)    NOT NULL  DEFAULT '0'   COMMENT  '组织限编用户数量(0:不受限制)';
ALTER TABLE `uc_org` CHANGE `NOW_NUM_` `NOW_NUM_` int(11)    null  DEFAULT null    COMMENT  '组织现编用户数量';
ALTER TABLE `uc_org` CHANGE `EXCEED_LIMIT_NUM_` `EXCEED_LIMIT_NUM_` int(11)    NOT NULL  DEFAULT '0'   COMMENT  '是否允许超过限编(0:允许；1:不允许)';
ALTER TABLE `uc_org_auth` CHANGE `USER_ID_` `USER_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '分级组织管理员id';
ALTER TABLE `uc_org_auth` CHANGE `ORG_ID_` `ORG_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '对应管理组织id';
ALTER TABLE `uc_org_auth` CHANGE `DEM_ID_` `DEM_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '对应维度id';
ALTER TABLE `uc_org_auth` CHANGE `ORG_PERMS_` `ORG_PERMS_` varchar(255)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '组织管理权限';
ALTER TABLE `uc_org_auth` CHANGE `USER_PERMS_` `USER_PERMS_` varchar(255)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '用户管理权限';
ALTER TABLE `uc_org_auth` CHANGE `POS_PERMS_` `POS_PERMS_` varchar(255)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '岗位管理权限';
ALTER TABLE `uc_org_auth` CHANGE `ORGAUTH_PERMS_` `ORGAUTH_PERMS_` varchar(255)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '分级管理员权限';
ALTER TABLE `uc_org_auth` CHANGE `LAYOUT_PERMS_` `LAYOUT_PERMS_` varchar(255)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '首页布局管理权限';
ALTER TABLE `uc_org_auth` CHANGE `IS_DELE_` `IS_DELE_` char(1)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT '0'   COMMENT  '是否已删，1已删除，0未删除';
ALTER TABLE `uc_org_auth` CHANGE `VERSION_` `VERSION_` int(11)    null  DEFAULT null    COMMENT  '版本号';
ALTER TABLE `uc_org_job` CHANGE `NAME_` `NAME_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  NOT NULL     COMMENT  '名称';
ALTER TABLE `uc_org_job` CHANGE `CODE_` `CODE_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  NOT NULL     COMMENT  '编码';
ALTER TABLE `uc_org_job` CHANGE `JOB_LEVEL_` `JOB_LEVEL_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '职务级别';
ALTER TABLE `uc_org_job` CHANGE `DESCRIPTION_` `DESCRIPTION_` varchar(512)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '描述';
ALTER TABLE `uc_org_job` CHANGE `IS_DELE_` `IS_DELE_` char(1)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT '0'   COMMENT  '是否已删，1已删除，0未删除';
ALTER TABLE `uc_org_job` CHANGE `VERSION_` `VERSION_` int(11)    null  DEFAULT null    COMMENT  '版本号';
ALTER TABLE `uc_org_params` CHANGE `ORG_ID_` `ORG_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '组织id';
ALTER TABLE `uc_org_params` CHANGE `CODE_` `CODE_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '参数代码';
ALTER TABLE `uc_org_params` CHANGE `VALUE_` `VALUE_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '值';
ALTER TABLE `uc_org_params` CHANGE `IS_DELE_` `IS_DELE_` char(1)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT '0'   COMMENT  '是否已删，1已删除，0未删除';
ALTER TABLE `uc_org_params` CHANGE `VERSION_` `VERSION_` int(11)    null  DEFAULT null    COMMENT  '版本号';
ALTER TABLE `uc_org_post` CHANGE `ORG_ID_` `ORG_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '组织id';
ALTER TABLE `uc_org_post` CHANGE `JOB_ID_` `JOB_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '职务id';
ALTER TABLE `uc_org_post` CHANGE `POS_NAME_` `POS_NAME_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '岗位名称';
ALTER TABLE `uc_org_post` CHANGE `CODE_` `CODE_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '岗位编码';
ALTER TABLE `uc_org_post` CHANGE `IS_CHARGE_` `IS_CHARGE_` int(11)    NOT NULL  DEFAULT '0'   COMMENT  '是否主岗位：1主岗位，0 非主岗位';
ALTER TABLE `uc_org_post` CHANGE `IS_DELE_` `IS_DELE_` char(1)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT '0'   COMMENT  '是否已删，1已删除，0未删除';
ALTER TABLE `uc_org_post` CHANGE `VERSION_` `VERSION_` int(11)    null  DEFAULT null    COMMENT  '版本号';
ALTER TABLE `uc_org_role` CHANGE `ROLE_ID_` `ROLE_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '角色id';
ALTER TABLE `uc_org_role` CHANGE `ORG_ID_` `ORG_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '组织id';
ALTER TABLE `uc_org_role` CHANGE `IS_INHERIT_` `IS_INHERIT_` int(11)    null  DEFAULT '0'   COMMENT  '子组织是否可以继承,0:不可1:可以';
ALTER TABLE `uc_org_role` CHANGE `IS_DELE_` `IS_DELE_` char(1)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT '0'   COMMENT  '是否已删，1已删除，0未删除';
ALTER TABLE `uc_org_role` CHANGE `VERSION_` `VERSION_` int(11)    null  DEFAULT null    COMMENT  '版本号';
ALTER TABLE `uc_org_user` CHANGE `ORG_ID_` `ORG_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '组织编号';
ALTER TABLE `uc_org_user` CHANGE `USER_ID_` `USER_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '用户编号';
ALTER TABLE `uc_org_user` CHANGE `IS_MASTER_` `IS_MASTER_` int(11)    NOT NULL  DEFAULT '0'   COMMENT  '0:非主部门，1：主部门';
ALTER TABLE `uc_org_user` CHANGE `POS_ID_` `POS_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '岗位id';
ALTER TABLE `uc_org_user` CHANGE `IS_CHARGE_` `IS_CHARGE_` int(11)    null  DEFAULT '0'   COMMENT  '2组织主负责人，1组织负责人，0 不是负责人';
ALTER TABLE `uc_org_user` CHANGE `IS_REL_ACTIVE_` `IS_REL_ACTIVE_` int(11)    NOT NULL     COMMENT  '是否有效，0:无效，1：有效';
ALTER TABLE `uc_org_user` CHANGE `IS_DELE_` `IS_DELE_` char(1)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT '0'   COMMENT  '是否已删，1已删除，0未删除';
ALTER TABLE `uc_org_user` CHANGE `VERSION_` `VERSION_` int(11)    null  DEFAULT null    COMMENT  '版本号';
ALTER TABLE `uc_organ` CHANGE `CODE_` `CODE_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '机构编码';
ALTER TABLE `uc_organ` CHANGE `NAME_` `NAME_` varchar(255)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '机构名称';
ALTER TABLE `uc_organ` CHANGE `DESC_` `DESC_` varchar(512)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '机构描述';
ALTER TABLE `uc_organ` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '创建人';
ALTER TABLE `uc_organ` CHANGE `IS_DELE_` `IS_DELE_` char(1)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT '0'   COMMENT  '是否已删，1已删除，0未删除';
ALTER TABLE `uc_organ` CHANGE `VERSION_` `VERSION_` int(11)    null  DEFAULT null    COMMENT  '版本号';
ALTER TABLE `uc_params` CHANGE `NAME_` `NAME_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '参数名称';
ALTER TABLE `uc_params` CHANGE `CODE_` `CODE_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '参数代码';
ALTER TABLE `uc_params` CHANGE `TYPE_` `TYPE_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '类型';
ALTER TABLE `uc_params` CHANGE `CTL_TYPE_` `CTL_TYPE_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '控件类型';
ALTER TABLE `uc_params` CHANGE `JSON_` `JSON_` varchar(512)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  'json值';
ALTER TABLE `uc_params` CHANGE `IS_DELE_` `IS_DELE_` char(1)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT '0'   COMMENT  '是否已删，1已删除，0未删除';
ALTER TABLE `uc_params` CHANGE `VERSION_` `VERSION_` int(11)    null  DEFAULT null    COMMENT  '版本号';
ALTER TABLE `uc_pwd_strategy` CHANGE `PWD_RULE_` `PWD_RULE_` smallint(6)    null  DEFAULT null    COMMENT  '密码规则';
ALTER TABLE `uc_pwd_strategy` CHANGE `PWD_LENGTH_` `PWD_LENGTH_` smallint(6)    null  DEFAULT null    COMMENT  '密码长度';
ALTER TABLE `uc_pwd_strategy` CHANGE `DURATION_` `DURATION_` smallint(6)    null  DEFAULT null    COMMENT  '密码时长（单位：天）';
ALTER TABLE `uc_pwd_strategy` CHANGE `ENABLE_` `ENABLE_` smallint(6)    null  DEFAULT null    COMMENT  '启用策略	0:停用，1:启用';
ALTER TABLE `uc_rel_auth` CHANGE `USER_ID_` `USER_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '分级汇报线管理员id';
ALTER TABLE `uc_rel_auth` CHANGE `REL_ID_` `REL_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '对应汇报线节点id';
ALTER TABLE `uc_rel_auth` CHANGE `TYPE_ID_` `TYPE_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '对应汇报线分类id';
ALTER TABLE `uc_rel_auth` CHANGE `IS_DELE_` `IS_DELE_` char(1)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT '0'   COMMENT  '是否已删，1已删除，0未删除';
ALTER TABLE `uc_rel_auth` CHANGE `VERSION_` `VERSION_` int(11)    null  DEFAULT null    COMMENT  '版本号';
ALTER TABLE `uc_rel_type` CHANGE `NAME_` `NAME_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '汇报关系分类名称';
ALTER TABLE `uc_rel_type` CHANGE `CODE_` `CODE_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '英文别名';
ALTER TABLE `uc_rel_type` CHANGE `DESCRIPTION_` `DESCRIPTION_` varchar(255)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '描述';
ALTER TABLE `uc_rel_type` CHANGE `IS_DELE_` `IS_DELE_` char(1)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT '0'   COMMENT  '是否已删，1已删除，0未删除';
ALTER TABLE `uc_rel_type` CHANGE `VERSION_` `VERSION_` int(11)    null  DEFAULT null    COMMENT  '版本号';
ALTER TABLE `uc_role` CHANGE `NAME_` `NAME_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '角色名称';
ALTER TABLE `uc_role` CHANGE `CODE_` `CODE_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '英文别名';
ALTER TABLE `uc_role` CHANGE `ENABLED_` `ENABLED_` int(11)    null  DEFAULT null    COMMENT  '可用 0：禁用，1：启用';
ALTER TABLE `uc_role` CHANGE `DESCRIPTION_` `DESCRIPTION_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '描述';
ALTER TABLE `uc_role` CHANGE `IS_DELE_` `IS_DELE_` char(1)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT '0'   COMMENT  '是否已删，1已删除，0未删除';
ALTER TABLE `uc_role` CHANGE `VERSION_` `VERSION_` int(11)    null  DEFAULT null    COMMENT  '版本号';
ALTER TABLE `uc_tenant_logs` CHANGE `RESULT_` `RESULT_` smallint(6)    null  DEFAULT null    COMMENT  '操作结果（1:成功，0:失败）';
ALTER TABLE `uc_tenant_mail_server` CHANGE `MAIL_PORT_` `MAIL_PORT_` int(11)    null  DEFAULT null    COMMENT  '端口号';
ALTER TABLE `uc_tenant_mail_server` CHANGE `USE_SSL_` `USE_SSL_` smallint(6)    null  DEFAULT null    COMMENT  '是否使用SSL认证。0：否；1：是';
ALTER TABLE `uc_tenant_manage` CHANGE `IS_DELE_` `IS_DELE_` char(1)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT '0'   COMMENT  '是否已删，1已删除，0未删除';
ALTER TABLE `uc_user` CHANGE `FULLNAME_` `FULLNAME_` varchar(255)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '姓名';
ALTER TABLE `uc_user` CHANGE `ACCOUNT_` `ACCOUNT_` varchar(255)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '帐号';
ALTER TABLE `uc_user` CHANGE `PASSWORD_` `PASSWORD_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '密码';
ALTER TABLE `uc_user` CHANGE `EMAIL_` `EMAIL_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '邮箱';
ALTER TABLE `uc_user` CHANGE `MOBILE_` `MOBILE_` varchar(255)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '手机号码';
ALTER TABLE `uc_user` CHANGE `WEIXIN_` `WEIXIN_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '微信号';
ALTER TABLE `uc_user` CHANGE `ADDRESS_` `ADDRESS_` varchar(512)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '地址';
ALTER TABLE `uc_user` CHANGE `PHOTO_` `PHOTO_` varchar(255)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '头像';
ALTER TABLE `uc_user` CHANGE `SEX_` `SEX_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '性别：男，女，未知';
ALTER TABLE `uc_user` CHANGE `FROM_` `FROM_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '来源';
ALTER TABLE `uc_user` CHANGE `STATUS_` `STATUS_` int(11)    null  DEFAULT null    COMMENT  '0:禁用，1正常';
ALTER TABLE `uc_user` CHANGE `HAS_SYNC_TO_WX_` `HAS_SYNC_TO_WX_` int(11)    null  DEFAULT null    COMMENT  '微信同步关注状态: 0：未同步  1：已同步，尚未关注  2：已同步且已关注';
ALTER TABLE `uc_user` CHANGE `NOTIFY_TYPE_` `NOTIFY_TYPE_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '自定义接收消息类型';
ALTER TABLE `uc_user` CHANGE `USER_NUMBER_` `USER_NUMBER_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '工号';
ALTER TABLE `uc_user` CHANGE `ID_CARD_` `ID_CARD_` varchar(38)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '身份证号';
ALTER TABLE `uc_user` CHANGE `PHONE_` `PHONE_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '办公电话';
ALTER TABLE `uc_user` CHANGE `EDUCATION_` `EDUCATION_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '学历';
ALTER TABLE `uc_user` CHANGE `IS_DELE_` `IS_DELE_` char(1)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT '0'   COMMENT  '是否已删，1已删除，0未删除';
ALTER TABLE `uc_user` CHANGE `VERSION_` `VERSION_` int(11)    null  DEFAULT null    COMMENT  '版本号';
ALTER TABLE `uc_user_group` CHANGE `NAME_` `NAME_` varchar(255)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '名称';
ALTER TABLE `uc_user_group` CHANGE `JSON_` `JSON_` varchar(2000)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '群里的人或组';
ALTER TABLE `uc_user_group` CHANGE `CODE_` `CODE_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '群组代码';
ALTER TABLE `uc_user_group` CHANGE `DESCRIPTION_` `DESCRIPTION_` varchar(512)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '描述';
ALTER TABLE `uc_user_group` CHANGE `USER_ID_` `USER_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '用户id';
ALTER TABLE `uc_user_group` CHANGE `ORG_ID_` `ORG_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '组织id';
ALTER TABLE `uc_user_group` CHANGE `ROLE_ID_` `ROLE_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '角色id';
ALTER TABLE `uc_user_group` CHANGE `POS_ID_` `POS_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '岗位id';
ALTER TABLE `uc_user_group` CHANGE `IS_DELE_` `IS_DELE_` char(1)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT '0'   COMMENT  '是否已删，1已删除，0未删除';
ALTER TABLE `uc_user_group` CHANGE `VERSION_` `VERSION_` int(11)    null  DEFAULT null    COMMENT  '版本号';
ALTER TABLE `uc_user_params` CHANGE `USER_ID_` `USER_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '用户id';
ALTER TABLE `uc_user_params` CHANGE `CODE_` `CODE_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '参数代码';
ALTER TABLE `uc_user_params` CHANGE `VALUE_` `VALUE_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '参数值';
ALTER TABLE `uc_user_params` CHANGE `IS_DELE_` `IS_DELE_` char(1)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT '0'   COMMENT  '是否已删，1已删除，0未删除';
ALTER TABLE `uc_user_params` CHANGE `VERSION_` `VERSION_` int(11)    null  DEFAULT null    COMMENT  '版本号';
ALTER TABLE `uc_user_rel` CHANGE `NAME_` `NAME_` varchar(255)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '名称';
ALTER TABLE `uc_user_rel` CHANGE `LEVEL_` `LEVEL_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '级别(用于区分有多个上级的情况)';
ALTER TABLE `uc_user_rel` CHANGE `PARENT_ID_` `PARENT_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '父id';
ALTER TABLE `uc_user_rel` CHANGE `TYPE_ID_` `TYPE_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '用户关系分类下的id';
ALTER TABLE `uc_user_rel` CHANGE `GROUP_TYPE_` `GROUP_TYPE_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '群组id';
ALTER TABLE `uc_user_rel` CHANGE `PATH_` `PATH_` varchar(512)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '组织id路径，包含层级关系';
ALTER TABLE `uc_user_rel` CHANGE `VALUE_` `VALUE_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '值';
ALTER TABLE `uc_user_rel` CHANGE `STATUS_` `STATUS_` int(11)    null  DEFAULT null    COMMENT  '状态（1：正常，0：失效）';
ALTER TABLE `uc_user_rel` CHANGE `ALIAS_` `ALIAS_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '用户组别名';
ALTER TABLE `uc_user_rel` CHANGE `IS_DELE_` `IS_DELE_` char(1)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT '0'   COMMENT  '是否已删，1已删除，0未删除';
ALTER TABLE `uc_user_rel` CHANGE `VERSION_` `VERSION_` int(11)    null  DEFAULT null    COMMENT  '版本号';
ALTER TABLE `uc_user_role` CHANGE `ROLE_ID_` `ROLE_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '角色id';
ALTER TABLE `uc_user_role` CHANGE `USER_ID_` `USER_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '用户id';
ALTER TABLE `uc_user_role` CHANGE `IS_DELE_` `IS_DELE_` char(1)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT '0'   COMMENT  '是否已删，1已删除，0未删除';
ALTER TABLE `uc_user_role` CHANGE `VERSION_` `VERSION_` int(11)    null  DEFAULT null    COMMENT  '版本号';
ALTER TABLE `uc_user_under` CHANGE `USER_ID_` `USER_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '用户id';
ALTER TABLE `uc_user_under` CHANGE `UNDER_USER_ID_` `UNDER_USER_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '下属用户id';
ALTER TABLE `uc_user_under` CHANGE `UNDER_USER_NAME_` `UNDER_USER_NAME_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '下属用户名';
ALTER TABLE `uc_user_under` CHANGE `ORG_ID_` `ORG_ID_` varchar(64)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT null    COMMENT  '组织id';
ALTER TABLE `uc_user_under` CHANGE `IS_DELE_` `IS_DELE_` char(1)  character set utf8  COLLATE 'utf8_general_ci'  null  DEFAULT '0'   COMMENT  '是否已删，1已删除，0未删除';
ALTER TABLE `uc_user_under` CHANGE `VERSION_` `VERSION_` int(11)    null  DEFAULT null    COMMENT  '版本号';