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

2. TADB SQL table structure overview.