Skip to main content
Version: 2022-05__Heidelbeere

Database tables and columns

Since tables are sorted alphabetically in phpmyadmin, sort them here alphabetically:


  • decribes who fetches when where and if confirmed
  • confirmed 1, not yet confirmed 0


Contains information about regurlary reoccuring pickup slots. Additional single pickup slots are stored in #TODO: find table. The columns to be described are

columndescriptionpossible values
dowday of week1 = Monday, 0 = Sunday
timewhen on the day the pickup istime
fetchernumber of slots>= 0, >= 1 enforced by frontend


describes the regions

  • type: description in src\Modules\Core\DBConstants\Region\Type


  • deleted_at: deletion day of account, if NULL, account is active


describes which foodsaver is in which workgroups and regions

anything with theme

theme are threads in the forum.