In the past I have created my tables with PK and FK values, but not defined to the database, that is, I have written my own SQL to display the relationships between tables.
In the example below, I have the following tables:
Users, InterestCategory, InterestSubCategory, and UserInterestCategory...