| Table | Description |
|---|
| abook | connections of local channels |
| account | service provider account |
| addon | registered plugins |
| app | personal app data |
| attach | file attachments |
| auth_codes | OAuth usage |
| cache | OEmbed cache |
| channel | local channels |
| chat | chat room content |
| chatpresence | channel presence information for chat |
| chatroom | data for the actual chat room |
| clients | OAuth usage |
| config | main configuration storage |
| conv | Diaspora private messages meta conversation structure |
| event | Events |
| fcontact | friend suggestion stuff (obsolete) |
| ffinder | friend suggestion stuff (obsolete) |
| fserver | obsolete |
| fsuggest | friend suggestion stuff (unused) |
| group_member | privacy groups (collections), group info |
| groups | privacy groups (collections), member info |
| hook | plugin hook registry |
| hubloc | Red location storage, ties a hub location to an xchan |
| issue | future bug/issue database |
| item | all posts and webpages |
| item_id | other identifiers on other services for posts |
| likes | likes of 'things' |
| mail | private messages |
| manage | may be unused in Red, table of accounts that can "su" each other |
| menu | webpage menu data |
| menu_item | entries for webpage menus |
| notify | notifications |
| obj | object data for things (x has y) |
| outq | Red output queue |
| pconfig | personal (per channel) configuration storage |
| photo | photo storage |
| poll | data for polls |
| poll_elm | data for poll elements |
| profdef | custom profile field definitions |
| profext | custom profile field data |
| profile | channel profiles |
| profile_check | DFRN remote auth use, may be obsolete |
| register | registrations requiring admin approval |
| session | web session storage |
| shares | shared item information |
| sign | Diaspora signatures. To be phased out. |
| site | site table to find directory peers |
| source | channel sources data |
| spam | unfinished |
| sys_perms | extensible permissions for OAuth |
| term | item taxonomy (categories, tags, etc.) table |
| tokens | OAuth usage |
| updates | directory sync updates |
| verify | general purpose verification structure |
| vote | vote data for polls |
| xchan | list of known channels in the universe |
| xchat | bookmarked chat rooms |
| xconfig | as pconfig but for channels with no local account |
| xign | channels ignored by friend suggestions |
| xlink | "friends of friends" linkages derived from poco, also ratings storage |
| xprof | if this hub is a directory server, contains basic public profile info of everybody in the network |
| xtag | if this hub is a directory server, contains tags or interests of everybody in the network |