Query

mealie.db — households_to_tools

SQL

CREATE TABLE households_to_tools  (
  household_id CHAR(32),
  tool_id CHAR(32),
  FOREIGN KEY(household_id) REFERENCES households (id),
  FOREIGN KEY(tool_id) REFERENCES tools (id),
  CONSTRAINT household_id_tool_id_key UNIQUE (household_id, tool_id)
)

+ Add column

Columns

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

Foreign Keys

Column Destination
tool_id tools.id
household_id households.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_households_to_tools_household_id household_id SQL 
CREATE INDEX ix_households_to_tools_household_id
ON households_to_tools (household_id)
Drop
ix_households_to_tools_tool_id tool_id SQL 
CREATE INDEX ix_households_to_tools_tool_id
ON households_to_tools (tool_id)
Drop
sqlite_autoindex_households_to_tools_1
  • household_id
  • tool_id
 ✓ SQL
-- no sql found --
 Drop