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 | [group](help/database/db_group)                      | privacy groups, group info                       |
  22 | [group_member](help/database/db_group_member)        | privacy groups, member info                      |
  23 | [gserver](help/database/db_gserver)                  |                                                  |
  24 | [hook](help/database/db_hook)                        | addon hook registry                             |
  25 | [intro](help/database/db_intro)                      |                                                  |
  26 | [item](help/database/db_item)                        | all posts                                        |
  27 | [locks](help/database/db_locks)                      |                                                  |
  28 | [mail](help/database/db_mail)                        | private messages                                 |
  29 | [mailacct](help/database/db_mailacct)                |                                                  |
  30 | [manage](help/database/db_manage)                    | table of accounts that can "su" each other       |
  31 | [notify](help/database/db_notify)                    | notifications                                    |
  32 | [notify-threads](help/database/db_notify-threads)    |                                                  |
  33 | [oembed](help/database/db_oembed)                    | cache for OEmbed queries                         |
  34 | [parsed_url](help/database/db_parsed_url)            | cache for "parse_url" queries                    |
  35 | [pconfig](help/database/db_pconfig)                  | personal (per user) configuration storage        |
  36 | [photo](help/database/db_photo)                      | photo storage                                    |
  37 | [poll](help/database/db_poll)                        | data for polls                                   |
  38 | [poll_result](help/database/db_poll_result)          | data for poll elements                           |
  39 | [profile](help/database/db_profile)                  | user profiles data                               |
  40 | [profile_check](help/database/db_profile_check)      | DFRN remote auth use                             |
  41 | [push_subscriber](help/database/db_push_subscriber)  |                                                  |
  42 | [queue](help/database/db_queue)                      |                                                  |
  43 | [register](help/database/db_register)                | registrations requiring admin approval           |
  44 | [search](help/database/db_search)                    |                                                  |
  45 | [session](help/database/db_session)                  | web session storage                              |
  46 | [sign](help/database/db_sign)                        | Diaspora signatures                              |
  47 | [term](help/database/db_term)                        | item taxonomy (categories, tags, etc.) table     |
  48 | [thread](help/database/db_thread)                    |                                                  |
  49 | [tokens](help/database/db_tokens)                    | OAuth usage                                      |
  50 | [user](help/database/db_user)                        | local user table                                 |
  51 | [userd](help/database/db_userd)                      |                                                  |
  52 | [workerqueue](help/database/db_workerqueue)          |                                                  |