Query
CREATE TABLE household_preferences (
id CHAR(32) NOT NULL,
household_id CHAR(32) NOT NULL,
private_household BOOLEAN,
first_day_of_week INTEGER,
recipe_public BOOLEAN,
recipe_show_nutrition BOOLEAN,
recipe_show_assets BOOLEAN,
recipe_landscape_view BOOLEAN,
recipe_disable_comments BOOLEAN,
recipe_disable_amount BOOLEAN,
created_at DATETIME,
update_at DATETIME,
lock_recipe_edits_from_other_households BOOLEAN,
PRIMARY KEY (id),
FOREIGN KEY(household_id) REFERENCES households (id)
)