Is it allowed to for two tables to have two types of relationships between them?
19736
How to have a one-to-many relationship with a privileged child?
68346
What's the best way to join on the same table twice?
12265
Can a sql server table have two identity columns?
33176
Can I have multiple primary keys in a single table?
139969
How to represent it with UNIQUE indexes and foreign keys?
126419
Multiple one to many relationships in series
24963
How do you effectively model inheritance in a database?
16132
many to many relationship bridge table dilemma
124415
Select two independent tables in mysql
126514
Does anyone use Right Outer Joins?
51387
Can I create support multiple database transactions on a single connection?
58737
Two tables of content
141930
Implementing a "Both, Either-or, but Not Null" Requirement in a Database
138755
Designing a friendships database structure: Should I use a multivalued column?
154063
Database design help. many-to-many relationship
35704
How do you join on the same table, twice, in mysql?
41680
Pair of 2-tuple composite FKs pointing to same table (closure table pattern)