协作空间 SQL 表

简介

ONLYOFFICE 协作空间数据库的所有必要信息都存储在表中。

下面您可以找到主要的 ONLYOFFICE 协作空间表列表。

描述
通过OAuth的账户连接id, uid, provider, profile, linked
除授权外的用户操作日志id, ip, initiator, browser, platform, date, tenant_id, user_id, page, action, description, target
已完成的备份id, tenant_id, is_scheduled, name, storage_type, storage_base_path, storage_path, created_on, expires_on, storage_params, hash, removed
备份计划tenant_id, cron, backups_stored, storage_type, storage_base_path, last_backup_time, storage_params
用户组的允许或禁止操作列表(例如更改个人信息的能力)tenant, subject, action, object, acetype
用户组列表tenant, id, name, categoryid, parentid, sid, removed, last_modified
哈希处理后的设置tenant, id, value, last_modified
用户列表tenant, id, username, firstname, lastname, sex, bithdate, status, activation_status, email, workfromdate, terminateddate, title, culture, contacts, phone, phone_activation, location, notes, sid, sso_name_id, sso_session_id, removed, create_on, last_modified
向Radicale服务器请求通讯录的用户列表。此表用于避免同时为所有用户更新通讯录tenant_id, user_id
用户的组成员关系tenant, userid, groupid, ref_type, removed, last_modified
用户照片tenant, userid, photo
用户密码tenant, userid, pwdhash, LastModified
地理位置信息id, AddrType, ip_start, ip_end, country, stateprov, district, city, zipcode, latitude, longitude, geoname_id, timezone_offset, timezone_name, processed
新闻动态id, tenant, product, module, author, modified_by, created_date, modified_date, group_id, json, keywords, aggregated_date, context_id
模块中的最新新闻日期last_key, last_date
用户已阅读的模块user_id, timestamp, module, tenant_id
新闻源与用户的关联feed_id, user_id
文件夹路径(例如 files/my/58a22c6f-e835-11ec-a200-d45d64a8bb3etenant_id, right_node, left_node
可转换的格式范围(从哪种格式到哪种格式)input, output
文件列表id, version, version_group, current_version, folder_id, title, content_length, file_status, category, create_by, create_on, modified_by, modified_on, tenant_id, converted_type, comment, changes, encrypted, forcesave, thumb
文件夹列表id, parent_id, title, folder_type, create_by, create_on, modified_by, modified_on, tenant_id, foldersCount, filesCount, private, has_logo
文件夹树状结构folder_id, parent_id, level
表单与其正在填写的文档之间的连接source_id, linked_id, linked_for, tenant_id
表单中的可填写字段tenant_id, entry_id, data
文档安全性,决定谁可以访问文件以及访问类型tenant_id, entry_id, entry_type, subject, subject_type, owner, security, timestamp, options
文档标签列表id, name, owner, flag, tenant_id
标签与文档之间的关联tenant_id, tag_id, entry_type, entry_id, create_by, create_on, tag_count
已连接的第三方驱动器id, provider, customer_title, user_name, password, token, user_id, folder_type, room_type, create_on, url, tenant_id, folder_id, private, has_logo
已连接的第三方驱动器(在浏览器插件中使用)user_id, app, token, tenant_id, modified_on
第三方驱动器中文档 ID 与哈希处理后的 ID 的关联hash_id, id, tenant_id
主备托管服务instance_registration_id, last_updated, worker_type_name, is_active
与授权事件相关的用户操作日志id, ip, login, browser, platform, date, tenant_id, user_id, page, action, description, active
有关发送消息的信息notify_id, state, attempts, modify_date, priority
用于发送消息的队列notify_id, tenant_id, sender, reciever, subject, content_type, content, sender_type, reply_to, creation_date, attachments, auto_submitted
Telegram 连接portal_user_id, tenant_id, telegram_user_id
被禁止的租户address
租户可用的地址列表id, tenant, ip, for_admin
父租户tenant_id, partner_id, affiliate_id, campaign
租户配额(可用功能、价格等)tenant, name, description, features, price, product_id, visible
租户已使用空间的大小tenant, path, counter, tag, last_modified, user_id
租户资费id, tenant, stamp, customer_id, comment, create_on
租户列表id, name, alias, mappeddomain, version, version_changed, language, timezone, trusteddomains, trusteddomainsenabled, status, statuschanged, creationdatetime, owner_id, payment_id, industry, last_modified, spam, calls
Webhooks 的设置id, name, secret_key, tenant_id, uri, enabled
Webhooks 的日志id, config_id, creation_time, webhook_id, request_headers, request_payload, response_headers, response_payload, status, tenant_id, uid, delivery
用于 ElasticSearch 的 Webstudio 索引index_name, last_modified
Webstudio 设置TenantID, ID, UserID, Data
用户对模块的访问情况tenantid, visitdate, productid, userid, visitcount, firstvisittime, lastvisittime

在您自己的服务器上托管 ONLYOFFICE 文档,或在云端使用

文章: 标签:
浏览所有标签