Database structure

This page is automatically generated and can be manually generated with database scripts.

Introduction

This documentation is automatically generated by information from MySQL and the PHP code.

The documentation inform you as developer about the database structure and column meaning. Additional for the development of new API or backend parts, the module table usage (extracted from PHP codebase) below provides helpful information. The provided information may help to find already existing queries, gateways, and/or the best location for a new query/function.

Open todos are listed in https://gitlab.com/foodsharing-dev/foodsharing/-/work_items/2524

• List of tables
• Structure of tables
• Usage of table in PHP Modules

List of tables

• configuration
• fs_abholer
• fs_abholzeiten
• fs_achievement
• fs_answer
• fs_apitoken
• fs_basket
• fs_basket_anfrage
• fs_bell
• fs_betrieb
• fs_betrieb_has_lebensmittel
• fs_betrieb_kategorie
• fs_betrieb_notiz
• fs_betrieb_team
• fs_bezirk
• fs_bezirk_closure
• fs_bezirk_has_theme
• fs_bezirk_has_wallpost
• fs_blog_entry
• fs_botschafter
• fs_buddy
• fs_chain
• fs_contact
• fs_content
• fs_conversation
• fs_email_blacklist
• fs_email_bounces
• fs_event
• fs_event_has_wallpost
• fs_fairteiler
• fs_fairteiler_follower
• fs_fairteiler_has_wallpost
• fs_feature_toggles
• fs_fetchdate
• fs_fetchweight
• fs_foodsaver
• fs_foodsaver_archive
• fs_foodsaver_change_history
• fs_foodsaver_has_achievement
• fs_foodsaver_has_bell
• fs_foodsaver_has_bezirk
• fs_foodsaver_has_contact
• fs_foodsaver_has_conversation
• fs_foodsaver_has_event
• fs_foodsaver_has_favorite_resource
• fs_foodsaver_has_options
• fs_foodsaver_has_poll
• fs_foodsaver_has_wallpost
• fs_fsreports_has_wallpost
• fs_group_category
• fs_key_account_manager
• fs_lebensmittel
• fs_location
• fs_mailbox
• fs_mailbox_member
• fs_mailbox_message
• fs_mailchange
• fs_msg
• fs_pass_gen
• fs_pass_request
• fs_poll
• fs_poll_has_options
• fs_poll_option_has_value
• fs_post_reaction
• fs_push_notification_subscription
• fs_question
• fs_question_has_quiz
• fs_question_has_wallpost
• fs_quiz
• fs_quiz_session
• fs_rating
• fs_region_function
• fs_region_options
• fs_region_pin
• fs_region_statistics
• fs_registration_attempt
• fs_report
• fs_resource
• fs_resource_category
• fs_resource_has_category
• fs_store_has_wallpost
• fs_store_log
• fs_theme
• fs_theme_follower
• fs_theme_post
• fs_usernotes_has_wallpost
• fs_verify_history
• fs_wallpost
• fs_wall_post_reaction
• fs_webauthn_credentials
• oauth_access_tokens
• oauth_auth_codes
• oauth_clients
• oauth_refresh_tokens
• oauth_user_consents
• phinxlog
• uploads

Structure of tables

Table configuration

Description - configuration

Table columns - configuration

Column	Description	Type	properties
key		varchar(50)	Primary Key
value		varchar(1000)
category	Optional category of the key-value pair	unsigned int	Nullable

Table fs_abholer

Description - fs_abholer

Stores filled pickup slots, describes by who fetches when, where and if confirmed, needed to generate statistics (count, but not weight).

Table columns - fs_abholer

Column	Description	Type	properties
foodsaver_id		unsigned int	foreign key (fs_foodsaver:id)
betrieb_id		unsigned int	foreign key (fs_betrieb:id)
date		datetime
confirmed	1: Confirmed, 0: Not confirmed	unsigned tinyint=0
id		unsigned int	Primary Key, Auto-Increment

Table fs_abholzeiten

Description - fs_abholzeiten

Contains information about regurlary occuring pickup slots.

Table columns - fs_abholzeiten

Column	Description	Type	properties
betrieb_id		unsigned int	Primary Key, foreign key (fs_betrieb:id)
dow	Day of week (1=Monday, 0=Sunday)	unsigned tinyint	Primary Key
time	Time when on the day the pickup is	time='00:00:00'	Primary Key
fetcher	Number of slots (> 0, limited by frontend currently 8)	unsigned tinyint=4
description	optional description for this pickup time	varchar(100)	Nullable

Table fs_achievement

Description - fs_achievement

Table columns - fs_achievement

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
region_id	region defining the scope in which this achievement is relevant	unsigned int	foreign key (fs_bezirk:id)
name		varchar(255)
description		varchar(255)
validity_in_days_after_assignment		int	Nullable
created_at		timestamp=current_timestamp()
updated_at		timestamp	Nullable
icon	the icon to display this achievement with	varchar(100)	Nullable
visibility_type		unsigned tinyint=2
duplicate_mode		unsigned tinyint=0

Table fs_answer

Description - fs_answer

Stores answers to quizzes

Table columns - fs_answer

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
question_id		unsigned int	foreign key (fs_question:id)
text		mediumtext(16777215)	Nullable
explanation		mediumtext(16777215)
right		unsigned tinyint	Nullable

Table fs_apitoken

Description - fs_apitoken

User tokens for ICS/ICAL/WebCal access to calendar of future events/pickups.

Table columns - fs_apitoken

Column	Description	Type	properties
foodsaver_id	Owner of the token and identifier for the calendar	unsigned int	foreign key (fs_foodsaver:id)
token	Access token, hex-number from openssl.	varchar(255)

Table fs_basket

Description - fs_basket

Lists all food baskets.

Table columns - fs_basket

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
foodsaver_id		unsigned int	foreign key (fs_foodsaver:id)
status	@Basket::Status	unsigned tinyint	Nullable
time	Creation datetime	datetime	Nullable
update		datetime	Nullable
until	Basket is present until datetime expires	datetime
fetchtime		datetime	Nullable
description		mediumtext(16777215)	Nullable
picture		text(65535)	Nullable
tel		varchar(50)=''
handy		varchar(50)=''
contact_type		varchar(20)='1'
location_type	Fix set to 0	unsigned tinyint	Nullable
weight	Smaller <0kg = 3kg	float(12)	Nullable
lat	Basket location latitude	float(10)(6)=0.000000
lon	Basket location longitude	float(10)(6)=0.000000
bezirk_id		unsigned int	Weak-foreign key (fs_bezirk:id)
appost		tinyint=0

Table fs_basket_anfrage

Description - fs_basket_anfrage

Lists foodbasket requests.

Table columns - fs_basket_anfrage

Column	Description	Type	properties
foodsaver_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
basket_id		unsigned int	Primary Key, foreign key (fs_basket:id)
status	@RequestsBasket::Status	unsigned tinyint	Nullable
time		datetime
appost		tinyint=0

Table fs_bell

Description - fs_bell

Stores arbitrary notifications

Table columns - fs_bell

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
name		varchar(50)	Nullable
body		varchar(50)	Nullable
vars		mediumtext(16777215)	Nullable
attr		varchar(500)	Nullable
icon		varchar(150)	Nullable
identifier	@Bell::Type	varchar(40)	Nullable
time		datetime
closeable		unsigned tinyint=1
expiration		date	Nullable

Table fs_betrieb

Description - fs_betrieb

Stores stores.

Table columns - fs_betrieb

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
betrieb_status_id	@Status::CooperationStatus	unsigned int
bezirk_id		unsigned int	foreign key (fs_bezirk:id)
added		date
plz		varchar(10)
stadt		varchar(50)
lat		varchar(20)	Nullable
lon		varchar(20)	Nullable
kette_id		unsigned int	foreign key (fs_chain:id), Nullable
betrieb_kategorie_id		unsigned int	foreign key (fs_betrieb_kategorie:id), Nullable
name		varchar(120)	Nullable
str		varchar(120)	Nullable
status_date		date	Nullable
status		unsigned tinyint	Nullable
ansprechpartner		varchar(60)	Nullable
telefon		varchar(50)	Nullable
fax		varchar(50)	Nullable
email		varchar(60)	Nullable
begin		date	Nullable
besonderheiten		mediumtext(16777215)	Nullable
public_info		varchar(535)	Nullable
public_time	@Store::PublicTimes	tinyint
ueberzeugungsarbeit	@Store::ConvinceStatus	tinyint
presse	Yes=0; No=1	tinyint
sticker	Yes=0; No=1	tinyint
abholmenge	See @WeightHelper	tinyint
team_status	0 = Team Voll; 1 = Es werden noch Helfer gesucht; 2 = Es werden dringend Helfer gesucht	tinyint=0
prefetchtime	Frequence of expected regular pickups in seconds	unsigned int=1209600
team_conversation_id		unsigned int	foreign key (fs_conversation:id)
springer_conversation_id		unsigned int	foreign key (fs_conversation:id)
deleted_at		datetime	Nullable
use_region_pickup_rule	[@StoreSettings::USE](https://gitlab.com/foodsharing-dev/foodsharing/-/tree/master/src/Modules/Core/DBConstants/StoreSettings/USE.php)_PICKUP_RULE_YES = Store follows region pickup rule. @StoreSettings::USE_PICKUP_RULE_NO = Store does not follow region pickup rule.	unsigned int=0
hygiene_requirement		unsigned tinyint
verified_requirement		unsigned tinyint=1
phone_requirement		unsigned tinyint=0
apply_text_requirement		unsigned tinyint=1

Table fs_betrieb_has_lebensmittel

Description - fs_betrieb_has_lebensmittel

Table columns - fs_betrieb_has_lebensmittel

Column	Description	Type	properties
betrieb_id		unsigned int	Primary Key
lebensmittel_id		unsigned int	Primary Key

Table fs_betrieb_kategorie

Description - fs_betrieb_kategorie

Table columns - fs_betrieb_kategorie

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
name		varchar(50)	Nullable
type	Type of the category: 0 = pickup, 1 = giving, 2 = orga	unsigned tinyint=0

Table fs_betrieb_notiz

Description - fs_betrieb_notiz

Stores wallposts on stores (independent of wallpost system)

Table columns - fs_betrieb_notiz

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
foodsaver_id		unsigned int
betrieb_id		unsigned int
milestone		unsigned tinyint=0
text		mediumtext(16777215)	Nullable
zeit		datetime	Nullable
last		tinyint=0

Table fs_betrieb_team

Description - fs_betrieb_team

Assigns team members to stores including their statistics.

Table columns - fs_betrieb_team

Column	Description	Type	properties
foodsaver_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
betrieb_id		unsigned int	Primary Key, foreign key (fs_betrieb:id)
verantwortlich	@StoreTeam::Responsible	unsigned tinyint=0	Nullable
active	@StoreTeam::MembershipStatus	int=0
stat_last_update		datetime	Nullable
stat_fetchcount		unsigned int
stat_first_fetch		date	Nullable
stat_last_fetch		date	Nullable
stat_add_date		date	Nullable

Table fs_bezirk

Description - fs_bezirk

Stores districts as well as working groups (differentiated by type column) (referred to as 'group' or 'district' in this document)

Table columns - fs_bezirk

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
parent_id		unsigned int=0	foreign key (fs_bezirk:id), Nullable
has_children	Is set when ID is set in parent_id of other row	tinyint=0
type	@Unit::UnitType	tinyint=1
teaser		mediumtext(16777215)=''
desc		mediumtext(16777215)=''
photo		varchar(200)=''
master		unsigned int=0
mailbox_id	Id of user related mailbox	unsigned int=0	Weak-foreign key (fs_mailbox:id)
name		varchar(50)	Nullable
email_name		varchar(100)=''
apply_type	Defines join conditions for Working-Groups (@Region::ApplyType)	tinyint=2
stat_last_update		datetime=current_timestamp()
stat_fetchweight		unsigned decimal(12)(2)=0.00
stat_fetchcount		unsigned int=0
stat_postcount		unsigned int=0
stat_betriebcount		unsigned int=0
stat_korpcount		unsigned int=0
stat_botcount		unsigned int=0
stat_fscount		unsigned int=0
stat_fairteilercount		unsigned int=0
moderated	**Unused? Only select found no insert or update ***	tinyint=0
stat_givecount		unsigned int=0
stat_engagecount		unsigned int=0
application_prompt		mediumtext(16777215)	Nullable
category_id		unsigned int	foreign key (fs_group_category:id), Nullable
timezone	IANA timezone; NULL inherits from the closest ancestor (platform default Europe/Berlin)	varchar(64)	Nullable

Table fs_bezirk_closure

Description - fs_bezirk_closure

Table columns - fs_bezirk_closure

Column	Description	Type	properties
bezirk_id		unsigned int	foreign key (fs_bezirk:id)
ancestor_id		unsigned int	foreign key (fs_bezirk:id)
depth		unsigned int

Table fs_bezirk_has_theme

Description - fs_bezirk_has_theme

Forum: Relates threads to groups.

Table columns - fs_bezirk_has_theme

Column	Description	Type	properties
theme_id		unsigned int	Primary Key, foreign key (fs_theme:id)
bezirk_id		unsigned int	Primary Key, foreign key (fs_bezirk:id)
bot_theme		unsigned tinyint=0

Table fs_bezirk_has_wallpost

Description - fs_bezirk_has_wallpost

Relates wallposts to groups. Only relevant for working groups, not for regions.

Table columns - fs_bezirk_has_wallpost

Column	Description	Type	properties
bezirk_id		unsigned int	Primary Key, foreign key (fs_bezirk:id)
wallpost_id		unsigned int	Primary Key, foreign key (fs_wallpost:id)

Table fs_blog_entry

Description - fs_blog_entry

Stores blog entries (there is a /news URL)

Table columns - fs_blog_entry

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
bezirk_id		unsigned int
foodsaver_id		unsigned int	foreign key (fs_foodsaver:id)
active		unsigned tinyint
name		varchar(100)	Nullable
teaser		varchar(500)	Nullable
body		mediumtext(16777215)	Nullable
time		datetime	Nullable
picture		varchar(150)

Table fs_botschafter

Description - fs_botschafter

Notes the ambassador/admin attribute on a group membership.

Table columns - fs_botschafter

Column	Description	Type	properties
foodsaver_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
bezirk_id		unsigned int	Primary Key, foreign key (fs_bezirk:id)

Table fs_buddy

Description - fs_buddy

'I know XY' connection/friendship relation.

Table columns - fs_buddy

Column	Description	Type	properties
foodsaver_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
buddy_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
confirmed	@Buddy::BuddyId	unsigned tinyint	Nullable

Table fs_chain

Description - fs_chain

Table columns - fs_chain

Column	Description	Type	properties
id	unique id of the chain	unsigned int	Primary Key, Auto-Increment
name		varchar(120)
headquarters_zip		varchar(5)	Nullable
headquarters_city		varchar(50)	Nullable
status		unsigned int
modification_date		date
allow_press		tinyint=0
forum_thread	id of the chains forum thread	unsigned int	foreign key (fs_theme:id), Nullable
notes	Only visibe in the chain table	varchar(200)	Nullable
common_store_information	Details displayed on store pages	mediumtext(16777215)	Nullable
estimated_store_count		unsigned int=0
headquarters_country		varchar(50)	Nullable

Table fs_contact

Description - fs_contact

Stores email addresses gathered from incoming/outgoing emails that will be used for autocompletion.

Table columns - fs_contact

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
name		varchar(180)	Nullable
email		varchar(180)	Nullable

Table fs_content

Description - fs_content

'Mini-CMS' content table that is used to generate some pages as well as sections on some pages.

Table columns - fs_content

Column	Description	Type	properties
id	@Content::ContentId	unsigned int	Primary Key, Auto-Increment
name		varchar(20)	Nullable
title		varchar(120)	Nullable
body		mediumtext(16777215)	Nullable
last_mod		datetime	Nullable

Table fs_conversation

Description - fs_conversation

Chat conversations

Table columns - fs_conversation

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
locked		tinyint=0
name		varchar(40)	Nullable
last		datetime	Nullable
last_foodsaver_id		unsigned int	foreign key (fs_foodsaver:id), Nullable
last_message_id		unsigned int	foreign key (fs_msg:id), Nullable
last_message		mediumtext(16777215)	Nullable
last_message_is_htmlentity_encoded		tinyint=1

Table fs_email_blacklist

Description - fs_email_blacklist

Contains email addresses that are not allowed to sign up

Table columns - fs_email_blacklist

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
email	Email pattern to block (can include wildcards like @example.com or user@)	varchar(255)
created_at		timestamp=current_timestamp()
reason	Reason or description for blocking this pattern	mediumtext(16777215)	Nullable
active	Whether this blocklist entry is active	tinyint=1
created_by	ID of the admin who created this entry	unsigned int	foreign key (fs_foodsaver:id)
updated_at	Last update timestamp	datetime	Nullable
updated_by	ID of the admin who last updated this entry	unsigned int	foreign key (fs_foodsaver:id), Nullable

Table fs_email_bounces

Description - fs_email_bounces

Table columns - fs_email_bounces

Column	Description	Type	properties
email		varchar(255)
bounced_at		datetime
bounce_category		varchar(255)

Table fs_event

Description - fs_event

Contains all events

Table columns - fs_event

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
foodsaver_id		unsigned int	foreign key (fs_foodsaver:id)
bezirk_id		unsigned int	foreign key (fs_bezirk:id), Nullable
location_id		unsigned int	foreign key (fs_location:id), Nullable
public		tinyint=0
name		varchar(200)	Nullable
start		datetime
end		datetime
description		mediumtext(16777215)	Nullable
bot		unsigned tinyint=0	Nullable
online	@Event::EventType	unsigned tinyint=0	Nullable
is_public		unsigned tinyint

Table fs_event_has_wallpost

Description - fs_event_has_wallpost

Links wallposts to events (only communication channel for an event)

Table columns - fs_event_has_wallpost

Column	Description	Type	properties
event_id		unsigned int	Primary Key, foreign key (fs_event:id)
wallpost_id		unsigned int	Primary Key, foreign key (fs_wallpost:id)

Table fs_fairteiler

Description - fs_fairteiler

Lists food share points

Table columns - fs_fairteiler

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
bezirk_id		unsigned int	foreign key (fs_bezirk:id), Nullable
name		varchar(260)	Nullable
picture		varchar(100)=''
status	@FoodSharePoint::ActivationStatus	unsigned tinyint	Nullable
desc		mediumtext(16777215)	Nullable
anschrift		varchar(260)	Nullable
plz		varchar(5)	Nullable
ort		varchar(100)	Nullable
lat		varchar(100)	Nullable
lon		varchar(100)	Nullable
add_date		date	Nullable
add_foodsaver		unsigned int	foreign key (fs_foodsaver:id), Nullable

Table fs_fairteiler_follower

Description - fs_fairteiler_follower

Links follower/responsible to food share points

Table columns - fs_fairteiler_follower

Column	Description	Type	properties
fairteiler_id		unsigned int	Primary Key, foreign key (fs_fairteiler:id)
foodsaver_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
type	@FoodSharePoint::FollowerType	unsigned tinyint=1
infotype		unsigned tinyint=1

Table fs_fairteiler_has_wallpost

Description - fs_fairteiler_has_wallpost

Links wallposts to food share points

Table columns - fs_fairteiler_has_wallpost

Column	Description	Type	properties
fairteiler_id		unsigned int	Primary Key, foreign key (fs_fairteiler:id)
wallpost_id		unsigned int	Primary Key, foreign key (fs_wallpost:id)

Table fs_feature_toggles

Description - fs_feature_toggles

Table columns - fs_feature_toggles

Column	Description	Type	properties
identifier		varchar(255)	Primary Key
is_active		tinyint=0
site_environment		varchar(255)	Primary Key
created_at		timestamp=current_timestamp()
updated_at		timestamp	Nullable

Table fs_fetchdate

Description - fs_fetchdate

Stores non-recurring pickup slots (just the slot, no fetcher information)

Table columns - fs_fetchdate

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
betrieb_id		unsigned int	foreign key (fs_betrieb:id)
time		datetime	Nullable
fetchercount		unsigned tinyint	Nullable
description	optional description for this pickup	varchar(100)	Nullable

Table fs_fetchweight

Description - fs_fetchweight

Table columns - fs_fetchweight

Column	Description	Type	properties
id		int	Primary Key
weight		decimal(5)(1)

Table fs_foodsaver

Description - fs_foodsaver

Describes the user in the foodsharing system. It contains profile, role and statistics.

Table columns - fs_foodsaver

Column	Description	Type	properties
id	Unique id of user in foodsharing community	unsigned int	Primary Key, Auto-Increment
bezirk_id	Id of home destrict	unsigned int	Weak-foreign key (fs_bezirk:id)
position	Free text description of position in foodsharing community (public visible)	varchar(255)=''
verified	User is verified to by part of the foodsharing community (True: Verified, False: Not verified or lost verification)	unsigned tinyint=0
last_pass	Last generation of passport	datetime	Nullable
mailbox_id	Id of user related mailbox	unsigned int	Weak-foreign key (fs_mailbox:id), Nullable
rolle	Describes the type of member in the foodsharing community system @Foodsaver::Role	tinyint
plz	Zip code of user home	varchar(10)	Nullable
stadt	City name of user home	varchar(100)	Nullable
lat	Geo position latitude of user home	varchar(20)	Nullable
lon	Geo position longitude of user home	varchar(20)	Nullable
photo	URL to user image ('/api/uploads' '/images/) Path is different depending on upload way	varchar(50)	Nullable
email	E-Mail address which is used for registration and newsletter	varchar(120)	Nullable
password	User login password hash	varchar(100)	Nullable
name	First name of user	varchar(120)	Nullable
nachname	Last name of user	varchar(120)	Nullable
anschrift	Address (street and house number) of user home	varchar(120)	Nullable
telefon	phone number of user	varchar(30)	Nullable
handy	mobile phone number of user	varchar(50)	Nullable
geschlecht	Gender of user (@Foodsaver::Gender)	unsigned tinyint=0
geb_datum	birthday of user	date	Nullable
anmeldedatum	Date of registaration	datetime	Nullable
privacy_notice_accepted_date	Documentation modification date of privacy notice which the user accetped	datetime	Nullable
privacy_policy_accepted_date	Documentation modification date of privacy policy which the user accetped	datetime	Nullable
active	E-Mail activation after registration is completed (True: E-Mail is verified, False: verification e-mail feedback is pending)	unsigned tinyint=0
about_me_public	User provided description text for public accessable parts.	mediumtext(16777215)=''
token	Verification code which is send to user during registration	varchar(100)
infomail_message	True if the user have subscription for info mails like chat notifications.	tinyint	Nullable
last_login	Timestamp of the last successful login.	datetime	Nullable
stat_fetchweight	Fetch weight in kg	unsigned decimal(9)(2)=0.00
stat_fetchcount	Count of fetches the user have confirmed in total.	unsigned int=0
stat_ratecount	Unused	unsigned int=0
stat_rating	Unused	unsigned decimal(4)(2)=0.00
stat_postcount	Count of total post fs_theme_post, fs_wallpost and fs_betrieb_notiz the user created	int=0
stat_buddycount	Statistic count of the confirmed buddies	unsigned int=0
stat_bananacount	Count of recived bananas the user have.	unsigned int=0
sleep_status	Kind of sleeping (@Foodsaver::SleepStatus)	unsigned tinyint=0
sleep_from	Date of sleep will begin	date	Nullable
sleep_until	Date of expected sleeping ends.	date	Nullable
is_sleeping	calculated column. Indicates, whether the user is currently sleeping	tinyint	Nullable
sleep_msg	Message about the reason of sleeping.	mediumtext(16777215)	Nullable
quiz_rolle	@Foodsaver::Role of quiz that the user have already successful done. (Hard coded levels exist: Role::AMBASSADOR, Role::STORE_MANAGER, Role::FOODSAVER)	unsigned tinyint=0
deleted_at	Date of accounts was deleted.	datetime	Nullable
about_me_intern	User provided description text for community internal accessable parts.	text(65535)	Nullable
deleted_by	id of the user who deleted this profile	unsigned int	Nullable
deleted_reason	optional explanation why this profile was deleted	varchar(200)	Nullable
no_automatic_delete	If true user is not automatically deleted	tinyint=0
totp_secret		varchar(40)	Nullable
backup_codes		longtext(4294967295)	Nullable
stat_givecount		unsigned int=0
stat_engagecount		unsigned int=0

Table fs_foodsaver_archive

Description - fs_foodsaver_archive

Archive table to hold removed users for admin purposes

Table columns - fs_foodsaver_archive

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
bezirk_id		unsigned int
position		varchar(255)=''
verified		unsigned tinyint=0
last_pass		datetime	Nullable
new_bezirk		varchar(120)
want_new		tinyint=0
mailbox_id		unsigned int	Nullable
rolle		tinyint
type		tinyint=0	Nullable
plz		varchar(10)	Nullable
stadt		varchar(100)	Nullable
lat		varchar(20)	Nullable
lon		varchar(20)	Nullable
photo		varchar(50)	Nullable
email		varchar(120)	Nullable
password		varchar(100)	Nullable
name		varchar(120)	Nullable
admin		unsigned tinyint	Nullable
nachname		varchar(120)	Nullable
anschrift		varchar(120)	Nullable
telefon		varchar(30)	Nullable
homepage		varchar(255)	Nullable
handy		varchar(50)	Nullable
geschlecht		unsigned tinyint	Nullable
geb_datum		date	Nullable
anmeldedatum		datetime	Nullable
privacy_notice_accepted_date		datetime	Nullable
privacy_policy_accepted_date		datetime	Nullable
orgateam		unsigned tinyint=0	Nullable
active		unsigned tinyint=0
data		mediumtext(16777215)
about_me_public		mediumtext(16777215)
newsletter		tinyint=0
token		varchar(100)
infomail_message		tinyint	Nullable
last_login		datetime	Nullable
stat_fetchweight		unsigned decimal(9)(2)=0.00
stat_fetchcount		unsigned int=0
stat_ratecount		unsigned int=0
stat_rating		unsigned decimal(4)(2)=0.00
stat_postcount		int=0
stat_buddycount		unsigned int
stat_bananacount		unsigned int=0
stat_fetchrate		decimal(6)(2)=100.00
sleep_status		unsigned tinyint=0
sleep_from		date	Nullable
sleep_until		date	Nullable
sleep_msg		mediumtext(16777215)	Nullable
option		mediumtext(16777215)
beta		tinyint=0
quiz_rolle		unsigned tinyint=0
contact_public		tinyint
deleted_at		datetime	Nullable
about_me_intern		text(65535)	Nullable
deleted_by	id of the user who deleted this profile	unsigned int	Nullable
deleted_reason	optional explanation why this profile was deleted	varchar(200)	Nullable
no_automatic_delete	If true user is not automatically deleted	tinyint=0
is_sleeping		tinyint	Nullable
totp_secret		varchar(40)	Nullable
backup_codes		longtext(4294967295)	Nullable
stat_givecount		unsigned int=0
stat_engagecount		unsigned int=0

Table fs_foodsaver_change_history

Description - fs_foodsaver_change_history

Logs all changes to personal data in foodsaver table

Table columns - fs_foodsaver_change_history

Column	Description	Type	properties
date		timestamp=current_timestamp()
fs_id		int
changer_id		unsigned int	foreign key (fs_foodsaver:id)
object_name		mediumtext(16777215)
old_value		mediumtext(16777215)	Nullable
new_value		mediumtext(16777215)	Nullable

Table fs_foodsaver_has_achievement

Description - fs_foodsaver_has_achievement

Table columns - fs_foodsaver_has_achievement

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
foodsaver_id		unsigned int	foreign key (fs_foodsaver:id)
achievement_id		unsigned int	foreign key (fs_achievement:id)
reviewer_id		unsigned int	foreign key (fs_foodsaver:id), Nullable
notice		text(65535)	Nullable
valid_until		datetime	Nullable
created_at		timestamp=current_timestamp()
updated_at		timestamp	Nullable

Table fs_foodsaver_has_bell

Description - fs_foodsaver_has_bell

Relates bells to their owner

Table columns - fs_foodsaver_has_bell

Column	Description	Type	properties
foodsaver_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
bell_id		unsigned int	Primary Key, foreign key (fs_bell:id)
seen		unsigned tinyint=0	Nullable

Table fs_foodsaver_has_bezirk

Description - fs_foodsaver_has_bezirk

Describes which foodsaver is in which group/district/workgroups and regions membership

Table columns - fs_foodsaver_has_bezirk

Column	Description	Type	properties
foodsaver_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
bezirk_id		unsigned int	Primary Key, foreign key (fs_bezirk:id)
active	0=beworben,1=aktiv,10=vielleicht	unsigned int=0	Nullable
added	Date of insert	datetime=current_timestamp()
application	Addition information about the foodsaver (like skills, possible time, ...)	mediumtext(16777215)=''
notify_by_email_about_new_threads	Emails from new forum threads in regions and working groups can be disabled.	unsigned tinyint=1
notify_on_all_new_threads	Whether to send a bell for every new thread in the forum. NULL for default value.	unsigned tinyint	Nullable

Table fs_foodsaver_has_contact

Description - fs_foodsaver_has_contact

Relates contacts (email addresses, see above) to users

Table columns - fs_foodsaver_has_contact

Column	Description	Type	properties
foodsaver_id		unsigned int=0	Primary Key, foreign key (fs_foodsaver:id)
contact_id		unsigned int=0	Primary Key, foreign key (fs_contact:id)

Table fs_foodsaver_has_conversation

Description - fs_foodsaver_has_conversation

Relates conversations to foodsavers. Care: It is also used to look up conversations by user

Table columns - fs_foodsaver_has_conversation

Column	Description	Type	properties
foodsaver_id		unsigned int	foreign key (fs_foodsaver:id)
conversation_id		unsigned int	foreign key (fs_conversation:id)
unread		smallint=1
id		unsigned int	Primary Key, Auto-Increment

Table fs_foodsaver_has_event

Description - fs_foodsaver_has_event

Relates users to events.

Table columns - fs_foodsaver_has_event

Column	Description	Type	properties
foodsaver_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
event_id		unsigned int	Primary Key, foreign key (fs_event:id)
status		unsigned tinyint=0

Table fs_foodsaver_has_favorite_resource

Description - fs_foodsaver_has_favorite_resource

Table columns - fs_foodsaver_has_favorite_resource

Column	Description	Type	properties
foodsaver_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
resource_id		unsigned int	Primary Key, foreign key (fs_resource:id)

Table fs_foodsaver_has_options

Description - fs_foodsaver_has_options

Table columns - fs_foodsaver_has_options

Column	Description	Type	properties
foodsaver_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
option_type	category of the option	unsigned int	Primary Key
option_value	value of the option	varchar(255)

Table fs_foodsaver_has_poll

Description - fs_foodsaver_has_poll

Table columns - fs_foodsaver_has_poll

Column	Description	Type	properties
foodsaver_id	id of the voter	unsigned int	Primary Key, foreign key (fs_foodsaver:id)
poll_id	id of the poll	unsigned int	Primary Key, foreign key (fs_poll:id)
time	time at which the voter has voted, null if not voted yet	datetime	Nullable

Table fs_foodsaver_has_wallpost

Description - fs_foodsaver_has_wallpost

Wallposts on user profile

Table columns - fs_foodsaver_has_wallpost

Column	Description	Type	properties
foodsaver_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
wallpost_id		unsigned int	Primary Key, foreign key (fs_wallpost:id)

Table fs_fsreports_has_wallpost

Description - fs_fsreports_has_wallpost

Stores notes on abuse reports

Table columns - fs_fsreports_has_wallpost

Column	Description	Type	properties
fsreports_id	foodsaver Id that has all reports	unsigned int	Primary Key, foreign key (fs_foodsaver:id)
wallpost_id	wallpost_id	unsigned int	Primary Key, foreign key (fs_wallpost:id)

Table fs_group_category

Description - fs_group_category

Table columns - fs_group_category

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
name		varchar(35)

Table fs_key_account_manager

Description - fs_key_account_manager

Table columns - fs_key_account_manager

Column	Description	Type	properties
foodsaver_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
chain_id		unsigned int	Primary Key, foreign key (fs_chain:id)

Table fs_lebensmittel

Description - fs_lebensmittel

Different kinds of food to be linked with individual stores. Only ever implemented as setter, don't care for now.

Table columns - fs_lebensmittel

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
name		varchar(50)	Nullable

Table fs_location

Description - fs_location

Table columns - fs_location

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
name		varchar(200)	Nullable
lat		decimal(10)(8)	Nullable
lon		decimal(11)(8)	Nullable
zip		varchar(10)	Nullable
city		varchar(100)	Nullable
street		varchar(200)	Nullable

Table fs_mailbox

Description - fs_mailbox

Stores mailbox names (for email mailboxes)

Table columns - fs_mailbox

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
name		varchar(50)	Nullable
last_access		datetime=current_timestamp()

Table fs_mailbox_member

Description - fs_mailbox_member

Maps additional mailbox access for users (e.g. granting custom mailboxes or group ones)

Table columns - fs_mailbox_member

Column	Description	Type	properties
mailbox_id		unsigned int	Primary Key, foreign key (fs_mailbox:id)
foodsaver_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
email_name		varchar(120)

Table fs_mailbox_message

Description - fs_mailbox_message

E-mails

Table columns - fs_mailbox_message

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
mailbox_id		unsigned int	foreign key (fs_mailbox:id)
folder		unsigned tinyint=1	Nullable
sender		text(65535)	Nullable
to		mediumtext(16777215)
subject		text(65535)	Nullable
body		mediumtext(16777215)	Nullable
body_html		mediumtext(16777215)
time		datetime	Nullable
attach		mediumtext(16777215)	Nullable
read		unsigned tinyint	Nullable
answer		unsigned tinyint	Nullable

Table fs_mailchange

Description - fs_mailchange

Requests to change the emailaddress

Table columns - fs_mailchange

Column	Description	Type	properties
foodsaver_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
newmail		varchar(200)	Nullable
time		datetime	Nullable
token		varchar(300)	Nullable

Table fs_msg

Description - fs_msg

Chat messages

Table columns - fs_msg

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
conversation_id		unsigned int	foreign key (fs_conversation:id)
foodsaver_id		unsigned int	foreign key (fs_foodsaver:id)
body		mediumtext(16777215)	Nullable
time		datetime	Nullable
is_htmlentity_encoded		tinyint=1
client_key	client-generated idempotency key (12 hex chars), unique per sender and conversation, nulled by the daily cleanup after the retry window	char(12)	Nullable

Table fs_pass_gen

Description - fs_pass_gen

Logs which ID cards have been generated

Table columns - fs_pass_gen

Column	Description	Type	properties
foodsaver_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
date		datetime	Primary Key
bot_id		unsigned int	foreign key (fs_foodsaver:id), Nullable

Table fs_pass_request

Description - fs_pass_request

Stores requests to reset the password

Table columns - fs_pass_request

Column	Description	Type	properties
foodsaver_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
name		varchar(50)	Nullable
time		datetime	Nullable

Table fs_poll

Description - fs_poll

Table columns - fs_poll

Column	Description	Type	properties
id	unique id of the poll	unsigned int	Primary Key, Auto-Increment
region_id	region with which the poll is associated	unsigned int	foreign key (fs_bezirk:id)
name	title of the poll	varchar(200)	Nullable
description	description of the poll	mediumtext(16777215)	Nullable
scope	determines who will be invited to vote	unsigned int
type	determines how a vote is cast and which values are possible for each option	unsigned int
start	start timestamp for the poll	datetime
end	end timestamp for the poll	datetime
author	id of the user who created the poll	unsigned int	foreign key (fs_foodsaver:id)
creation_timestamp		datetime
votes	number of users who have voted	unsigned int=0
cancelled_by	id of the user who cancelled the poll	unsigned int	Nullable
eligible_votes_count	number of users who are eligible to vote	unsigned int=0
shuffle_options		tinyint=1
notifications_sent		tinyint=2

Table fs_poll_has_options

Description - fs_poll_has_options

Table columns - fs_poll_has_options

Column	Description	Type	properties
poll_id	the poll to which this option belongs	unsigned int	Primary Key, foreign key (fs_poll:id)
option	index of the option	unsigned int	Primary Key
option_text		varchar(1000)	Nullable

Table fs_poll_option_has_value

Description - fs_poll_option_has_value

Table columns - fs_poll_option_has_value

Column	Description	Type	properties
poll_id	the poll to which the option belongs	unsigned int	Primary Key, foreign key (fs_poll:id)
option	index of the option	unsigned int	Primary Key
value	value for the option	int	Primary Key
votes	number of current votes for the value	unsigned int=0

Table fs_post_reaction

Description - fs_post_reaction

Table columns - fs_post_reaction

Column	Description	Type	properties
post_id		unsigned int	foreign key (fs_theme_post:id)
time		datetime
foodsaver_id		unsigned int	foreign key (fs_foodsaver:id)
key		varchar(63)	Nullable

Table fs_push_notification_subscription

Description - fs_push_notification_subscription

Table columns - fs_push_notification_subscription

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
foodsaver_id		int
data		text(65535)	Nullable
type		varchar(24)	Nullable

Table fs_question

Description - fs_question

Quiz questions

Table columns - fs_question

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
text		mediumtext(16777215)	Nullable
duration		unsigned int
wikilink		varchar(250)
is_mandatory		unsigned tinyint

Table fs_question_has_quiz

Description - fs_question_has_quiz

Relates quiz questions to the quiz

Table columns - fs_question_has_quiz

Column	Description	Type	properties
question_id		unsigned int	Primary Key, foreign key (fs_question:id)
quiz_id		unsigned int	Primary Key, foreign key (fs_quiz:id)
fp		unsigned tinyint	Nullable

Table fs_question_has_wallpost

Description - fs_question_has_wallpost

Relates wallposts to quiz questions

Table columns - fs_question_has_wallpost

Column	Description	Type	properties
question_id		unsigned int	Primary Key, foreign key (fs_question:id)
wallpost_id		unsigned int	Primary Key, foreign key (fs_wallpost:id)

Table fs_quiz

Description - fs_quiz

Table columns - fs_quiz

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
name		varchar(200)	Nullable
desc		mediumtext(16777215)	Nullable
is_desc_htmlentity_encoded	Whether the quiz description is html encoded.	tinyint=1
maxfp		unsigned smallint
questcount		unsigned smallint
questcount_untimed	number of questions that need to be answered when not using a time limit. Can be null to disable untimed quizzes.	unsigned smallint	Nullable

Table fs_quiz_session

Description - fs_quiz_session

Each try (by users) of a quiz (session)

Table columns - fs_quiz_session

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
foodsaver_id		unsigned int	foreign key (fs_foodsaver:id)
quiz_id		unsigned int
status		unsigned tinyint	Nullable
quiz_index		unsigned tinyint	Nullable
quiz_questions		mediumtext(16777215)	Nullable
quiz_result		mediumtext(16777215)	Nullable
time_start		datetime	Nullable
time_end		datetime	Nullable
fp		decimal(5)(2)	Nullable
maxfp		unsigned tinyint	Nullable
quest_count		unsigned tinyint	Nullable
easymode		tinyint=0
is_test	Whether this quiz session is only for testing purposes	unsigned tinyint=0

Table fs_rating

Description - fs_rating

Stores trust bananas

Table columns - fs_rating

Column	Description	Type	properties
foodsaver_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
rater_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
msg		mediumtext(16777215)
time		datetime

Table fs_region_function

Description - fs_region_function

Table columns - fs_region_function

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
region_id		unsigned int	foreign key (fs_bezirk:id)
function_id		unsigned int	Nullable
target_id		int	Nullable

Table fs_region_options

Description - fs_region_options

Table columns - fs_region_options

Column	Description	Type	properties
region_id		unsigned int	Primary Key, foreign key (fs_bezirk:id)
option_type	category of the option	unsigned int	Primary Key
option_value	value of the option	varchar(255)

Table fs_region_pin

Description - fs_region_pin

Table columns - fs_region_pin

Column	Description	Type	properties
region_id	region id	unsigned int	Primary Key, foreign key (fs_bezirk:id)
lat	latitude	varchar(20)
lon	longitude	varchar(20)
desc	description	mediumtext(16777215)
status	state of the pin	unsigned tinyint=0

Table fs_region_statistics

Description - fs_region_statistics

Table columns - fs_region_statistics

Column	Description	Type	properties
region_id	Id of the region, referring to table fs_bezirk.	unsigned int	Primary Key, foreign key (fs_bezirk:id)
last_modified	The last time that the statistics for the region were updated	datetime	Nullable
active_home_region_foodsavers	Number of verified foodsavers with home region within the region that logged in within the last month	unsigned int=0
active_coorporations	Number of currently cooperating stores	unsigned int=0
pickups_last_month	Number of filled pickup slots in the last month	unsigned int=0
saved_food_weight_last_month	Weight of saved food of the last month. Rounded to full kg.	unsigned int=0
active_food_share_points	Number of active food share points	unsigned mediumint=0
food_baskets_last_month	Number of foodbaskets in the last month	unsigned mediumint=0

Table fs_registration_attempt

Description - fs_registration_attempt

Table columns - fs_registration_attempt

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
email		varchar(255)
token		varchar(60)	Nullable
valid_until		datetime

Table fs_report

Description - fs_report

Table columns - fs_report

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
foodsaver_id		unsigned int
reporter_id		unsigned int	foreign key (fs_foodsaver:id), Nullable
reporttype		unsigned tinyint	Nullable
betrieb_id		unsigned int	Nullable
forum_thread_id		unsigned int	foreign key (fs_theme:id), Nullable
status		varchar(64)='reports.statuses.to_do'	Nullable
consequence		varchar(64)	Nullable
reminder_at		datetime	Nullable
reminder_sent		tinyint=0
time		datetime	Nullable
msg		mediumtext(16777215)	Nullable
tvalue		varchar(300)	Nullable
report_reason_id	Report Reason ID	unsigned int=1

Table fs_resource

Description - fs_resource

Table columns - fs_resource

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
foodsaver_id	null if resource is tied to the region (commons)	unsigned int	foreign key (fs_foodsaver:id), Nullable
region_id		unsigned int	foreign key (fs_bezirk:id), Nullable
name		varchar(35)
description		text(65535)	Nullable
is_private		tinyint=0	Nullable
openness		unsigned int=3	Nullable
images		text(65535)	Nullable

Table fs_resource_category

Description - fs_resource_category

Table columns - fs_resource_category

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
name		varchar(35)

Table fs_resource_has_category

Description - fs_resource_has_category

Table columns - fs_resource_has_category

Column	Description	Type	properties
resource_id		unsigned int	Primary Key, foreign key (fs_resource:id)
category_id		unsigned int	Primary Key, foreign key (fs_resource_category:id)

Table fs_store_has_wallpost

Description - fs_store_has_wallpost

Table columns - fs_store_has_wallpost

Column	Description	Type	properties
store_id		unsigned int	Primary Key, foreign key (fs_betrieb:id)
wallpost_id		unsigned int	Primary Key, foreign key (fs_wallpost:id)

Table fs_store_log

Description - fs_store_log

Table columns - fs_store_log

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
store_id	ID of Store	unsigned int
date_activity	when did the action take place	datetime=current_timestamp()
action	action type that was performed	unsigned tinyint
fs_id_a	foodsaver_id who is doing the action	unsigned int
fs_id_p	to which foodsaver_id is it done to	unsigned int	foreign key (fs_foodsaver:id), Nullable
date_reference	date referenced (slot or wallpost entry)	datetime	Nullable
content	Text from the store-wall-entry	mediumtext(16777215)	Nullable
reason	Why a negativ action was done	mediumtext(16777215)	Nullable

Table fs_theme

Description - fs_theme

Threads in the forum.

Table columns - fs_theme

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
foodsaver_id		unsigned int	foreign key (fs_foodsaver:id)
last_post_id		unsigned int=0
name		varchar(260)	Nullable
time		datetime	Nullable
active		unsigned tinyint=1
sticky		tinyint=0
status	status of the thread (open or closed)	unsigned int=0

Table fs_theme_follower

Description - fs_theme_follower

Stores who follows threads

Table columns - fs_theme_follower

Column	Description	Type	properties
foodsaver_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
theme_id		unsigned int	Primary Key, foreign key (fs_theme:id)
infotype		tinyint=0
bell_notification		tinyint=1

Table fs_theme_post

Description - fs_theme_post

Stores posts in forum threads

Table columns - fs_theme_post

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
theme_id		unsigned int	foreign key (fs_theme:id)
foodsaver_id		unsigned int	foreign key (fs_foodsaver:id)
body		mediumtext(16777215)	Nullable
time		datetime	Nullable
hidden_time		datetime	Nullable
hidden_by		unsigned int	foreign key (fs_foodsaver:id), Nullable
hidden_reason		varchar(255)	Nullable
last_edited_at	Time of the last edit of the post (null if never edited)	datetime	Nullable

Table fs_usernotes_has_wallpost

Description - fs_usernotes_has_wallpost

Relates wallposts to user profiles, which describes the orga notes on user profiles

Table columns - fs_usernotes_has_wallpost

Column	Description	Type	properties
usernotes_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
wallpost_id		unsigned int	Primary Key, foreign key (fs_wallpost:id)

Table fs_verify_history

Description - fs_verify_history

Table columns - fs_verify_history

Column	Description	Type	properties
fs_id		unsigned int	Nullable
date		datetime
bot_id		unsigned int	foreign key (fs_foodsaver:id), Nullable
change_status		tinyint	Nullable

Table fs_wallpost

Description - fs_wallpost

Table columns - fs_wallpost

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
foodsaver_id		unsigned int	foreign key (fs_foodsaver:id)
body		mediumtext(16777215)	Nullable
time		datetime	Nullable
attach		mediumtext(16777215)	Nullable

Table fs_wall_post_reaction

Description - fs_wall_post_reaction

Table columns - fs_wall_post_reaction

Column	Description	Type	properties
post_id		unsigned int	Primary Key, foreign key (fs_wallpost:id)
foodsaver_id		unsigned int	Primary Key, foreign key (fs_foodsaver:id)
key		varchar(63)	Primary Key
time		datetime

Table fs_webauthn_credentials

Description - fs_webauthn_credentials

Table columns - fs_webauthn_credentials

Column	Description	Type	properties
id		varchar(26)	Primary Key
public_key_credential_id		text(65535)
type		varchar(255)
transports		longtext(4294967295)
attestation_type		varchar(255)
trust_path		text(65535)
aaguid		varchar(36)
credential_public_key		text(65535)
user_handle		unsigned int	foreign key (fs_foodsaver:id)
counter		unsigned int=0
other_ui		longtext(4294967295)	Nullable
name		varchar(255)	Nullable
rp_id	The Relying Party ID (domain) where this passkey was registered	varchar(255)=''
created_at		datetime
last_used_at		datetime	Nullable

Table oauth_access_tokens

Description - oauth_access_tokens

Table columns - oauth_access_tokens

Column	Description	Type	properties
identifier		varchar(100)	Primary Key
client_identifier		varchar(100)	foreign key (oauth_clients:identifier), Nullable
user_identifier		varchar(100)	Nullable
scopes		mediumtext(16777215)
expires_at		datetime
revoked		tinyint=0	Nullable
created_at		datetime

Table oauth_auth_codes

Description - oauth_auth_codes

Table columns - oauth_auth_codes

Column	Description	Type	properties
identifier		varchar(100)	Primary Key
client_identifier		varchar(100)	foreign key (oauth_clients:identifier), Nullable
user_identifier		varchar(100)	Nullable
scopes		mediumtext(16777215)
redirect_uri		mediumtext(16777215)	Nullable
nonce		varchar(255)	Nullable
expires_at		datetime
revoked		tinyint=0	Nullable
code_challenge		varchar(255)	Nullable
code_challenge_method		varchar(20)	Nullable
created_at		datetime

Table oauth_clients

Description - oauth_clients

Table columns - oauth_clients

Column	Description	Type	properties
identifier		varchar(100)	Primary Key
name		varchar(190)	Nullable
confidential		tinyint=1	Nullable
active		tinyint=1	Nullable
redirect_uris		mediumtext(16777215)
scopes		mediumtext(16777215)
grant_types		mediumtext(16777215)
secret_hash		varchar(255)	Nullable
required_region_ids		mediumtext(16777215)	Nullable
changed_by		unsigned int=0	Nullable
created_at		datetime
updated_at		datetime

Table oauth_refresh_tokens

Description - oauth_refresh_tokens

Table columns - oauth_refresh_tokens

Column	Description	Type	properties
identifier		varchar(100)	Primary Key
access_token_identifier		varchar(100)	foreign key (oauth_access_tokens:identifier), Nullable
expires_at		datetime
revoked		tinyint=0	Nullable
created_at		datetime

Table oauth_user_consents

Description - oauth_user_consents

Table columns - oauth_user_consents

Column	Description	Type	properties
id		unsigned int	Primary Key, Auto-Increment
user_id		unsigned int	foreign key (fs_foodsaver:id), Nullable
client_identifier		varchar(100)	foreign key (oauth_clients:identifier), Nullable
scopes		mediumtext(16777215)
revoked_at		datetime	Nullable
created_at		datetime
updated_at		datetime

Table phinxlog

Description - phinxlog

Table columns - phinxlog

Column	Description	Type	properties
version		bigint	Primary Key
migration_name		varchar(100)	Nullable
start_time		timestamp	Nullable
end_time		timestamp	Nullable
breakpoint		tinyint=0

Table uploads

Description - uploads

Table columns - uploads

Column	Description	Type	properties
uuid		char(36)	Primary Key
user_id		unsigned int	Nullable
sha256hash		char(64)
mimeType		varchar(255)
uploaded_at		datetime
filesize		unsigned int
used_in	Indicates in which module this uploaded file is being used (profile photo, wall post, ...). A value of null indicates that the file is not being used (yet).	unsigned int	Nullable
usage_id	Id of the entity that uses this uploaded file, e.g. id of the profile or the wall post. A null value indicates that the file is not being used (yet).	char(10)	Nullable

Usage of table in PHP Modules

Achievement

• fs_achievement (, DELETE, INSERT, SELECT, UPDATE)
• fs_bezirk (SELECT)
• fs_foodsaver (SELECT)
• fs_foodsaver_has_achievement (, DELETE, INSERT, SELECT, UPDATE)

Activity

• fs_betrieb (SELECT)
• fs_betrieb_team (SELECT)
• fs_bezirk (SELECT)
• fs_bezirk_has_theme (SELECT)
• fs_event (SELECT)
• fs_event_has_wallpost (SELECT)
• fs_fairteiler (SELECT)
• fs_fairteiler_has_wallpost (SELECT)
• fs_foodsaver (SELECT)
• fs_store_has_wallpost (SELECT)
• fs_theme (SELECT)
• fs_theme_post (SELECT)
• fs_wallpost (SELECT)

Application

• fs_foodsaver_has_bezirk (DELETE, SELECT)

Banana

• fs_foodsaver (SELECT)
• fs_rating (DELETE, INSERT, SELECT)

Basket

• fs_basket (, SELECT)
• fs_basket_anfrage (INSERT, SELECT)
• fs_foodsaver (, SELECT)

Bell

• fs_bell (DELETE, SELECT, UPDATE)
• fs_foodsaver_has_bell (DELETE, INSERT, SELECT, UPDATE)

Blog

• fs_blog_entry (DELETE, SELECT, UPDATE)
• fs_foodsaver (SELECT)

Buddy

• fs_buddy (DELETE, INSERT, SELECT, UPDATE)
• fs_foodsaver (SELECT)

BusinessCard

• fs_bezirk (SELECT)
• fs_foodsaver (SELECT)
• fs_mailbox (SELECT)

Command

• fs_bezirk (UPDATE)

Commands

• fs_feature_toggles (INSERT)

Content

• fs_content (DELETE, INSERT, SELECT, UPDATE)

DTO

• fs_id ()
• fs_name ()

Db

• fs_sess (, SELECT)

Dev

• fs_bezirk (, SELECT)
• fs_blog_entry ()
• fs_botschafter (SELECT)
• fs_fetchweight (SELECT)
• fs_region_function (, SELECT)

EMailVerify

• fs_foodsaver (SELECT)

Event

• fs_bezirk (SELECT)
• fs_event (, INSERT, SELECT, UPDATE)
• fs_foodsaver_has_bezirk (SELECT)
• fs_foodsaver_has_event (DELETE, INSERT, SELECT)
• fs_location (DELETE, INSERT, SELECT)

FoodSharePoint

• fs_botschafter (SELECT)
• fs_fairteiler (DELETE, INSERT, SELECT, UPDATE)
• fs_fairteiler_follower (DELETE, INSERT, SELECT)
• fs_fairteiler_has_wallpost (SELECT)
• fs_foodsaver (SELECT)
• fs_wallpost (SELECT)

Foodsaver

• fs_apitoken (DELETE)
• fs_basket_anfrage (DELETE)
• fs_betrieb_team (SELECT)
• fs_bezirk (SELECT)
• fs_bezirk_closure (SELECT)
• fs_botschafter (DELETE, SELECT)
• fs_buddy (DELETE)
• fs_fairteiler_follower (DELETE)
• fs_foodsaver (, SELECT, UPDATE)
• fs_foodsaver_archive (INSERT)
• fs_foodsaver_has_achievement (DELETE)
• fs_foodsaver_has_bell (DELETE)
• fs_foodsaver_has_bezirk (DELETE, INSERT, SELECT)
• fs_foodsaver_has_contact (DELETE)
• fs_foodsaver_has_event (DELETE)
• fs_foodsaver_has_favorite_resource (DELETE)
• fs_foodsaver_has_options (DELETE)
• fs_foodsaver_has_poll (DELETE)
• fs_foodsaver_has_wallpost (DELETE)
• fs_key_account_manager (DELETE)
• fs_mailchange (DELETE)
• fs_pass_gen (DELETE)
• fs_pass_request (DELETE)
• fs_push_notification_subscription (DELETE)
• fs_quiz_session (DELETE)
• fs_rating (DELETE)
• fs_region_function (SELECT)
• fs_resource (DELETE)
• fs_theme_follower (DELETE)
• fs_verify_history (DELETE, INSERT, SELECT)
• fs_webauthn_credentials (DELETE)

Group

• fs_betrieb (SELECT)
• fs_bezirk (DELETE, SELECT)
• fs_bezirk_has_theme (SELECT)
• fs_bezirk_has_wallpost (SELECT)
• fs_botschafter (SELECT)
• fs_event (DELETE, SELECT)
• fs_event_has_wallpost (SELECT)
• fs_fairteiler (SELECT)
• fs_mailbox (DELETE, SELECT)
• fs_mailbox_message (SELECT)
• fs_region_function (DELETE, INSERT, SELECT)
• fs_theme (SELECT)
• fs_wallpost (SELECT)

Info

• fs_theme_follower (SELECT)

Legal

• fs_content (SELECT)
• fs_foodsaver (UPDATE)

Lib

• fs_sess (SELECT)

Login

• fs_email_blacklist (DELETE, INSERT, SELECT, UPDATE)
• fs_foodsaver (SELECT, UPDATE)
• fs_pass_request (DELETE, INSERT, SELECT)

Mailbox

• fs_bezirk (, SELECT, UPDATE)
• fs_botschafter (SELECT)
• fs_contact (INSERT, SELECT)
• fs_foodsaver (SELECT)
• fs_foodsaver_has_contact (INSERT)
• fs_mailbox (DELETE, INSERT, SELECT, UPDATE)
• fs_mailbox_member (SELECT)
• fs_mailbox_message (DELETE, SELECT, UPDATE)

Mails

• fs_email_bounces (DELETE, INSERT, SELECT)
• fs_mailbox (SELECT)
• fs_mailbox_message (INSERT)

Maintenance

• fs_basket (SELECT)
• fs_bezirk (SELECT)
• fs_bezirk_closure (DELETE, INSERT, SELECT)
• fs_foodsaver_has_bezirk (INSERT)
• fs_mailchange (DELETE)
• fs_msg (UPDATE)
• fs_registration_attempt (DELETE)
• fs_theme_post (SELECT)

Map

• fs_basket (SELECT)
• fs_betrieb (SELECT)
• fs_bezirk (SELECT)
• fs_event (SELECT)
• fs_fairteiler (SELECT)
• fs_location (SELECT)
• fs_region_pin (SELECT)

Message

• fs_betrieb (SELECT)
• fs_conversation (DELETE, INSERT, SELECT, UPDATE)
• fs_foodsaver_has_conversation (DELETE, INSERT, SELECT, UPDATE)
• fs_msg (DELETE, INSERT, SELECT)

OAuth

• fs_bezirk (SELECT)
• fs_botschafter (SELECT)
• fs_foodsaver (SELECT)
• fs_foodsaver_has_bezirk (SELECT)

PassportGenerator

• fs_foodsaver (SELECT, UPDATE)
• fs_pass_gen (INSERT)

Profile

• fs_abholer (SELECT)
• fs_basket (SELECT)
• fs_basket_anfrage (SELECT)
• fs_betrieb (SELECT)
• fs_betrieb_kategorie (SELECT)
• fs_betrieb_team (SELECT)
• fs_bezirk (SELECT)
• fs_event (SELECT)
• fs_foodsaver (SELECT)
• fs_foodsaver_change_history (SELECT)
• fs_foodsaver_has_bezirk (SELECT)
• fs_foodsaver_has_event (SELECT)
• fs_pass_gen (SELECT)
• fs_report (SELECT)
• fs_store_log (SELECT)

PushNotification

• fs_push_notification_subscription (DELETE, INSERT)

Querys

• fs_feature_toggles (SELECT)

Quiz

• fs_answer (, DELETE, INSERT, UPDATE)
• fs_question (DELETE, INSERT, SELECT, UPDATE)
• fs_question_has_quiz (DELETE, INSERT, SELECT, UPDATE)
• fs_quiz (, SELECT, UPDATE)
• fs_quiz_session (DELETE, SELECT)

Region

• fs_abholer (SELECT)
• fs_betrieb (SELECT)
• fs_bezirk (, INSERT, SELECT, UPDATE)
• fs_bezirk_closure (INSERT, SELECT)
• fs_bezirk_has_theme (INSERT, SELECT)
• fs_botschafter (DELETE, INSERT, SELECT)
• fs_fairteiler (SELECT)
• fs_foodsaver (SELECT)
• fs_foodsaver_has_bezirk (INSERT, SELECT, UPDATE)
• fs_mailbox (SELECT)
• fs_post_reaction (SELECT)
• fs_region_options (INSERT, SELECT)
• fs_region_pin (INSERT, SELECT)
• fs_region_statistics (SELECT)
• fs_report (SELECT)
• fs_theme (DELETE, INSERT, SELECT, UPDATE)
• fs_theme_follower (DELETE, INSERT, SELECT)
• fs_theme_post (, DELETE, SELECT, UPDATE)

Register

• fs_registration_attempt (DELETE, INSERT, SELECT)

Report

• fs_foodsaver (SELECT)
• fs_report (DELETE, SELECT, UPDATE)

Repository

• fs_bezirk (SELECT)
• fs_botschafter (SELECT)
• fs_foodsaver (SELECT)
• fs_foodsaver_has_bezirk (SELECT)

ResourceMosaic

• fs_bezirk_closure (SELECT)
• fs_buddy (SELECT)
• fs_foodsaver (SELECT)
• fs_foodsaver_has_bezirk (SELECT)
• fs_foodsaver_has_favorite_resource (DELETE, INSERT, SELECT)
• fs_resource (, DELETE, INSERT, SELECT, UPDATE)
• fs_resource_has_category (DELETE, INSERT, SELECT)

Search

• fs_betrieb (SELECT)
• fs_betrieb_team (SELECT)
• fs_bezirk (SELECT)
• fs_bezirk_has_theme (SELECT)
• fs_botschafter (SELECT)
• fs_buddy (SELECT)
• fs_chain (SELECT)
• fs_conversation (SELECT)
• fs_event (SELECT)
• fs_fairteiler (SELECT)
• fs_fairteiler_follower (SELECT)
• fs_foodsaver (SELECT)
• fs_foodsaver_has_bezirk (SELECT)
• fs_foodsaver_has_conversation (SELECT)
• fs_foodsaver_has_event (SELECT)
• fs_foodsaver_has_poll (SELECT)
• fs_key_account_manager (SELECT)
• fs_location (SELECT)
• fs_mailbox (SELECT)
• fs_mailbox_message (SELECT)
• fs_poll (SELECT)
• fs_theme (SELECT)
• fs_theme_follower (SELECT)
• fs_theme_post (SELECT)

Settings

• fs_apitoken (DELETE, SELECT)
• fs_bezirk (SELECT)
• fs_foodsaver (SELECT, UPDATE)
• fs_foodsaver_change_history (INSERT)
• fs_foodsaver_has_options (INSERT, SELECT)

Statistics

• fs_abholer (SELECT)
• fs_basket (SELECT)
• fs_fairteiler (SELECT)
• fs_foodsaver (SELECT)
• fs_foodsaver_has_bezirk (SELECT)

Stats

• fs_abholer (SELECT)
• fs_basket (SELECT)
• fs_betrieb (SELECT)
• fs_betrieb_kategorie (SELECT)
• fs_betrieb_team (UPDATE)
• fs_bezirk (SELECT, UPDATE)
• fs_bezirk_closure (SELECT)
• fs_bezirk_has_theme (SELECT)
• fs_botschafter (SELECT)
• fs_buddy (SELECT)
• fs_fairteiler (SELECT)
• fs_fetchweight (SELECT)
• fs_foodsaver (SELECT, UPDATE)
• fs_foodsaver_has_bezirk (SELECT)
• fs_rating (SELECT)
• fs_region_statistics (INSERT, UPDATE)
• fs_store_has_wallpost (SELECT)
• fs_theme_post (SELECT)
• fs_wallpost (SELECT)

Store

• fs_abholer (DELETE, INSERT, SELECT)
• fs_abholzeiten (DELETE, INSERT, SELECT)
• fs_betrieb (, DELETE, INSERT, SELECT, UPDATE)
• fs_betrieb_has_lebensmittel (DELETE, INSERT, SELECT)
• fs_betrieb_kategorie (SELECT)
• fs_betrieb_team (DELETE, INSERT, SELECT, UPDATE)
• fs_bezirk (SELECT)
• fs_bezirk_closure (SELECT)
• fs_chain (SELECT)
• fs_conversation (SELECT)
• fs_fetchdate (INSERT, SELECT)
• fs_foodsaver (SELECT)
• fs_foodsaver_has_achievement (SELECT)
• fs_foodsaver_has_bezirk (SELECT)
• fs_lebensmittel (SELECT)
• fs_store_log (INSERT, SELECT)

StoreChain

• fs_betrieb (SELECT)
• fs_bezirk_has_theme (SELECT)
• fs_chain (INSERT, SELECT)
• fs_foodsaver (SELECT)
• fs_key_account_manager (DELETE, INSERT, SELECT)

Unit

• fs_bezirk (SELECT)
• fs_botschafter (SELECT)
• fs_foodsaver_has_bezirk (SELECT)

Voting

• fs_bezirk (SELECT)
• fs_bezirk_closure (SELECT)
• fs_botschafter (SELECT)
• fs_foodsaver (SELECT)
• fs_foodsaver_has_bezirk (SELECT)
• fs_foodsaver_has_poll (INSERT, SELECT, UPDATE)
• fs_poll (DELETE, INSERT, SELECT, UPDATE)
• fs_poll_has_options (DELETE, INSERT, SELECT)
• fs_poll_option_has_value (DELETE, INSERT, SELECT, UPDATE)

WallPost

• fs_foodsaver (SELECT)
• fs_wall_post_reaction (DELETE, INSERT, SELECT)
• fs_wallpost (DELETE, INSERT, SELECT)

WebAuthn

• fs_webauthn_credentials (DELETE, INSERT, SELECT)

WorkGroup

• fs_bezirk (SELECT)
• fs_bezirk_has_theme (SELECT)
• fs_botschafter (SELECT)
• fs_foodsaver (SELECT)
• fs_foodsaver_has_bezirk (SELECT)
• fs_mailbox (SELECT)
• fs_region_function (SELECT)
• fs_theme (SELECT)
• fs_theme_post (SELECT)