Description
Fields that do not necessarily belong to all subtypes of an entity.
Remarks
This table identifies a field in a primary entity table as belonging to a subtype.
Descriptive IDs are used instead of simple record IDs because subtypes can be created by various tools and extensions. Since this can be done in any order, an ordinary record ID based on order of creation does not identify the subtype-field pair across projects or installations.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| ESTF_SUBTYPE_ID | The identifier of this field as a member of a specific subtype.The ENTITY_SUBTYPES.EST_ID of the subtype to | varchar | 100 | ||||
| ESTF_SF_COLUMN_NAME | The name of the column in the primary entity type table. For example, TS_USER_17 from the TEST table. | varchar | 40 | ||||
| ESTF_ENTITY_TABLE_NAME | The name of the table that contains the primary entity type. For example: TEST, REQ, and so on. | varchar | 40 |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| ESTF_SUBTYPE_FIELDS_IDX |  |
See Also