Lets you specify the default display level for the physical model. Select one of the following display levels from the drop-down list:
Table
Specifies to use the Table Display Level for the physical model, which displays only the table name in the diagram.
Column
Specifies to use the Column Display Level for the physical model, which displays the column names of the table.
Comment
Specifies to use the Comment Display Level for the physical model, which displays comments in the table.
Primary Key
Specifies to use the Primary Key Display Level for the diagram, which displays primary key columns in the table.
Physical Order
Specifies to display the columns in the same order in which they appear in the physical database. This option lets you mirror the physical structure of your database in the ERwin physical model. This display mode contrasts with the Column display level, which corresponds to the index order in the ERwin logical model.
Note: The physical order may not be preserved when you forward engineer a physical model. When you use the Forward Engineering tool, you can indicate physical order or column order for the generated schema. Column order is used to generate the database schema for Primary Keys and Alter statements.
Icon
Specifies to use the Icon Display Level (large entity icon) in the diagram, which displays a bitmap in the diagram.
Key
Specifies to use the Key display level in the diagram, which displays the key name in the table box.
Collapse Fact
Specifies to hide fact table columns in a dimensional model. This option is only available if you use the DM (Dimensional Modeling) notation for your physical model.
Collapse Dimension
Specifies to hide dimension table columns in a dimensional model. This option is only available if you use the DM (Dimensional Modeling) notation for your physical model.
Lets you specify display options for tables in the physical model. Select any or all of the following display options:
Show Attributes/Columns as Grid
Specifies to display the attributes or columns as a grid.
Display Column Datatype
Specifies to display the physical datatype for columns in the physical model. Clear to hide column datatypes.
Display Column Domain
Specifies to display the name of the domain attached to a column after the column name in the physical model. Clear to hide the domain name.
Display Column Null Option
Specifies to display NULL or NOT NULL values for columns in the diagram. Clear to hide NULL or NOT NULL values.
Display Physical Primary Key (PK) Designator
Specifies to display the primary key designator () for columns in the physical model. Clear to hide the primary key designator.
Display Physical Foreign Key (FK) Designator
Specifies to display the foreign key designator (FK) for columns in the physical model. Clear to hide the foreign key designator.
Display Physical Alternate Key (AK) Designator
Specifies to display the alternate key (AK) and inversion entry (IE) designator for columns in the physical model. Clear this check box to hide the alternate key and inversion entry designators. The Alternate Key Designator (AK) display option displays extended notation to show the order of concatenation as defined in the Index editor.
Dimensional Icon
Specifies to display dimensional table icons (Fact, Dimension, and Outrigger) in a dimensional model. Clear to hide dimensional icons. This option is only available if you use the DM (Dimensional Modeling) notation for your physical model.
Display Owner
Displays the name of the person who owns a table as a prefix to the table name. A TABLEOWNER.TABLENAME naming convention is used.
Display Owner for Non Current Users
Displays the table owner information for tables owned by users other than yourself. A TABLEOWNER.TABLENAME naming convention is used.
Display Ungenerated Tables
Displays tables that will not be generated when you generate the schema. A table is generated only when you select the Generate check box in the Tables editor.
Display Ungenerated Indexes
Displays indexes that will not be generated when you generate the schema. An index is generated only when you select the Generate check box in the Index editor.
