Database Properties for Category to Child and Relationship shapes (Definition)

Use these options to associate columns in the parent and child tables and to enter role names for foreign keys.

Relationships indicate visually how the tables in your database model interact with one another, and editing their properties enables you to control how data is stored and retrieved in the database.

Unknown parent

Lists columns in the parent table.

<--Associate-->

Click to associate the two columns selected in the parent and child lists, creating a relationship.

Unknown child

Lists columns in the child table.

Foreign key role name

For IDEF1X models, type the role name defined by the foreign key relationship.

You can use this name to clarify the business rule that is reflected in this foreign key relationship.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×