====== Database Tables ====== ^Table ^Description ^ |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_2fa_app_specific_password.md|2fa_app_specific_password]]|Two-factor app-specific _password | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_2fa_recovery_codes.md|2fa_recovery_codes]] |Two-factor authentication recovery codes | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_2fa_trusted_browser.md|2fa_trusted_browser]] |Two-factor authentication trusted browsers | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_addon.md|addon]] |registered addons | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_apcontact.md|apcontact]] |ActivityPub compatible contacts - used in the ActivityPub implementation| |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_application.md|application]] |OAuth application | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_application-marker.md|application-marker]] |Timeline marker | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_application-token.md|application-token]] |OAuth user token | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_attach.md|attach]] |file attachments | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_cache.md|cache]] |Stores temporary data | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_config.md|config]] |main configuration storage | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_contact.md|contact]] |contact table | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_contact-relation.md|contact-relation]] |Contact relations | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_conv.md|conv]] |private messages | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_conversation.md|conversation]] |Raw data and structure information for messages | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_delayed-post.md|delayed-post]] |Posts that are about to be distributed at a later time | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_diaspora-interaction.md|diaspora-interaction]] |Signed Diaspora Interaction | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_endpoint.md|endpoint]] |ActivityPub endpoints - used in the ActivityPub implementation | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_event.md|event]] |Events | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_fcontact.md|fcontact]] |Diaspora compatible contacts - used in the Diaspora implementation | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_fsuggest.md|fsuggest]] |friend suggestion stuff | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_group.md|group]] |privacy groups, group info | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_group_member.md|group_member]] |privacy groups, member info | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_gserver.md|gserver]] |Global servers | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_gserver-tag.md|gserver-tag]] |Tags that the server has subscribed | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_hook.md|hook]] |addon hook registry | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_inbox-status.md|inbox-status]] |Status of ActivityPub inboxes | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_intro.md|intro]] | | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_item-uri.md|item-uri]] |URI and GUID for items | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_locks.md|locks]] | | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_mail.md|mail]] |private messages | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_mailacct.md|mailacct]] |Mail account data for fetching mails | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_manage.md|manage]] |table of accounts that can manage each other | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_notification.md|notification]] |notifications | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_notify.md|notify]] |[Deprecated] User notifications | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_notify-threads.md|notify-threads]] | | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_oembed.md|oembed]] |cache for OEmbed queries | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_openwebauth-token.md|openwebauth-token]] |Store OpenWebAuth token to verify contacts | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_parsed_url.md|parsed_url]] |cache for ‘parse_url’ queries | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_pconfig.md|pconfig]] |personal (per user) configuration storage | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_permissionset.md|permissionset]] | | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_photo.md|photo]] |photo storage | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_post.md|post]] |Structure for all posts | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_post-category.md|post-category]] |post relation to categories | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_post-collection.md|post-collection]] |Collection of posts | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_post-content.md|post-content]] |Content for all posts | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_post-delivery.md|post-delivery]] |Delivery data for posts for the batch processing | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_post-delivery-data.md|post-delivery-data]] |Delivery data for items | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_post-history.md|post-history]] |Post history | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_post-link.md|post-link]] |Post related external links | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_post-media.md|post-media]] |Attached media | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_post-question.md|post-question]] |Question | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_post-question-option.md|post-question-option]] |Question option | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_post-tag.md|post-tag]] |post relation to tags | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_post-thread.md|post-thread]] |Thread related data | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_post-thread-user.md|post-thread-user]] |Thread related data per user | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_post-user.md|post-user]] |User specific post data | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_post-user-notification.md|post-user-notification]] |User post notifications | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_process.md|process]] |Currently running system processes | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_profile.md|profile]] |user profiles data | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_profile_field.md|profile_field]] |Custom profile fields | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_push_subscriber.md|push_subscriber]] |Used for OStatus: Contains feed subscribers | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_register.md|register]] |registrations requiring admin approval | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_search.md|search]] | | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_session.md|session]] |web session storage | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_storage.md|storage]] |Data stored by Database storage backend | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_subscription.md|subscription]] |Push Subscription for the API | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_tag.md|tag]] |tags and mentions | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_user.md|user]] |The local users | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_user-contact.md|user-contact]] |User specific public contact data | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_userd.md|userd]] |Deleted usernames | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_verb.md|verb]] |Activity Verbs | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_worker-ipc.md|worker-ipc]] |Inter process communication between the frontend and the worker | |[[https://git.friendi.ca/friendica/friendica/src/branch/develop/doc/database/db_workerqueue.md|workerqueue]] |Background tasks queue entries |