Using the same foreign key name in all tables to refer to a common primary key results in very large sql-queries when using many joins that contain the same refKey.
The transactions table should be renamed to event_transactions like the other tables that have references to the events table.
Using the same foreign key name in all tables to refer to a common primary key results in very large sql-queries when using many joins that contain the same refKey.
The
transactionstable should be renamed toevent_transactionslike the other tables that have references to the events table.