pool_address
represents the liquidity pool that the event is tied to and method
can be used to identify specific events. The above provides a single, primary key index, but you may find you want other indexes added based on scale and query patterns.