Displaying 1 result from an estimated 1 matches for "raw_material_id".
2006 Jan 11
1
Composite primary key
...cookie_id *INT**,*
*PRIMARY* *KEY* *(*version*,* cookie_id*),*
*FOREIGN* *KEY* *(*cookie_id*)* *REFERENCES* Cookies*(*id*)*
*);*
*CREATE* *TABLE* `Ingredients`
*(*
`version` *INT**,*
cookie_id *INT**,*
raw_material_id *INT**,*
quantity *INT**,*
*PRIMARY* *KEY* *(*version*,* cookie_id*,* raw_material_id*),*
*FOREIGN* *KEY* *(*version*,* cookie_id*)* *REFERENCES* Recipes*(*
version*,* cookie_id*),*
*FOREIGN* *KEY* *(*raw_material_id*)* *REFERENCES* Raw_Materials*(...