Displaying 1 result from an estimated 1 matches for "raw_materials".
2006 Jan 11
1
Composite primary key
...osite primary key for a table in ActiveRecord?
For example the table Recipe which has the primary key [cookie id, version
number] where cookie id is also a foreign key referencing Cookie.
Also: Thanks to Nic and Adam for helping with the Cookie -> Cooky problem.
/Hugo
--SQL
*
CREATE* *TABLE* `Raw_Materials`*
(*
id *INT* AUTO_INCREMENT*,*
`name` *VARCHAR**(*30*),*
quantity *INT**,*
lastDelivery DATETIME*,*
*PRIMARY* *KEY* *(*id*)**
);*
*CREATE* *TABLE* `Cookies`
*(*
id *INT* AUTO_INCREMENT*,...