Query

mealie.db — plan_rules_to_households

SQL

CREATE TABLE plan_rules_to_households  (
  group_plan_rule_id CHAR(32),
  household_id CHAR(32),
  FOREIGN KEY(group_plan_rule_id) REFERENCES group_meal_plan_rules (id),
  FOREIGN KEY(household_id) REFERENCES households (id),
  CONSTRAINT group_plan_rule_id_household_id_key UNIQUE (group_plan_rule_id, household_id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
group_plan_rule_id CHAR(32) ✓ Rename | Drop
household_id CHAR(32) ✓ Rename | Drop

Foreign Keys

Column Destination
household_id households.id
group_plan_rule_id group_meal_plan_rules.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_plan_rules_to_households_group_plan_rule_id group_plan_rule_id SQL 
CREATE INDEX ix_plan_rules_to_households_group_plan_rule_id
ON plan_rules_to_households (group_plan_rule_id)
Drop
ix_plan_rules_to_households_household_id household_id SQL 
CREATE INDEX ix_plan_rules_to_households_household_id
ON plan_rules_to_households (household_id)
Drop
sqlite_autoindex_plan_rules_to_households_1
  • group_plan_rule_id
  • household_id
 ✓ SQL
-- no sql found --
 Drop