PSC_TAB_DIFF_RESOLVER
This table contains table difference resolver information.
Details
-
Schema: FUSION
-
Object owner: PSC_TS
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
PSC_TAB_DIFF_RESOLVER_PK |
RID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| RID | NUMBER | 18 | Yes | This column is used to indicate rid | Active | |
| TRANS_MAJOR | VARCHAR2 | 256 | This column is used to indicate trans major | Active | ||
| TRANS_MINOR | VARCHAR2 | 20 | This column is used to indicate trans minor | Active | ||
| PARENT_ID | NUMBER | 20 | This column is used to indicate parent id | Active | ||
| CONFLICT_DESC | NUMBER | 4 | This column is used to indicate conflict desc | Active | ||
| DEF_NAME | VARCHAR2 | 256 | This column is used to indicate def name | Active | ||
| DEF_TYPE | VARCHAR2 | 256 | This column is used to indicate def type | Active | ||
| CONFLICT_ELEM | VARCHAR2 | 256 | This column is used to indicate conflict elem | Active | ||
| IS_EDIT_OBJECT_NUM | NUMBER | 1 | This column is used to indicate is edit object num | Active | ||
| EDIT_VALUE | VARCHAR2 | 1000 | This column is used to indicate edit value | Active | ||
| IS_TO_MERGE_OBJECT_NUM | NUMBER | 1 | This column is used to indicate is to merge object num | Active | ||
| TO_MERGE_VALUE | VARCHAR2 | 1000 | This column is used to indicate to merge value | Active | ||
| IS_OLD_OBJECT_NUM | NUMBER | 1 | This column is used to indicate is old object num | Active | ||
| OLD_VALUE | VARCHAR2 | 1000 | This column is used to indicate old value | Active | ||
| RESOLUTION | NUMBER | 4 | This column is used to indicate resolution | Active | ||
| NEW_VALUE | VARCHAR2 | 1000 | This column is used to indicate new value | Active | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
| 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. | Active |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| PSC_TAB_DIFF_RESOLVER_PK | Unique | Default | RID | Active |