Retrieving Foreign Key Column Data Using Primary Key Column of a Table

Choosing Between Relational Tables and Column Serialization: A Scalable Approach to Complex Data Storage Decisions

Selecting all tables that reference a specific foreign key value in MySQL