Table Relationships
Review Suggested Relationships
Assess likely relationship candidates before allowing them to guide multi-table SQL generation.
Steps
1
Treat suggestions as candidates
A similar name or compatible type is not proof that two columns have the same business meaning.
2
Inspect both table grains
Confirm uniqueness, nullability, and expected one-to-many behavior.
3
Use supporting evidence
Review database documentation, trusted queries, views, and data-quality checks.
4
Confirm, correct, or remove
Keep only relationships that accurately represent the intended database logic.
Open the relevant SQL Mocker tool
Continue with this workflow in SQL Mocker when you are ready.