doc/database.md

   1 Database Tables
   2 ===============
   3
   4 * [Home](help)
   5
   6 | Table                                                | Description                                      |
   7 |------------------------------------------------------|--------------------------------------------------|
   8 | [addon](help/database/db_addon)                      | registered addons                               |
   9 | [attach](help/database/db_attach)                    | file attachments                                 |
  10 | [auth_codes](help/database/db_auth_codes)            | OAuth usage                                      |
  11 | [cache](help/database/db_cache)                      | OEmbed cache                                     |
  12 | [challenge](help/database/db_challenge)              |                                                  |
  13 | [clients](help/database/db_clients)                  | OAuth usage                                      |
  14 | [config](help/database/db_config)                    | main configuration storage                       |
  15 | [contact](help/database/db_contact)                  | contact table                                    |
  16 | [conv](help/database/db_conv)                        | private messages                                 |
  17 | [conversation](help/database/db_conversation)        | Raw data and structure information for messages  |
  18 | [event](help/database/db_event)                      | Events                                           |
  19 | [fcontact](help/database/db_fcontact)                | friend suggestion stuff                          |
  20 | [fsuggest](help/database/db_fsuggest)                | friend suggestion stuff                          |
  21 | [gcign](help/database/db_gcign)                      | contacts ignored by friend suggestions           |
  22 | [gcontact](help/database/db_gcontact)                | global contacts                                  |
  23 | [glink](help/database/db_glink)                      | "friends of friends" linkages derived from poco  |
  24 | [group](help/database/db_group)                      | privacy groups, group info                       |
  25 | [group_member](help/database/db_group_member)        | privacy groups, member info                      |
  26 | [gserver](help/database/db_gserver)                  |                                                  |
  27 | [hook](help/database/db_hook)                        | addon hook registry                             |
  28 | [intro](help/database/db_intro)                      |                                                  |
  29 | [item](help/database/db_item)                        | all posts                                        |
  30 | [locks](help/database/db_locks)                      |                                                  |
  31 | [mail](help/database/db_mail)                        | private messages                                 |
  32 | [mailacct](help/database/db_mailacct)                |                                                  |
  33 | [manage](help/database/db_manage)                    | table of accounts that can "su" each other       |
  34 | [notify](help/database/db_notify)                    | notifications                                    |
  35 | [notify-threads](help/database/db_notify-threads)    |                                                  |
  36 | [oembed](help/database/db_oembed)                    | cache for OEmbed queries                         |
  37 | [parsed_url](help/database/db_parsed_url)            | cache for "parse_url" queries                    |
  38 | [participation](help/database/db_participation)      | Storage for participation messages from Diaspora |
  39 | [pconfig](help/database/db_pconfig)                  | personal (per user) configuration storage        |
  40 | [photo](help/database/db_photo)                      | photo storage                                    |
  41 | [poll](help/database/db_poll)                        | data for polls                                   |
  42 | [poll_result](help/database/db_poll_result)          | data for poll elements                           |
  43 | [profile](help/database/db_profile)                  | user profiles data                               |
  44 | [profile_check](help/database/db_profile_check)      | DFRN remote auth use                             |
  45 | [push_subscriber](help/database/db_push_subscriber)  |                                                  |
  46 | [queue](help/database/db_queue)                      |                                                  |
  47 | [register](help/database/db_register)                | registrations requiring admin approval           |
  48 | [search](help/database/db_search)                    |                                                  |
  49 | [session](help/database/db_session)                  | web session storage                              |
  50 | [sign](help/database/db_sign)                        | Diaspora signatures                              |
  51 | [term](help/database/db_term)                        | item taxonomy (categories, tags, etc.) table     |
  52 | [thread](help/database/db_thread)                    |                                                  |
  53 | [tokens](help/database/db_tokens)                    | OAuth usage                                      |
  54 | [user](help/database/db_user)                        | local user table                                 |
  55 | [userd](help/database/db_userd)                      |                                                  |
  56 | [workerqueue](help/database/db_workerqueue)          |                                                  |