Property | Description | Values | Applicability |
Column Name | Name of the database column, chosen from a drop-down list consisting of all column names associated with the Entity Table Name (see Entity Properties). | Optional, if not specified, system will infer best match from database metadata. | |
Value Strategy | Strategy to use to generate unique value for this column. | Native, Table, Identity, Sequence, UUID | Optional. Only enabled if attribute is an element of the Entity Identity set. Only value strategies that make sense with respect to the attribute data type will be presented in the drop-down list. |
Value Sequence | The fully-qualified name of the sequence to be used. | Only enabled if attribute is an element of the Entity Identity set and Identity Strategy is Sequence. Required if enabled. | |
Value Table Name | The fully-qualified name of the identity table to be used, chosen from a drop-down list of all table names and sequence names. | Only enabled if attribute is an element of the Entity Identity set and Identity Strategy is Table. Optional. If not specified, the value will default to SEQUENCE_TABLE. | |
Value Table Name Column Name | The name of the column in the identity table that is used as the key (this column will contain the name of the entity). Chosen from a drop-down list of all columns in the table selected in the Table Name field. | Only enabled if attribute is an element of the Entity Identity set and Identity Strategy is Table. If not specified the value will default to SEQUENCE_NAME (String). | |
Value Table Value Column Name | The name of the column which holds the identity value. Chosen from a drop-down list of all columns in the table selected in the Table Name field. | Only enabled if attribute is an element of the Entity Identity set and Identity Strategy is Table. If not specified the value will default to NEXT_VAL (Big Integer). |
Strategy | Description |
Native | Allows database to choose best possible value strategy. |
Table | Uses a database table, whose name is specified in Identity Table Name. This table will have two columns: a name column and a value column. (Previously referenced as "increment".) |
Identity | Uses the native identity capability in DB2, SQL Server (the column is defined as an "identity" column in the database schema). |
Sequence | Uses sequence capability in DB2, PostgreSQL and Oracle. |
UUID | Generates 128-bit UUID string of 32 hex digits. (Previously referenced as "uuid-hex".) |
Property | Description | Values | Applicability |
Column Name | Name of the database column, chosen from a drop-down list consisting of all column names associated with the Entity Table Name (see Entity Properties). | Required. |