Database Values

The following is a description of the various database tables and attributes. (This document is not yet complete).

accesstokens

Generated user access tokens for accessing the API.

appcontent

Instance-level dynamic content, usually created via the admin dashboard, such as the About and Privacy pages.

appmigrations

All database migrations that have been run on this database.

collectionattributes

Used for additional properties on collections.

collectionkeys

Public / private keypairs for all collections on the instance. Used to sign ActivityPub / fediverse requests.

collectionpasswords

Salted and hashed passwords for password-protected collections.

collectionredirects

Data about former aliases for collections that have had them changed, so that the old alias redirects visitors to the new one.

collections

Table that contains collections (i.e. “Blogs”).

posts

Table that contains data for posts within collections.

remotefollows

Data about which remote, i.e. ActivityPub / fediverse, users are following which collections.

remoteuserkeys

Public keys of all remote users.

remoteusers

Data needed to communicate with remote users.

userattributes

Additional attributes on users.

userinvites

User invite codes and metadata.

users

Table that contains user data.

usersinvited

Data about which users were brought in by which user-invite.