CREATE TABLE ingredient ( id SERIAL PRIMARY KEY, name TEXT NOT NULL UNIQUE ); CREATE TABLE recipe ( id SERIAL PRIMARY KEY, name TEXT NOT NULL UNIQUE ); CREATE TABLE component ( recipeid INTEGER REFERENCES recipe(id), ingredientid INTEGER REFERENCES ingredient(id), count INTEGER NOT NULL DEFAULT 1 );
Comments
0 B
|👍
/👎
0 B
|👍
/👎