Table Properties

This dialog box displays the properties of a table, which is part of Relational Models.

You can click Naming Rules to apply the current naming rules to specified types of objects related to this table definition. For example, if you applied naming rules to Check Constraints and if a table-level constraint was named PRODUCTS_Check, the name would be changed to PRODUCTS_CK (if the table name was PRODUCTS).

General

Name: Name of the table.

Long Name: Long name in the form: relational-model-name:table-name

Engineer: Controls whether the table will be considered during reverse engineering operations. If this option is disabled, this table and its properties are not considered when the relational model is reverse engineered into the logical model.

PK Name: Name of the primary key of the table.

Type: Classification type, from the list defined in the General Options. Examples: Fact, Dimension, Logging, Summary, Temporary.

Temp Table Scope: For a table classified as Temporary, you can specify a scope, such as Session or Dimension.

Register as Spatial Table: For a table with a column of type SDO_GEOMETRY, creates the spatial index and inserts the appropriate entry in the USER_SDO_GEOM_METADATA view.

Allow Type Substitution: For a structured type with Reference disabled, or for a structured type applied to a table, controls whether a substitutional structured type generation in the DDL is allowed.

Generate in DDL: Controls whether statements to create the table are included when DDL is generated.

Engineer as Relationship: Controls whether relationship attributes are created during engineering. (Relationships can be shown or hidden on diagrams.) If the table complies with the criteria for an intersection table, selecting this option will cause the table to be engineered as a many-to-many (m:n) relationship in which non-foreign-key columns become attributes of the relationship.

Allow Columns Reorder During Engineering: If this option is enabled, Data Modeler can reorder the attributes of the associated entity when the table is engineered to the logical model, for example, to place attributes considered more important first. (This behavior can be especially useful with tables that contain many columns.) If this option is not enabled, entity attributes are placed in the same order as their associated columns in the table definition.

Columns

Details tab

Lists the columns currently defined for the table. The properties for each column include its name and data type, and whether it is the primary key (PK), a foreign key (FK), or a required field (M, for mandatory).

To add a column, click the Add (+) icon; to delete a column, select it and click the Remove (X) icon; to view the properties of a column, double-click in the cell to the left of the name.

Overview tab

Lists each column, its data type, and if it is a primary key, foreign key, or mandatory.

Security tab

Lists each column and any relevant security-related properties for each: whether it contains personally identifiable information (PII), contains sensitive information, or should be masked when displayed.

Primary Key

Shows the current primary key (if any) of the table, and lets you change the primary key.

Unique Constraints

Lists any unique constraints. You can add, modify, and delete unique constraints. For each constraint, specify the column whose values must be unique or multiple columns that must have unique combinations of values.

Indexes

Lists the indexes currently defined for the table. The properties for each index include its name, its state, and whether to generate the index when the table is created.

To add an index, click the Add (+) icon; to delete an index, select it and click the Remove (X) icon; to view the properties of an index, double-click in the cell to the left of the name.

Table Level Constraints

Lists any table-level constraints that are defined by a validation rule (an expression that must evaluate to true for the data to be valid).

Foreign Keys

Lists the foreign keys currently defined for the table. The properties for each key include its name, its parent table, its delete rule, and whether to generate a foreign key constraint for it when the table is created.

To add a foreign key, click the Add (+) icon; to delete a foreign key, select it and click the Remove (X) icon; to view the properties of a foreign key, double-click in the cell to the left of the name.

Nested Columns

For each column based on a structured data type that has attributes, lists each attribute (in column-name.attribute-name format). For each attribute, you can specify whether it is the primary key (PK), a foreign key (FK), or a required field (M, for mandatory).

Oid Options and PK Columns

Displays any OID (object identifier) settings and primary key columns based on a structured type.

OID Is Primary Key: Indicates whether the OID is the primary key of the table.

User Defined or System Generated: Indicates whether the OID is user-defined or generated by the database system.

PK Columns for Table Based on Structured Type: Displays the column name and data type for primary key columns that are based on a structured type.

Volume Properties

Volumes: Minimum: Minimum data volume for the table.

Volumes: Expected: Expected or typical data volume for the table.

Volumes: Maximum: Maximum data volume for the table.

Growth Rate: Percent: Expected growth rate percentage for the table, for each period as specified in the next field.

Growth Rate: Year/Month/Day: The period (year, month, or day) to which the expected growth rate applies.

Normal Form: The required normal form (database normalization) for the table: None, First, Second, Third, or Fourth.

Adequately Normalized?: YES indicates that the model is sufficiently normalized. NO indicates that the model is not sufficiently normalized, and that additional normalization may be required on the relational model.

Spatial Properties

Displays any currently defined Oracle Spatial properties, each being a data column (type SDO_GEOMETRY or a function that evaluates to an SDO_GEOMETRY object) in the table. You can double-click an item's name to display its Spatial Definition Properties.

Column Groups

Displays information about column groups, which can be used to group related columns for possible use in generating a user interface. For example, a column group named Name could include columns first_name and last_name, and a column group named Address could include columns street_address, city, state, and postal_code.

To add a column group, click the Add (+) icon, specify the column group name, select the desired columns and move them to the right side, and optionally enter descriptive text in the Notes box; to delete a column group, select its entry and click the Remove (X) icon.

Comments in RDBMS

Comment text to be included in database objects that are generated based on this modeling object.

Scripts

Enables you to specify SQL statements to be run automatically at specified times or stages: before the table is dropped or renamed, before the table is created, after the table is created, and at the end of any script specified for the table. For example, for After Create for a table named MY_TABLE, you might specify the following statement (and also check Include into DDL Script):

INSERT INTO my_table SELECT * FROM your_table

Include into DDL Script: Controls whether the text of the specified statements is included in the generated DDL script for creating the table.

Comments, Notes, Impact Analysis, Measurements, Change Requests, Responsible Parties, Documents, Summary

See Common Information in Dialog Boxes.