Query

mealie.db — households

SQL

CREATE TABLE households  (
  id CHAR(32) NOT NULL,
  name VARCHAR NOT NULL,
  slug VARCHAR,
  group_id CHAR(32) NOT NULL,
  created_at DATETIME,
  update_at DATETIME,
  PRIMARY KEY (id),
  FOREIGN KEY(group_id) REFERENCES groups (id),
  CONSTRAINT household_name_group_id_key UNIQUE (group_id, name),
  CONSTRAINT household_slug_group_id_key UNIQUE (group_id, slug)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id CHAR(32) ✓ Rename | Drop
name VARCHAR Rename | Drop
slug VARCHAR ✓ Rename | Drop
group_id CHAR(32) Rename | Drop
created_at DATETIME ✓ Rename | Drop
update_at DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
group_id groups.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_households_created_at created_at SQL 
CREATE INDEX ix_households_created_at
ON households (created_at)
Drop
ix_households_group_id group_id SQL 
CREATE INDEX ix_households_group_id
ON households (group_id)
Drop
ix_households_name name SQL 
CREATE INDEX ix_households_name
ON households (name)
Drop
ix_households_slug slug SQL 
CREATE INDEX ix_households_slug
ON households (slug)
Drop
sqlite_autoindex_households_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_households_2
  • group_id
  • name
 ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_households_3
  • group_id
  • slug
 ✓ SQL
-- no sql found --
 Drop