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.

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.

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 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.

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.

Impact Analysis

Enables you to view and specify information to be used by Oracle Warehouse Builder for impact analysis.

Scripts

Enables you to specify scripts 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.

Include into DDL Script: Controls whether the text of the specified scripts is included into the DDL script for operations on the table.

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

See Common Information in Dialog Boxes.