[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Foreign key constraint on ORDERITEMS table?
- Subject: Foreign key constraint on ORDERITEMS table?
- From: Erik Huelsmann <..hidden..>
- Date: Fri, 27 Apr 2012 17:00:04 +0200
Currently there are no foreign key constraints on the ORDERITEMS table, yet there are a number of columns referring to other tables:
'trans_id' refers to oe.id
(at least, that's what I understood from Chris)
'parts_id' refers to part.id
, of course.
So, it looks like there should be 3 foreign keys on the table just to document the data model better if nothing else. Especially the trans_id <-> oe.id
relationship does not seem very straight forward.