Database tables and columns

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

fs_abholer

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

fs_abholzeiten

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

fs_bezirk

describes the regions

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

fs_foodsaver

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

fs_foodsaver_has_bezirk

describes which foodsaver is in which workgroups and regions

anything with theme

theme are threads in the forum.