Recipes

schema.sql 16 lines

Files · 8

emits.js175 lines
index.jsx403 lines
listens.js77 lines
manifest.json365 lines
model.js116 lines
schema.js2 lines
schema.sql16 lines
style.css57 lines

12345678910111213141516CREATE TABLE recipes (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT NOT NULL,
  description TEXT,
  url TEXT,
  author TEXT,
  date_published TEXT,
  prep_time TEXT,
  cook_time TEXT,
  total_time TEXT,
  recipe_yield TEXT,
  recipe_category TEXT,
  recipe_cuisine TEXT,
  recipe_ingredient TEXT NOT NULL DEFAULT '[]' CHECK (json_valid(recipe_ingredient) AND json_type(recipe_ingredient) = 'array'),
  recipe_instructions TEXT
);