Merge remote-tracking branch 'upstream/develop' into 1604-cookie

[friendica.git] / doc / database.md

Database Tables
===============

* [Home](help)

| Table                                                | Description                                      |
|------------------------------------------------------|--------------------------------------------------|
| [addon](help/database/db_addon)                      | registered plugins                               |
| [attach](help/database/db_attach)                    | file attachments                                 |
| [auth_codes](help/database/db_auth_codes)            | OAuth usage                                      |
| [cache](help/database/db_cache)                      | OEmbed cache                                     |
| [challenge](help/database/db_challenge)              |                                                  |
| [clients](help/database/db_clients)                  | OAuth usage                                      |
| [config](help/database/db_config)                    | main configuration storage                       |
| [contact](help/database/db_contact)                  | contact table                                    |
| [conv](help/database/db_conv)                        | private messages                                 |
| [deliverq](help/database/db_deliverq)                |                                                  |
| [event](help/database/db_event)                      | Events                                           |
| [fcontact](help/database/db_fcontact)                | friend suggestion stuff                          |
| [ffinder](help/database/db_ffinder)                  | friend suggestion stuff                          |
| [fserver](help/database/db_fserver)                  |                                                  |
| [fsuggest](help/database/db_fsuggest)                | friend suggestion stuff                          |
| [gcign](help/database/db_gcign)                      | contacts ignored by friend suggestions           |
| [gcontact](help/database/db_gcontact)                | global contacts                                  |
| [glink](help/database/db_glink)                      | "friends of friends" linkages derived from poco  |
| [group](help/database/db_group)                      | privacy groups, group info                       |
| [group_member](help/database/db_group_member)        | privacy groups, member info                      |
| [gserver](help/database/db_gserver)                  |                                                  |
| [hook](help/database/db_hook)                        | plugin hook registry                             |
| [intro](help/database/db_intro)                      |                                                  |
| [item](help/database/db_item)                        | all posts                                        |
| [item_id](help/database/db_item_id)                  | other identifiers on other services for posts    |
| [locks](help/database/db_locks)                      |                                                  |
| [mail](help/database/db_mail)                        | private messages                                 |
| [mailacct](help/database/db_mailacct)                |                                                  |
| [manage](help/database/db_manage)                    | table of accounts that can "su" each other       |
| [notify](help/database/db_notify)                    | notifications                                    |
| [notify-threads](help/database/db_notify-threads)    |                                                  |
| [oembed](help/database/db_oembed)                    | cache for OEmbed queries                         |
| [parsed_url](help/database/db_parsed_url)            | cache for "parse_url" queries                    |
| [pconfig](help/database/db_pconfig)                  | personal (per user) configuration storage        |
| [photo](help/database/db_photo)                      | photo storage                                    |
| [poll](help/database/db_poll)                        | data for polls                                   |
| [poll_result](help/database/db_poll_result)          | data for poll elements                           |
| [profile](help/database/db_profile)                  | user profiles data                               |
| [profile_check](help/database/db_profile_check)      | DFRN remote auth use                             |
| [push_subscriber](help/database/db_push_subscriber)  |                                                  |
| [queue](help/database/db_queue)                      |                                                  |
| [register](help/database/db_register)                | registrations requiring admin approval           |
| [search](help/database/db_search)                    |                                                  |
| [session](help/database/db_session)                  | web session storage                              |
| [sign](help/database/db_sign)                        | Diaspora signatures                              |
| [spam](help/database/db_spam)                        | unfinished                                       |
| [term](help/database/db_term)                        | item taxonomy (categories, tags, etc.) table     |
| [thread](help/database/db_thread)                    |                                                  |
| [tokens](help/database/db_tokens)                    | OAuth usage                                      |
| [user](help/database/db_user)                        | local user table                                 |
| [userd](help/database/db_userd)                      |                                                  |
| [workerqueue](help/database/db_workerqueue)          |                                                  |