Query

mealie.db — ingredient_foods_aliases

+/- table definition

Query 

CREATE TABLE ingredient_foods_aliases  (
  id CHAR(32) NOT NULL,
  food_id CHAR(32) NOT NULL,
  name VARCHAR NOT NULL,
  name_normalized VARCHAR,
  created_at DATETIME,
  update_at DATETIME,
  PRIMARY KEY (id, food_id),
  FOREIGN KEY(food_id) REFERENCES ingredient_foods (id)
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update upsert view : create view : drop