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.
List of tables
- fs_abholer
- fs_abholzeiten
- fs_achievement
- fs_answer
- fs_apitoken
- fs_basket
- fs_basket_anfrage
- fs_basket_has_art
- fs_basket_has_types
- fs_basket_has_wallpost_abandoned
- fs_bell
- fs_betrieb
- fs_betrieb_has_lebensmittel
- fs_betrieb_kategorie
- fs_betrieb_notiz
- fs_store_log
- fs_theme
- fs_theme_follower
- fs_theme_post
- fs_usernotes_has_wallpost
- fs_verify_history
- fs_wallpost
- phinxlog
- uploads
Structure of tables
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).
Open todos from old documentation - fs_abholer
- Have deleted entries from fs_foodsaver and fs_betrieb reappear.
- Hide deleted fs_betrieb on existing map
- Don't care about that in existing code. Used to show pickup history, but broken old entries seem fine.
- Document: Add to database as comment (1: Confirmed, 0: Not confirmed)
- Clarify: Why is this an integer and not a boolean?
Table columns - fs_abholer
Column | Description | Type | properties |
---|---|---|---|
foodsaver_id | unsigned int(10) | Weak-foreign key (fs_foodsaver:id) | |
betrieb_id | unsigned int(10) | Weak-foreign key (fs_betrieb:id) | |
date | datetime | ||
confirmed | 1: Confirmed, 0: Not confirmed | unsigned int(4) | |
id | unsigned int(10) | Primary Key, Auto-Increment |
Table fs_abholzeiten
Description - fs_abholzeiten
Contains information about regurlary reoccuring pickup slots.
Open todos from old documentation - fs_abholzeiten
- Document: Add to database as column (Dow) comment: Day of week (1=Monday, 0=Sunday)
- Document: Add to database as column (Time) comment: When on the day the pickup is
- Document: Add to database as column (Fetcher) comment: Number of slots (>= 0, >= 1 enforced by frontend)
- Clarify: Where are additional single pickup slots are stored?
- Remove all non-existent references to fs_betrieb, add
ON DELETE CASCADE
. - Add foreign key relationship to fs_betrieb Reasoning: The data only affects future pickups that will not occur in case a store is removed.
Table columns - fs_abholzeiten
Column | Description | Type | properties |
---|---|---|---|
betrieb_id | unsigned int(10) | Primary Key, Weak-foreign key (fs_betrieb:id) | |
dow | Day of week (1=Monday, 0=Sunday) | unsigned int(4) | 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 int(4)=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(11) | Primary Key, Auto-Increment | |
region_id | region defining the scope in which this achievement is relevant | unsigned int(10) | foreign key (fs_bezirk:id) |
name | varchar(255) | Nullable | |
description | varchar(255) | Nullable | |
validity_in_days_after_assignment | int(11) | Nullable | |
is_requestable_by_foodsaver | int(1) | Nullable | |
created_at | timestamp=current_timestamp() | ||
updated_at | timestamp | Nullable | |
icon | the icon to display this achievement with | varchar(255) | Nullable |
Table fs_answer
Description - fs_answer
Stores answers to quiz.
Open todos from old documentation - fs_answer
- Add foreign key relationship to fs_question as well as
ON DELETE CASCADE
. Reasoning: Answers to removed questions are not needed, existing quiz sessions get a copy infs_quiz_session.quiz_result
.
Table columns - fs_answer
Column | Description | Type | properties |
---|---|---|---|
id | unsigned int(10) | Primary Key, Auto-Increment | |
question_id | unsigned int(10) | foreign key (fs_question:id) | |
text | text(16777215) | Nullable | |
explanation | text(16777215) | ||
right | unsigned int(4) | Nullable |
Table fs_apitoken
Description - fs_apitoken
User tokens for ICS/ICAL/WebCal access to calendar of future events/pickups.
Open todos from old documentation - fs_apitoken
- Remove tokens for not existing users
- add foreign key relationship to fs_foodsaver as well as
ON DELETE CASCADE
.
Table columns - fs_apitoken
Column | Description | Type | properties |
---|---|---|---|
foodsaver_id | Owner of the token and identifier for the calendar | unsigned int(10) | foreign key (fs_foodsaver:id) |
token | Access token, hex-number from openssl. | varchar(255) |
Table fs_basket
Description - fs_basket
Lists all foodbaskets.
Open todos from old documentation - fs_basket
- Check code to never display foodbaskets from removed users except to admins.
- Clarify: Meaning of status == Basket::Status
- Clarify: Meaning of fs_id
- Clarify: Meaning of appost
- Clarify: Meaning of contact_type
- Clarify: Meaning of location_type
- Clarify: Meaning of weight unit
- Clarify: Meaning of picture
- Clarify: Meaning of time
- Clarify: Meaning of update
- Clarify: Meaning of until
- Clarify: Meaning of fetchtime
- Clarify: Owner of tel
- Clarify: Owner of handy
Table columns - fs_basket
Column | Description | Type | properties |
---|---|---|---|
id | unsigned int(10) | Primary Key, Auto-Increment | |
foodsaver_id | unsigned int(10) | Weak-foreign key (fs_foodsaver:id) | |
status | @Basket::Status | unsigned int(4) | Nullable |
time | Creation datetime | datetime | Nullable |
update | datetime | Nullable | |
until | Basket is present until datetime expires | datetime | |
fetchtime | datetime | Nullable | |
description | text(16777215) | Nullable | |
picture | text(65535) | Nullable | |
tel | varchar(50) | ||
handy | varchar(50) | ||
contact_type | varchar(20)=1 | ||
location_type | Fix set to 0 | unsigned int(4) | Nullable |
weight | Smaller <0kg = 3kg | float | Nullable |
lat | Basket location latitude | float | |
lon | Basket location longitude | float | |
bezirk_id | unsigned int(10) | Weak-foreign key (fs_bezirk:id) | |
appost | int(4) |
Table fs_basket_anfrage
Description - fs_basket_anfrage
Lists foodbasket requests.
Open todos from old documentation - fs_basket_anfrage
- Remove entries for non-existing users
- add
ON DELETE CASCADE
to fs_foodsaver. - Remove entries for non-existing baskets
- add
ON DELETE CASCADE
to fs_basket. - Reasoning: Requests for non existant users do not need to be kept, basket FK is purely defensive.
Table columns - fs_basket_anfrage
Column | Description | Type | properties |
---|---|---|---|
foodsaver_id | unsigned int(10) | Primary Key, foreign key (fs_foodsaver:id) | |
basket_id | unsigned int(10) | Primary Key, foreign key (fs_basket:id) | |
status | unsigned int(4) | Nullable | |
time | datetime | ||
appost | int(4) |
Table fs_basket_has_art
Description - fs_basket_has_art
Combines foodbaskets with different types of food. Unused: Has to be entered but is never evaluated.
Open todos from old documentation - fs_basket_has_art
- remove in code (in future), leave database as is (for now)
Table columns - fs_basket_has_art
Column | Description | Type | properties |
---|---|---|---|
basket_id | unsigned int(10) | Primary Key | |
art_id | unsigned int(10) | Primary Key |
Table fs_basket_has_types
Description - fs_basket_has_types
See fs_basket_has_art
Table columns - fs_basket_has_types
Column | Description | Type | properties |
---|---|---|---|
basket_id | unsigned int(10) | Primary Key | |
types_id | unsigned int(10) | Primary Key |
Table fs_basket_has_wallpost_abandoned
Description - fs_basket_has_wallpost_abandoned
Table columns - fs_basket_has_wallpost_abandoned
Column | Description | Type | properties |
---|---|---|---|
basket_id | unsigned int(10) | Primary Key, foreign key (fs_basket:id) | |
wallpost_id | unsigned int(10) | Primary Key, foreign key (fs_wallpost:id) |
Table fs_bell
Description - fs_bell
Stores arbitrary notifications
Table columns - fs_bell
Column | Description | Type | properties |
---|---|---|---|
id | unsigned int(10) | Primary Key, Auto-Increment | |
name | varchar(50) | Nullable | |
body | varchar(50) | Nullable | |
vars | text(16777215) | Nullable | |
attr | varchar(500) | Nullable | |
icon | varchar(150) | Nullable | |
identifier | varchar(40) | Nullable | |
time | datetime | ||
closeable | unsigned int(4)=1 | ||
expiration | date | Nullable |
Table fs_betrieb
Description - fs_betrieb
Stores stores.
Open todos from old documentation - fs_betrieb
- Conversation 108242 and 108243 missing (store 1, 2) (fixed, inserted)
- Link
bezirk_id
to fs_bezirk - Care about kette_id, betrieb_kategorie_id (fixed with issue #862)
Table columns - fs_betrieb
Column | Description | Type | properties |
---|---|---|---|
id | unsigned int(10) | Primary Key, Auto-Increment | |
betrieb_status_id | @Status::CooperationStatus | unsigned int(10) | |
bezirk_id | unsigned int(10) | ||
added | date | ||
plz | varchar(5) | ||
stadt | varchar(50) | ||
lat | varchar(20) | Nullable | |
lon | varchar(20) | Nullable | |
kette_id | unsigned int(10) | Weak-foreign key (fs_kette:id), Nullable | |
betrieb_kategorie_id | unsigned int(10) | foreign key (fs_betrieb_kategorie:id), Nullable | |
name | varchar(120) | Nullable | |
str | varchar(120) | Nullable | |
status_date | date | Nullable | |
status | unsigned int(4) | Nullable | |
ansprechpartner | varchar(60) | Nullable | |
telefon | varchar(50) | Nullable | |
fax | varchar(50) | Nullable | |
varchar(60) | Nullable | ||
begin | date | Nullable | |
besonderheiten | text(16777215) | Nullable | |
public_info | varchar(535) | Nullable | |
public_time | @Store::PublicTimes | int(4) | |
ueberzeugungsarbeit | @Store::ConvinceStatus | int(4) | |
presse | Yes=0; No=1 | int(4) | Nullable |
sticker | Yes=0; No=1 | int(4) | Nullable |
abholmenge | See @WeightHelper | int(4) | |
team_status | 0 = Team Voll; 1 = Es werden noch Helfer gesucht; 2 = Es werden dringend Helfer gesucht | int(4)=1 | |
prefetchtime | Frequence of expected regular pickups in seconds | unsigned int(10)=1209600 | |
team_conversation_id | unsigned int(10) | Nullable | |
springer_conversation_id | unsigned int(10) | Nullable | |
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(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(10) | Primary Key | |
lebensmittel_id | unsigned int(10) | Primary Key |
Table fs_betrieb_kategorie
Description - fs_betrieb_kategorie
Table columns - fs_betrieb_kategorie
Column | Description | Type | properties |
---|---|---|---|
id | unsigned int(10) | Primary Key, Auto-Increment | |
name | varchar(50) | Nullable |
Table fs_betrieb_notiz
Description - fs_betrieb_notiz
Stores wallposts on stores (independent of wallpost system)
Open todos from old documentation - fs_betrieb_notiz
- Have deleted entries from fs_foodsaver and fs_betrieb reappear.
Table columns - fs_betrieb_notiz
Column | Description | Type | properties |
---|---|---|---|
id | unsigned int(10) | Primary Key, Auto-Increment | |
foodsaver_id | unsigned int(10) | ||
betrieb_id | unsigned int(10) | ||
milestone | unsigned int(4) | ||
text | text(16777215) | Nullable | |
zeit | datetime | Nullable | |
last | int(4) |
Table fs_store_log
Description - fs_store_log
Table columns - fs_store_log
Column | Description | Type | properties |
---|---|---|---|
id | unsigned int(11) | Primary Key, Auto-Increment | |
store_id | ID of Store | int(10) | |
date_activity | when did the action take place | datetime=current_timestamp() | |
action | action type that was performed | int(4) | |
fs_id_a | foodsaver_id who is doing the action | int(10) | |
fs_id_p | to which foodsaver_id is it done to | int(10) | Nullable |
date_reference | date referenced (slot or wallpost entry) | datetime | Nullable |
content | Text from the store-wall-entry | varchar(255) | Nullable |
reason | Why a negativ action was done | text(16777215) | Nullable |
Table fs_theme
Description - fs_theme
Threads in the forum.
Open todos from old documentation - fs_theme
- nothing as threads from deleted users should be kept
Table columns - fs_theme
Column | Description | Type | properties |
---|---|---|---|
id | unsigned int(10) | Primary Key, Auto-Increment | |
foodsaver_id | unsigned int(10) | ||
last_post_id | unsigned int(10) | ||
name | varchar(260) | Nullable | |
time | datetime | Nullable | |
active | unsigned int(4)=1 | ||
sticky | int(1) | ||
status | status of the thread (open or closed) | unsigned int(10) |
Table fs_theme_follower
Description - fs_theme_follower
stores who follows themes
Open todos from old documentation - fs_theme_follower
- remove broken data (as follower information is irrelevant for broken XY)
- Add FK
Table columns - fs_theme_follower
Column | Description | Type | properties |
---|---|---|---|
foodsaver_id | unsigned int(10) | Primary Key, foreign key (fs_foodsaver:id) | |
theme_id | unsigned int(10) | Primary Key, foreign key (fs_theme:id) | |
infotype | int(1) | ||
bell_notification | int(1)=1 |
Table fs_theme_post
Description - fs_theme_post
Stores posts in themes
Open todos from old documentation - fs_theme_post
- Recreate users
- Remove broken data (for themes, not users)
- Add FK to themes
Table columns - fs_theme_post
Column | Description | Type | properties |
---|---|---|---|
id | unsigned int(10) | Primary Key, Auto-Increment | |
theme_id | unsigned int(10) | foreign key (fs_theme:id) | |
foodsaver_id | unsigned int(10) | ||
reply_post | unsigned int(10) | ||
body | text(16777215) | Nullable | |
time | datetime | Nullable | |
hidden_time | datetime | Nullable | |
hidden_by | unsigned int(10) | foreign key (fs_foodsaver:id), Nullable | |
hidden_reason | varchar(255) | Nullable |
Table fs_usernotes_has_wallpost
Description - fs_usernotes_has_wallpost
connects organotes on users with wallposts
Open todos from old documentation - fs_usernotes_has_wallpost
- recreate missing users
- remove broken entries (for wallposts)
Table columns - fs_usernotes_has_wallpost
Column | Description | Type | properties |
---|---|---|---|
usernotes_id | unsigned int(10) | Primary Key | |
wallpost_id | unsigned int(10) | Primary Key, foreign key (fs_wallpost:id) | |
usercomment | int(4) |
Table fs_verify_history
Description - fs_verify_history
Table columns - fs_verify_history
Column | Description | Type | properties |
---|---|---|---|
fs_id | unsigned int(10) | Nullable | |
date | datetime | ||
bot_id | unsigned int(10) | Nullable | |
change_status | int(1) | Nullable |
Table fs_wallpost
Description - fs_wallpost
Table columns - fs_wallpost
Column | Description | Type | properties |
---|---|---|---|
id | unsigned int(10) | Primary Key, Auto-Increment | |
foodsaver_id | unsigned int(10) | ||
body | text(16777215) | Nullable | |
time | datetime | Nullable | |
attach | text(16777215) | Nullable |
Table phinxlog
Description - phinxlog
Table columns - phinxlog
Column | Description | Type | properties |
---|---|---|---|
version | int(20) | Primary Key | |
migration_name | varchar(100) | Nullable | |
start_time | timestamp | Nullable | |
end_time | timestamp | Nullable | |
breakpoint | int(1) |
Table uploads
Description - uploads
Table columns - uploads
Column | Description | Type | properties |
---|---|---|---|
uuid | char(36) | Primary Key | |
user_id | unsigned int(10) | ||
sha256hash | char(64) | ||
mimeType | varchar(255) | ||
uploaded_at | datetime | ||
lastaccess_at | datetime | ||
filesize | unsigned int(10) | ||
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(4) | 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_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, UPDATE)
- fs_basket_anfrage (INSERT, SELECT)
- fs_basket_has_art (INSERT)
- fs_basket_has_types (INSERT)
- 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_blog_entry (UPDATE)
- fs_foodsaver (SELECT)
- fs_foodsaver_has_options (SELECT)
Commands
- fs_feature_toggles (INSERT)
Content
- fs_content (DELETE, INSERT, SELECT, UPDATE)
DTO
Dev
- fs_bezirk (, SELECT)
- fs_region_function (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_email_blacklist (SELECT)
- fs_email_status (DELETE)
- fs_fairteiler_follower (DELETE)
- fs_foodsaver (, SELECT, UPDATE)
- fs_foodsaver_archive (INSERT)
- fs_foodsaver_has_bell (DELETE)
- fs_foodsaver_has_bezirk (DELETE, SELECT)
- fs_foodsaver_has_contact (DELETE)
- fs_foodsaver_has_event (DELETE)
- fs_foodsaver_has_wallpost (DELETE)
- fs_mailbox_member (DELETE)
- fs_mailchange (DELETE)
- fs_pass_gen (DELETE)
- fs_pass_request (DELETE)
- fs_quiz_session (DELETE)
- fs_rating (DELETE)
- fs_region_function (SELECT)
- fs_theme_follower (DELETE)
- fs_verify_history (INSERT, SELECT)
Group
- fs_betrieb (SELECT)
- fs_bezirk (DELETE, SELECT)
- fs_bezirk_closure (DELETE, INSERT, SELECT)
- fs_botschafter (SELECT)
- fs_fairteiler (SELECT)
- fs_mailbox (SELECT)
- fs_region_function (DELETE, INSERT, SELECT)
Info
- fs_theme_follower (SELECT)
Legal
- fs_betrieb_team (UPDATE)
- fs_botschafter (DELETE)
- fs_content (SELECT)
- fs_foodsaver (UPDATE)
Login
- fs_email_blacklist (SELECT)
- 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, UPDATE)
- fs_foodsaver_has_contact (INSERT)
- fs_mailbox (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_bezirk (SELECT)
- fs_foodsaver (SELECT, UPDATE)
- fs_foodsaver_has_bezirk (INSERT)
- fs_ipblock (DELETE)
Map
- fs_basket (SELECT)
- fs_betrieb (SELECT)
- fs_bezirk (SELECT)
- fs_fairteiler (SELECT)
- fs_region_pin (SELECT)
Message
- fs_betrieb (SELECT)
- fs_conversation (DELETE, INSERT, SELECT, UPDATE)
- fs_foodsaver (SELECT)
- fs_foodsaver_has_conversation (DELETE, INSERT, SELECT, UPDATE)
- fs_msg (DELETE, INSERT)
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_rating (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_foodsaver (SELECT)
- fs_foodsaver_has_bezirk (INSERT, SELECT)
- fs_mailbox (SELECT)
- fs_region_options (INSERT, SELECT)
- fs_region_pin (INSERT, SELECT)
- fs_theme (DELETE, INSERT, SELECT, UPDATE)
- fs_theme_follower (DELETE, INSERT, SELECT)
- fs_theme_post (, DELETE, SELECT, UPDATE)
Report
- fs_foodsaver (SELECT)
- fs_report (DELETE, 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_foodsaver (UPDATE)
- 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_betrieb (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 (UPDATE)
- fs_foodsaver_has_bezirk (SELECT)
- fs_rating (SELECT)
- fs_report (SELECT)
- 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 (INSERT, SELECT, UPDATE)
- fs_betrieb_has_lebensmittel (DELETE, INSERT, SELECT)
- fs_betrieb_team (DELETE, INSERT, SELECT, UPDATE)
- fs_bezirk (SELECT)
- fs_bezirk_closure (SELECT)
- fs_chain (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)
StoreCategories
- fs_betrieb (SELECT)
- fs_betrieb_kategorie (DELETE, INSERT, SELECT, UPDATE)
StoreChain
- fs_betrieb (SELECT)
- fs_chain (INSERT, SELECT)
- fs_foodsaver (SELECT)
- fs_key_account_manager (DELETE, INSERT, SELECT)
Unclassified
- fs_bell (DELETE)
- fs_betrieb (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_wallpost (DELETE, INSERT, SELECT)
WorkGroup
- fs_bezirk (SELECT)
- fs_botschafter (SELECT)
- fs_foodsaver (SELECT)
- fs_foodsaver_has_bezirk (SELECT)
- fs_mailbox (SELECT)
- fs_region_function (SELECT)