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.
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Ledger-smb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
