Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | TABLE_ENTITY |
| Short Name | TABENT |
| View Name | CI_TABLES_ENTITIES |
| Description | Entities implemented by a table. |
| Retrofitted from table TAB_ENTS | |
| TABLE from ENTITY and ENTITY to TABLE implementations | |
| Note on discriminator information in TABLE_ENTITY: | |
| -------------------------------------------------- | |
| When more than one entity is implemented via a single table, it | |
| is necessary to have in that table a column which identifies the | |
| type of each row (eg 'EMP'). This column is the "discriminator". | |
| 2 properties on TABLE_ENTITY are relevant to discriminators: | |
| COLUMN_REFERENCE is the foreign key to the column in the table | |
| in which this entity is implemented that acts as a discriminator. | |
| DISCRIMINATOR_VALUE is the value that discriminator column will | |
| take (eg 'EMP') to identify rows that represent the entity | |
| Sub-type of | INTERSECTION |
| Versioning: | Belongs to: RECORD versionable object SNAPSHOT_DEFINITION versionable object TABLE_DEFINITION versionable object VIEW_DEFINITION versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
TABLE_REFERENCE ENTITY_REFERENCE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_TABENT |
| Changes: | Summary of changes to TABLE_ENTITY in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| ENTITY_REFERENCE | N |
Prompt: Entity
Transferable only if null |
Must be of one and only one ENTITY | |
| TABLE_REFERENCE | N |
Prompt: Table
Transferable only if null |
Must be by one and only one RELATION_DEFINITION | |
| COLUMN_REFERENCE | Y | Prompt: Discriminator Column | May be discriminated by one and only one COLUMN | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| DISCRIMINATOR_VALUE | VARCHAR2(10) | Y | Value to be used as a discriminator (eg 'EMP') when entity is being implemented in a table with other entities
Prompt: Discriminator Value Uppercase | ||
| MAPPING_MODE | VARCHAR2(10) | Y | Non-displayed property populated by DDW, capturing the mode the user specified for this TABENT the last time it was used in DDW
Not displayed Uppercase | MAPPING_MODE | |
| MAPPING_TYPE | VARCHAR2(10) | Y | Determines how an entity is to be implemented in tables, when mapped super-entities exist, ie include columns for attributes and relationships of super-entity (OVERRIDE) or not (AUGMENT). Used by the Data Wizard (ex-DDD).
Prompt: Mapping Type Uppercase | MAPPING_TYPE | |
| REMARK | VARCHAR2(240) | Y | Any comments on the design decision concerning the entity/table mapping.
Prompt: Comment | ||
| PARENT_IVID | NUMBER(38, 0) | Y | Internal use only. Common repository version identifier of owning PAC
Not displayed System maintained Updatable only if null Defined on SE supertype | ||
| PAC_REFERENCE | NUMBER(38, 0) | Y | Internal use only. Contains the IRID of the PAC for the "versionable object" to which this element belongs
Not displayed System maintained Not updatable by user Defined on SE supertype | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| Other Properties |
|---|
| TABLE_ENTITY has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility |
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference TABLE_ENTITY:
Note: