[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Foreign key constraint on ORDERITEMS table?

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.