I think much of your complications would have been solved and needing solutions such as negative primary keys if you had just built the tables using a GUID as your...