CZ_OBJECT_VERSIONS
A row of this table represents a version/draft of a Configurator Versioned Object, such as Configurator Model, UI Template, UI Template map.
Details
-
Schema: FUSION
-
Object owner: CZ
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
Name | Columns |
---|---|
CZ_OBJECT_VERSIONS_PK |
OBJECT_VERSION_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
OBJECT_VERSION_ID | NUMBER | 18 | Yes | System generated unique identifier (surrogate key) of the Configurator Versioned Object. | |
OBJECT_ID | NUMBER | 18 | Yes | System generated unique identifier of the Configurator Versioned Object. | |
VERSION | NUMBER | 18 | Yes | Indicates the unique version of a Configurator Object Version. When Project is in development, this column will have system generated negative version number that uniquely identifies the draft. When the project is released successfully, this column will have integer converted user given positive version number. User given released version number will be converted to integer by multiplying with 100. For example, user given version 1.1 will be 110. | |
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
WORKSPACE_ID | NUMBER | 18 | Yes | Identifier of the associated Configurator Workspace. | |
OBJECT_TYPE | VARCHAR2 | 30 | Yes | Indicates the Configurator Versioned Object Type. The valid values are: MODEL, UI_TEMPLATE, UI_TEMPLATE_MAP. | |
VERSION_STATUS | VARCHAR2 | 30 | Yes | Indicates the status of the version. When the associated project is not released, then version will be in DRAFT status. When the associated project is released, then version will be in RELEASED status. | |
BASELINE_VERSION | NUMBER | 18 | Yes | Indicates the baseline version of this Object Version. When there are no baseline version, then the baseline version value will be 0. | |
PROPOSED_VERSION | NUMBER | 18 | This column is applicable only for drafts. When user overrides the default system generated version number, then that version will be populated in this column. | ||
DESCRIPTION | VARCHAR2 | 1000 | User given description of the version. | ||
DELETED_FLAG | NUMBER | 18 | Yes | This flag indicates the logical deletion of the row. The Non-Zero value represents deleted state and 0 represents not-deleted state. A user controlled background purge process will physically delete the orphaned rows with the Non-Zero flag value. | |
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CZ_OBJECT_VERSIONS_N1 | Non Unique | Default | OBJECT_ID, BASELINE_VERSION |
CZ_OBJECT_VERSIONS_N2 | Non Unique | Default | OBJECT_TYPE |
CZ_OBJECT_VERSIONS_U1 | Unique | Default | OBJECT_ID, OBJECT_TYPE, VERSION, DELETED_FLAG, ORA_SEED_SET1 |
CZ_OBJECT_VERSIONS_U11 | Unique | Default | OBJECT_ID, OBJECT_TYPE, VERSION, DELETED_FLAG, ORA_SEED_SET2 |
CZ_OBJECT_VERSIONS_U2 | Unique | Default | WORKSPACE_ID, OBJECT_ID, OBJECT_TYPE, DELETED_FLAG, ORA_SEED_SET1 |
CZ_OBJECT_VERSIONS_U21 | Unique | Default | WORKSPACE_ID, OBJECT_ID, OBJECT_TYPE, DELETED_FLAG, ORA_SEED_SET2 |
CZ_OBJECT_VERSIONS_U3 | Unique | Default | OBJECT_VERSION_ID, ORA_SEED_SET1 |
CZ_OBJECT_VERSIONS_U31 | Unique | Default | OBJECT_VERSION_ID, ORA_SEED_SET2 |