|
|
|
In the physical model, you can create the following types of tables:
A table box has a horizontal line, which divides the box. You can enter the primary key above the line and non-keys below the line. You can choose to migrate keys to either the primary or non-key area of the box.
When you add a table, the table type is determined based on its relationship. For example, when you initially place a table into a model, it is represented as an independent table. When you connect the table to another table using a relationship, a table is designated as independent or dependent based on the relationship type. If a table is a child table in an identifying relationship, it appears on the diagram window as a dependent table (table box with rounded corners). All other tables appear as independent tables (table box with square corners).
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |