CREATE TABLE em_agent_base (
id varchar(32) NOT NULL PRIMARY KEY,
open_agent_id int DEFAULT NULL,
agent_type tinyint DEFAULT NULL,
agent_name varchar(100) DEFAULT NULL,
english_name varchar(100) DEFAULT NULL,
associate_outsysid varchar(32) DEFAULT NULL,
description varchar(200) DEFAULT NULL,
logo varchar(255) DEFAULT NULL,
enable_home tinyint DEFAULT NULL,
redirect_domain varchar(100) DEFAULT NULL,
msg_url varchar(200) DEFAULT NULL,
share_url varchar(200) DEFAULT NULL,
dialog_url varchar(200) DEFAULT NULL,
status_url varchar(200) DEFAULT NULL,
attention_url varchar(200) DEFAULT NULL,
home_url varchar(200) DEFAULT NULL,
home_url_pc varchar(200) DEFAULT NULL,
manage_url varchar(200) DEFAULT NULL,
count_url varchar(200) DEFAULT NULL,
setting_url varchar(200) DEFAULT NULL,
report_location_flag tinyint DEFAULT NULL,
isreportenter tinyint DEFAULT NULL,
ios_pkgname varchar(50) DEFAULT NULL,
ios_downloadurl varchar(500) DEFAULT NULL,
and_pkgname varchar(50) DEFAULT NULL,
and_downloadurl varchar(500) DEFAULT NULL,
app_auth varchar(100) DEFAULT NULL,
app_gopage varchar(500) DEFAULT NULL,
clienttypes varchar(20) DEFAULT NULL,
isshowinportal tinyint DEFAULT 1,
isshowinstore tinyint DEFAULT 1,
enable_msg tinyint DEFAULT NULL,
isshowinmsg tinyint DEFAULT 0,
msg_extend_url varchar(200) DEFAULT NULL,
msg_extend_name varchar(100) DEFAULT NULL,
msg_extend_logo varchar(255) DEFAULT NULL,
msg_extend_logo_pc varchar(255) DEFAULT NULL,
msg_extend_showorder decimal(10, 2) DEFAULT NULL,
msg_extend_ishead tinyint DEFAULT NULL,
msg_extend_wwidth int DEFAULT NULL,
msg_extend_wheight int DEFAULT NULL,
msg_extend_ispreload tinyint DEFAULT NULL,
enable_auth tinyint DEFAULT NULL,
auth_type tinyint DEFAULT NULL,
auth_access_token varchar(50) DEFAULT NULL,
auth_userid_field varchar(32) DEFAULT NULL,
auth_outsysid varchar(32) DEFAULT NULL,
status tinyint DEFAULT 1,
create_user_id varchar(32) DEFAULT NULL,
create_time TIMESTAMP DEFAULT NULL,
update_user_id varchar(32) DEFAULT NULL,
update_time TIMESTAMP DEFAULT NULL,
tenant_id varchar(32) DEFAULT NULL,
server_agent_id varchar(200) DEFAULT NULL
)
;
COMMENT ON TABLE em_agent_base IS '企业应用基本信息表'
;
COMMENT ON COLUMN em_agent_base.id IS '主键ID'
;
COMMENT ON COLUMN em_agent_base.open_agent_id IS 'API交互时的唯一标识,采用某企业内自增长逻辑,即按tenantid自增长'
;
COMMENT ON COLUMN em_agent_base.agent_type IS '应用类型 1-链接型,2-打开第三方APP,3-ecology应用'
;
COMMENT ON COLUMN em_agent_base.agent_name IS '应用名称'
;
COMMENT ON COLUMN em_agent_base.english_name IS '英文名称'
;
COMMENT ON COLUMN em_agent_base.associate_outsysid IS '应用关联的集成系统'
;
COMMENT ON COLUMN em_agent_base.description IS '描述'
;
COMMENT ON COLUMN em_agent_base.logo IS '图标'
;
COMMENT ON COLUMN em_agent_base.enable_home IS '是否开启主页信息'
;
COMMENT ON COLUMN em_agent_base.redirect_domain IS '可信域名'
;
COMMENT ON COLUMN em_agent_base.msg_url IS '消息链接地址'
;
COMMENT ON COLUMN em_agent_base.share_url IS '消息分享地址'
;
COMMENT ON COLUMN em_agent_base.dialog_url IS '消息主页地址:用户在消息会话列表中点击此应用会话时打开的页面地址,不设置则进入系统默认的消息页面'
;
COMMENT ON COLUMN em_agent_base.status_url IS '消息状态接口地址:推送到此应用的消息的状态获取接口地址,例如流程的已处理未处理'
;
COMMENT ON COLUMN em_agent_base.attention_url IS '消息提醒设置地址:用户个性化设置消息提醒的页面地址'
;
COMMENT ON COLUMN em_agent_base.home_url IS '应用主页地址'
;
COMMENT ON COLUMN em_agent_base.home_url_pc IS 'PC版应用主页地址'
;
COMMENT ON COLUMN em_agent_base.manage_url IS '后台管理主页'
;
COMMENT ON COLUMN em_agent_base.count_url IS '统计提示信息数量url地址'
;
COMMENT ON COLUMN em_agent_base.setting_url IS '客户端设置页面'
;
COMMENT ON COLUMN em_agent_base.report_location_flag IS '企业应用是否打开地理位置上报 0:不上报;1:进入会话上报'
;
COMMENT ON COLUMN em_agent_base.isreportenter IS '是否上报用户进入应用事件。0:不接收;1:接收'
;
COMMENT ON COLUMN em_agent_base.ios_pkgname IS '第三方APPiOS应用scheme'
;
COMMENT ON COLUMN em_agent_base.ios_downloadurl IS '第三方APPiOS应用下载地址'
;
COMMENT ON COLUMN em_agent_base.and_pkgname IS '第三方APPAndroid应用包名'
;
COMMENT ON COLUMN em_agent_base.and_downloadurl IS '第三方APPAndroid应用下载地址'
;
COMMENT ON COLUMN em_agent_base.app_auth IS '第三方APP访问验证参数'
;
COMMENT ON COLUMN em_agent_base.app_gopage IS '第三方APP访问直接打开的地址'
;
COMMENT ON COLUMN em_agent_base.clienttypes IS '适用客户端类型:1-PC客户端,2-IOS客户端,3-安卓客户端,4-web版,适用于多个客户端时用逗号分隔表示,值为null或者空字符串时表示适用于所有客户端类型'
;
COMMENT ON COLUMN em_agent_base.isshowinportal IS '是否显示在门户的其他应用分组中 1-显示,0-不显示'
;
COMMENT ON COLUMN em_agent_base.isshowinstore IS '是否显示在应用商店中,即所有应用列表中 1-显示,0-不显示'
;
COMMENT ON COLUMN em_agent_base.enable_msg IS '是否开启消息相关'
;
COMMENT ON COLUMN em_agent_base.isshowinmsg IS '是否显示在消息扩展功能中,即发送消息时的扩展功能按钮 1-显示,0-不显示'
;
COMMENT ON COLUMN em_agent_base.msg_extend_url IS '消息扩展链接地址'
;
COMMENT ON COLUMN em_agent_base.msg_extend_name IS '消息扩展名称,不设置则与应用名称相同'
;
COMMENT ON COLUMN em_agent_base.msg_extend_logo IS '消息扩展图标,不设置则与应用图标相同'
;
COMMENT ON COLUMN em_agent_base.msg_extend_logo_pc IS '消息扩展图标,不设置则与应用图标相同'
;
COMMENT ON COLUMN em_agent_base.msg_extend_showorder IS '消息扩展排序'
;
COMMENT ON COLUMN em_agent_base.msg_extend_ishead IS '应用消息拓展,添加是否显示头'
;
COMMENT ON COLUMN em_agent_base.msg_extend_wwidth IS '应用消息拓展,显示窗口宽度'
;
COMMENT ON COLUMN em_agent_base.msg_extend_wheight IS '应用消息拓展,显示窗口高度'
;
COMMENT ON COLUMN em_agent_base.msg_extend_ispreload IS '消息是否显示预加载'
;
COMMENT ON COLUMN em_agent_base.enable_auth IS '是否开启授权'
;
COMMENT ON COLUMN em_agent_base.auth_type IS '单点登录方式 1:oauth2 2:SHA1 3:ecology'
;
COMMENT ON COLUMN em_agent_base.auth_access_token IS '单点登录秘钥,当auth_type为2时使用'
;
COMMENT ON COLUMN em_agent_base.auth_userid_field IS '单点登录用户标识字段,当auth_type为2时使用,其中1标识基础用户ID,2标识通讯录userid,3标识通讯录手机号,其他表示自定义字段ID'
;
COMMENT ON COLUMN em_agent_base.auth_outsysid IS '单点登录集成系统ID,当auth_type为3时使用,对应em_integrate_outsys_info表的id'
;
COMMENT ON COLUMN em_agent_base.status IS '状态 1-正常,2-禁用,3-删除'
;
COMMENT ON COLUMN em_agent_base.create_user_id IS '创建人'
;
COMMENT ON COLUMN em_agent_base.create_time IS '创建时间'
;
COMMENT ON COLUMN em_agent_base.update_user_id IS '修改人'
;
COMMENT ON COLUMN em_agent_base.update_time IS '修改时间'
;
COMMENT ON COLUMN em_agent_base.tenant_id IS '企业租户ID'
;
CREATE OR REPLACE INDEX em_agent_base_open_agent_id_index ON em_agent_base(open_agent_id)
;
CREATE OR REPLACE INDEX em_agent_base_tenant_id_index ON em_agent_base(tenant_id)
;
CREATE TABLE em_agent_msg_log (
id varchar(32) NOT NULL PRIMARY KEY,
open_agent_id int DEFAULT NULL,
touser text,
toparty text,
todept text,
tota
没有合适的资源?快使用搜索试试~ 我知道了~
EMP7.0手机版升级包-20200410
![preview](https://csdnimg.cn/release/downloadcmsfe/public/img/white-bg.ca8570fa.png)
共2000个文件
class:1725个
sql:1196个
css:1082个
![preview-icon](https://csdnimg.cn/release/downloadcmsfe/public/img/scale.ab9e0183.png)
需积分: 5 0 下载量 128 浏览量
2023-04-26
09:14:33
上传
评论
收藏 126.87MB ZIP 举报
温馨提示
EMP7.0手机版升级包_20200410,正式安装文件安装后必须升级才能运行。
资源推荐
资源详情
资源评论
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![application/pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![application/msword](https://img-home.csdnimg.cn/images/20210720083327.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![gz](https://img-home.csdnimg.cn/images/20210720083447.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![docx](https://img-home.csdnimg.cn/images/20210720083331.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)
![txt](https://img-home.csdnimg.cn/images/20210720083642.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
收起资源包目录
![package](https://csdnimg.cn/release/downloadcmsfe/public/img/package.f3fc750b.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
资源评论
![avatar-default](https://csdnimg.cn/release/downloadcmsfe/public/img/lazyLogo2.1882d7f4.png)
![avatar](https://profile-avatar.csdnimg.cn/default.jpg!1)
dilacxnoa
- 粉丝: 4
- 资源: 8
上传资源 快速赚钱
我的内容管理 展开
我的资源 快来上传第一个资源
我的收益
登录查看自己的收益我的积分 登录查看自己的积分
我的C币 登录后查看C币余额
我的收藏
我的下载
下载帮助
![voice](https://csdnimg.cn/release/downloadcmsfe/public/img/voice.245cc511.png)
![center-task](https://csdnimg.cn/release/downloadcmsfe/public/img/center-task.c2eda91a.png)
安全验证
文档复制为VIP权益,开通VIP直接复制
![dialog-icon](https://csdnimg.cn/release/downloadcmsfe/public/img/green-success.6a4acb44.png)