Really, transaction table will eventually grow far beyond number of items (7500000). But I see nothing wrong with the above design. You need proper indexing, probably partitioning, enterprise feature.