Foreign key constraint on ORDERITEMS table?

[Erik Huelsmann <..hidden..>]

Hi all,

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.

 'project_id' probably refers to project.id

 

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.

Comments?

Bye,

Erik.