| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273 |
- ALTER TABLE gen_table ADD data_name varchar(200) default ''::varchar;
- COMMENT ON COLUMN gen_table.data_name IS '数据源名称';
- UPDATE sys_menu SET path = 'powerjob', component = 'monitor/powerjob/index', perms = 'monitor:powerjob:list', remark = 'powerjob控制台菜单' WHERE menu_id = 120;
- -- ----------------------------
- -- 第三方平台授权表
- -- ----------------------------
- create table sys_social
- (
- id int8 not null,
- user_id int8 not null,
- tenant_id varchar(20) default null::varchar,
- auth_id varchar(255) not null,
- source varchar(255) not null,
- open_id varchar(255) default null::varchar,
- user_name varchar(30) not null,
- nick_name varchar(30) default ''::varchar,
- email varchar(255) default ''::varchar,
- avatar varchar(500) default ''::varchar,
- access_token varchar(255) not null,
- expire_in int8 default null::varchar,
- refresh_token varchar(255) default null::varchar,
- access_code varchar(255) default null::varchar,
- union_id varchar(255) default null::varchar,
- scope varchar(255) default null::varchar,
- token_type varchar(255) default null::varchar,
- id_token varchar(255) default null::varchar,
- mac_algorithm varchar(255) default null::varchar,
- mac_key varchar(255) default null::varchar,
- code varchar(255) default null::varchar,
- oauth_token varchar(255) default null::varchar,
- oauth_token_secret varchar(255) default null::varchar,
- create_dept int8,
- create_by int8,
- create_time timestamp,
- update_by int8,
- update_time timestamp,
- del_flag char default '0'::bpchar,
- constraint "pk_sys_social" primary key (id)
- );
- comment on table sys_social is '社会化关系表';
- comment on column sys_social.id is '主键';
- comment on column sys_social.user_id is '用户ID';
- comment on column sys_social.tenant_id is '租户id';
- comment on column sys_social.auth_id is '授权+授权openid';
- comment on column sys_social.source is '用户来源';
- comment on column sys_social.open_id is '原生openid';
- comment on column sys_social.user_name is '登录账号';
- comment on column sys_social.nick_name is '用户昵称';
- comment on column sys_social.email is '用户邮箱';
- comment on column sys_social.avatar is '头像地址';
- comment on column sys_social.access_token is '用户的授权令牌';
- comment on column sys_social.expire_in is '用户的授权令牌的有效期，部分平台可能没有';
- comment on column sys_social.refresh_token is '刷新令牌，部分平台可能没有';
- comment on column sys_social.access_code is '平台的授权信息，部分平台可能没有';
- comment on column sys_social.union_id is '用户的 unionid';
- comment on column sys_social.scope is '授予的权限，部分平台可能没有';
- comment on column sys_social.token_type is '个别平台的授权信息，部分平台可能没有';
- comment on column sys_social.id_token is 'id token，部分平台可能没有';
- comment on column sys_social.mac_algorithm is '小米平台用户的附带属性，部分平台可能没有';
- comment on column sys_social.mac_key is '小米平台用户的附带属性，部分平台可能没有';
- comment on column sys_social.code is '用户的授权code，部分平台可能没有';
- comment on column sys_social.oauth_token is 'Twitter平台用户的附带属性，部分平台可能没有';
- comment on column sys_social.oauth_token_secret is 'Twitter平台用户的附带属性，部分平台可能没有';
- comment on column sys_social.create_dept is '创建部门';
- comment on column sys_social.create_by is '创建者';
- comment on column sys_social.create_time is '创建时间';
- comment on column sys_social.update_by is '更新者';
- comment on column sys_social.update_time is '更新时间';
- comment on column sys_social.del_flag is '删除标志（0代表存在 2代表删除）';
|
