comment_column_uc.sql
24.3 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
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 '版本号';