Properties of Tables

Each table in the database has the properties listed in the following list.

Entity Type—The name of the entity type in the data model that this table logically represents. This is read only in the Data Structure List.
Database—This is the database for which this table is implemented.
You cannot change which database implements this table in the Data Structure List. (If you need to change this, go to the Data Store List.)
The database name is a maximum of 8 characters.
Generic Name—A name that is consistent for the implemented entity type throughout all of the technical designs. It is called generic because it is not DBMS specific.
The generic name can be no more than 32 characters long. Change this name if you want the name of this table to be consistent throughout all of the technical designs, regardless of DBMS.
DBMS Name—Used by the specific DBMS generation to identify a table.
CA Gen uses the table name as the default table name, unless otherwise specified here or in the data model. If this name is changed in the data model, each time a transformation is made you would not have to change the name.
The DBMS table name can be no more than 32 characters long in the CA Gen model. Certain databases, however, only allow a maximum of 18 characters. Do not exceed 32 characters unless you are certain your database supports it.
Owner—Specifies your name or ID. The DDL uses this owner during processing.