Table Relationships
Understanding Table Relationships
Review how imported keys, cardinality, and connecting columns describe the relationships SQL Mocker uses between tables.
Steps
1
Review the imported keys
Confirm the primary or unique key that identifies the parent-side record at the expected grain.
2
Review the connecting columns
Confirm the child reference and parent key supplied by the imported relationship metadata.
3
Confirm relationship cardinality
Check whether the reviewed relationship is one-to-one, one-to-many, or many-to-many through a bridge table.
4
Confirm the generated join behavior
SQL Mocker selects the join type from the reviewed relationship path and the user's question. Review the generated SQL to confirm that unmatched rows are preserved or excluded as intended.
Learn more
Guide: Select tables and review generated joinsOpen the relevant SQL Mocker tool
Continue with this workflow in SQL Mocker when you are ready.