MAPPED TO TABLE: chore_table String active -> active String assignmentConfig -> assignment_config String assignmentType -> assignment_type String consumeProductOnExecution -> consume_product_on... String description -> description PK int id -> id String name -> name String nextExecutionAssignedToUserId -> next_execution... String periodConfig -> period_config String periodDays -> period_days String periodInterval -> period_interval String periodType -> period_type String productAmount -> product_amount String productId -> product_id String rescheduledDate -> rescheduled_date String rescheduledNextExecutionAssignedToUserId -> res... String rollover -> rollover String startDate -> start_date String trackDateOnly -> track_date_only

MAPPED TO TABLE: chore_entry_table int choreId -> chore_id String choreName -> chore_name PK int id -> id String lastTrackedTime -> last_tracked_time String nextEstimatedExecutionTime -> next_estimated_ex... String nextExecutionAssignedToUserId -> next_execution... String trackDateOnly -> track_date_only

MAPPED TO TABLE: location_table String description -> description PK int id -> id String isFreezer -> is_freezer String name -> name String rowCreatedTimestamp -> row_created_timestamp Map<St userfields -> userfields

MAPPED TO TABLE: missing_item_table String amountMissing -> amount_missing PK int id -> id String isPartlyInStock -> is_partly_in_stock String name -> name

MAPPED TO TABLE: pending_product_table PK int id -> id String name -> name boolea nameIsFromOFF -> name_is_from_off

MAPPED TO TABLE: pending_product_barcode_table String amount -> amount String barcode -> barcode PK int id -> id String lastPrice -> last_price int pendingProductId -> pending_product_id String quId -> qu_id String storeId -> shopping_location_id

MAPPED TO TABLE: product_table String accumulateSubProductsMinStockAmount -> cumulate... String active -> active String autoReprintStockLabel -> auto_reprint_stock_label String calories -> calories String defaultConsumeLocationId -> default_consume_loc... String defaultDueDays -> default_best_before_days String defaultDueDaysAfterFreezing -> default_best_bef... String defaultDueDaysAfterOpen -> default_best_before_... String defaultDueDaysAfterThawing -> default_best_befo... String defaultStockLabelType -> default_stock_label_type String description -> description boolea displayDivider String dueDateType -> due_type String enableTareWeightHandling -> enable_tare_weight_... String hideOnStockOverview -> hide_on_stock_overview PK int id -> id String locationId -> location_id String minStockAmount -> min_stock_amount String moveOnOpen -> move_on_open String name -> name String noOwnStock -> no_own_stock String notCheckStockFulfillmentForRecipes -> not_check... String parentProductId -> parent_product_id Intege pendingProductId String pictureFileName -> picture_file_name String productGroupId -> product_group_id String quFactorPurchaseToStock -> qu_factor_purchase_t... String quIdConsume -> qu_id_consume String quIdPrice -> qu_id_price String quIdPurchase -> qu_id_purchase String quIdStock -> qu_id_stock String quickConsumeAmount -> quick_consume_amount String quickOpenAmount -> quick_open_amount String rowCreatedTimestamp -> row_created_timestamp String shouldNotBeFrozen -> should_not_be_frozen String storeId -> shopping_location_id String tareWeight -> tare_weight String treatOpenedAsOutOfStock -> treat_opened_as_out_... Map<St userfields -> userfields

MAPPED TO TABLE: product_average_price_table String price -> price PK int productId -> product_id

MAPPED TO TABLE: product_barcode_table String amount -> amount String barcode -> barcode PK int id -> id String lastPrice -> last_price String note -> note String productId -> product_id String quId -> qu_id String rowCreatedTimestamp -> row_created_timestamp String storeId -> shopping_location_id

MAPPED TO TABLE: product_group_table String description -> description PK int id -> id String name -> name String rowCreatedTimestamp -> row_created_timestamp Map<St userfields -> userfields

MAPPED TO TABLE: product_last_purchased_table String amount -> amount String bestBeforeDate -> best_before_date String locationId -> location_id String price -> price PK int productId -> product_id String purchasedDate -> purchased_date String shoppingLocationId -> shopping_location_id

MAPPED TO TABLE: quantity_unit_table String description -> description PK int id -> id String name -> name String namePlural -> name_plural String pluralForms -> plural_forms String rowCreatedTimestamp -> row_created_timestamp Map<St userfields -> userfields

MAPPED TO TABLE: quantity_unit_conversion_table double factor -> factor int fromQuId -> from_qu_id PK int id -> id String productId -> product_id String rowCreatedTimestamp -> row_created_timestamp int toQuId -> to_qu_id

MAPPED TO TABLE: quantity_unit_conversion_resolved_table

MAPPED TO TABLE: recipe_table Double baseServings -> base_servings String description -> description Double desiredServings -> desired_servings PK int id -> id String name -> name int notCheckShoppingList -> not_check_shoppinglist String pictureFileName -> picture_file_name String productId -> product_id String type -> type Map<St userfields -> userfields

MAPPED TO TABLE: recipe_fulfillment_table double calories -> calories double costs -> costs double costsPerServing -> costs_per_serving int dueScore -> due_score int missingProductsCount -> missing_products_count int needFulfilled -> need_fulfilled int needFulfilledWithShoppingList -> need_fulfilled... String productNamesCommaSeparated -> product_names_com... PK int recipeId -> recipe_id

MAPPED TO TABLE: recipe_nesting_table PK int id -> id int includesRecipeId -> includes_recipe_id int recipeId -> recipe_id double servings -> servings

MAPPED TO TABLE: recipe_pos_table double amount -> amount boolea checked PK int id -> id String ingredientGroup -> ingredient_group int notCheckStockFulfillment -> not_check_stock_ful... String note -> note int onlyCheckSingleUnitInStock -> only_check_single... double priceFactor -> price_factor int productId -> product_id int quantityUnitId -> qu_id int recipeId -> recipe_id String variableAmount -> variable_amount

MAPPED TO TABLE: recipe_pos_resolved_table double amountOnShoppingList -> amount_on_shopping_list double calories -> calories boolea checked int childRecipeId -> child_recipe_id double costs -> costs int dueScore -> due_score PK int id -> id String ingredientGroup -> ingredient_group int isNestedRecipePos -> is_nested_recipe_pos double missingAmount -> missing_amount int needFulfilled -> need_fulfilled int needFulfilledWithShoppingList -> need_fulfilled... int notCheckStockFulfillment String note -> note int onlyCheckSingleUnitInStock -> only_check_single... int productActive -> product_active String productGroup -> product_group int productId -> product_id int productIdEffective -> product_id_effective String productName -> product_name int quId -> qu_id double recipeAmount -> recipe_amount int recipeId -> recipe_id int recipePosId -> recipe_pos_id String recipeType -> recipe_type String recipeVariableAmount -> recipe_variable_amount double stockAmount -> stock_amount

MAPPED TO TABLE: server_table String alias -> alias String grocyApiKey -> grocy_api_key String grocyServerUrl -> grocy_server_url String homeAssistantServerUrl -> home_assistant_server... String homeAssistantToken -> home_assistant_token PK int id -> id

MAPPED TO TABLE: shopping_list_table PK int id -> id String name -> name String notes -> notes

MAPPED TO TABLE: shopping_list_item_table String amount -> amount String done -> done int doneSynced -> done_synced PK int id -> id String note -> note String productId -> product_id String quId -> qu_id String rowCreatedTimestamp -> row_created_timestamp String shoppingListId -> shopping_list_id

MAPPED TO TABLE: stock_entry_table double amount -> amount String bestBeforeDate -> best_before_date PK int id -> id String locationId -> location_id String note -> note int open -> open String openedDate -> opened_date String price -> price int productId -> product_id String purchasedDate -> purchased_date String rowCreatedTimestamp -> row_created_timestamp String shoppingLocationId -> shopping_location_id String stockId -> stock_id

MAPPED TO TABLE: stock_item_table String amount -> amount String amountAggregated -> amount_aggregated String amountOpened -> amount_opened String amountOpenedAggregated -> amount_opened_aggrega... String bestBeforeDate -> best_before_date String dueType -> due_type String isAggregatedAmount -> is_aggregated_amount boolea itemDue -> item_due boolea itemExpired -> item_expired boolea itemMissing -> item_missing boolea itemMissingAndPartlyInStock -> item_missing_par... boolea itemOverdue -> item_overdue Produc product PK int productId -> product_id String value -> value

MAPPED TO TABLE: stock_current_location_table String amount -> amount PK int autoId String isFreezer -> location_is_freezer int locationId -> location_id String locationName -> location_name int productId -> product_id

MAPPED TO TABLE: stock_item_table String amount String bestBeforeDate String correlationId int id String locationId String note String openedDate String price int productId String purchasedDate String recipeId String rowCreatedTimestamp String shoppingLocationId String spoiled String stockId String stockRowId String transactionId String transactionType String undone String undoneTimestamp String usedDate String userId

MAPPED TO TABLE: store_table String description -> description PK int id -> id String name -> name String rowCreatedTimestamp -> row_created_timestamp Map<St userfields -> userfields

MAPPED TO TABLE: stored_purchase_table String amount -> amount String bestBeforeDate -> best_before_date PK int id -> id String locationId -> location_id int pendingProductId -> pending_product_id String price -> price String purchasedDate -> purchased_date String storeId -> shopping_location_id

MAPPED TO TABLE: task_table String assignedToUserId -> assigned_to_user_id String categoryId -> category_id String description -> description Intege done -> done String doneTimeStamp -> done_timestamp String dueDate -> due_date PK int id -> id String name -> name

MAPPED TO TABLE: task_category_table String description -> description int displayDivider PK int id -> id String name -> name String rowCreatedTimestamp -> row_created_timestamp Map<St userfields -> userfields

MAPPED TO TABLE: user_table String displayName -> display_name String firstName -> first_name PK int id -> id String lastName -> last_name String pictureFileName -> picture_file_name String rowCreatedFilestamp -> row_created_timestamp String userName -> username

MAPPED TO TABLE: userfield_table String caption -> caption String defaultValue -> default_value String entity -> entity PK int id -> id String inputRequired -> input_required String name -> name String showAsColumnInTables -> show_as_column_in_tables String sortNumber -> sort_number String type -> type

MAPPED TO TABLE: volatile_item_table PK int id -> id int productId -> product_id int volatileType -> volatile_type