Relationships

Relationships define how models join to each other. They make cross-entity analysis possible.

What relationships specify

• Source and target: Which columns link the models

• Cardinality: The nature of the relationship (one-to-many, many-to-one, etc.)

• Join type: How to combine records (left, inner, right, full)

• Business meaning: Why this relationship exists

Explicit relationships prevent agents from guessing how to join tables—a major source of errors in text-to-SQL systems.