G. SQL Table Relationships

The relationships and primary and foreign keys among the basic TADB tables are as follows.

  Relationship Name Primary key Table Primary Key Foreign key table Foreign Key
i FK_Items_ItemTypes ItemTypes pKey Items fItemType
ii Fk_TrkAttributes_Items Items pKey TrkAttributes fItems
iii FK_Items_TrkRegions TrkRegions regionID Items region1ID
iv FK_Items_TrkGroups TrkGroups groupID Items groupID
v FK_Relateditems_Items_Child Items pKey RelatedItems cItems
FK_Relateditems_Items_Parent Items pKey RelatedItems pItems