| 2fa_app_specific_password |
Two-factor app-specific _password |
| 2fa_recovery_codes |
Two-factor authentication recovery codes |
| 2fa_trusted_browser |
Two-factor authentication trusted browsers |
| account-suggestion |
Account suggestion |
| account-user |
Remote and local accounts |
| apcontact |
ActivityPub compatible contacts - used in the ActivityPub implementation |
| application |
OAuth application |
| application-marker |
Timeline marker |
| application-token |
OAuth user token |
| arrived-activity |
Id of arrived activities |
| attach |
file attachments |
| cache |
Stores temporary data |
| channel |
User defined Channels |
| check-full-text-search |
Check for a full text search match in user defined channels before storing the message in the system |
| config |
main configuration storage |
| contact |
contact table |
| contact-relation |
Contact relations |
| conv |
private messages |
| delayed-post |
Posts that are about to be distributed at a later time |
| delivery-queue |
Delivery data for posts for the batch processing |
| diaspora-contact |
Diaspora compatible contacts - used in the Diaspora implementation |
| diaspora-interaction |
Signed Diaspora Interaction |
| endpoint |
ActivityPub endpoints - used in the ActivityPub implementation |
| event |
Events |
| fetch-entry |
|
| fetched-activity |
Id of fetched activities |
| fsuggest |
friend suggestion stuff |
| group |
privacy circles, circle info |
| group_member |
privacy circles, member info |
| gserver |
Global servers |
| gserver-tag |
Tags that the server has subscribed |
| hook |
addon hook registry |
| inbox-entry |
Incoming activity |
| inbox-entry-receiver |
Receiver for the incoming activity |
| inbox-status |
Status of ActivityPub inboxes |
| intro |
|
| item-uri |
URI and GUID for items |
| key-value |
A key value storage |
| locks |
|
| mail |
private messages |
| mailacct |
Mail account data for fetching mails |
| manage |
table of accounts that can manage each other |
| notification |
notifications |
| notify |
[Deprecated] User notifications |
| notify-threads |
|
| oembed |
cache for OEmbed queries |
| openwebauth-token |
Store OpenWebAuth token to verify contacts |
| parsed_url |
cache for 'parse_url' queries |
| pconfig |
personal (per user) configuration storage |
| permissionset |
|
| photo |
photo storage |
| post |
Structure for all posts |
| post-activity |
Original remote activity |
| post-category |
post relation to categories |
| post-collection |
Collection of posts |
| post-content |
Content for all posts |
| post-counts |
Original remote activity |
| post-delivery |
Delivery data for posts for the batch processing |
| post-delivery-data |
Delivery data for items |
| post-engagement |
Engagement data per post |
| post-history |
Post history |
| post-link |
Post related external links |
| post-media |
Attached media |
| post-question |
Question |
| post-question-option |
Question option |
| post-searchindex |
Content for all posts |
| post-tag |
post relation to tags |
| post-thread |
Thread related data |
| post-thread-user |
Thread related data per user |
| post-user |
User specific post data |
| post-user-notification |
User post notifications |
| process |
Currently running system processes |
| profile |
user profiles data |
| profile_field |
Custom profile fields |
| push_subscriber |
Used for OStatus: Contains feed subscribers |
| register |
registrations requiring admin approval |
| report |
|
| report-post |
Individual posts attached to a moderation report |
| report-rule |
Terms of service rule lines relevant to a moderation report |
| search |
|
| session |
web session storage |
| storage |
Data stored by Database storage backend |
| subscription |
Push Subscription for the API |
| tag |
tags and mentions |
| user |
The local users |
| user-contact |
User specific public contact data |
| user-gserver |
User settings about remote servers |
| userd |
Deleted usernames |
| verb |
Activity Verbs |
| worker-ipc |
Inter process communication between the frontend and the worker |
| workerqueue |
Background tasks queue entries |