PSC_OPA_SYNC_ENTITY

Details

Schema: FUSION
Object owner: PSC_TS
Object type: TABLE
Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
PSC_OPA_SYNC_ENTITY_MODEL_PK	SYNC_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
SYNC_ID	NUMBER		18	Yes	This column is used to indicate sync id	Active
APP_MODULE_DEFINITION	VARCHAR2	200			This column is used to indicate app module definition	Active
APP_MODULE_CONFIG	VARCHAR2	100			This column is used to indicate app module config	Active
VIEW_OBJECT_NAME	VARCHAR2	100			This column is used to indicate view object name	Active
FULL_VIEW_OBJECT_NAME	VARCHAR2	200			This column is used to indicate full view object name	Active
RESOURCE_NAME	VARCHAR2	100			This column is used to indicate resource name	Active
ENTITY_MODEL_NAME	VARCHAR2	30			This column is used to indicate entity model name	Active
META_DATA_MODEL_NAME	VARCHAR2	30			This column is used to indicate meta data model name	Active
IS_GLOBAL	VARCHAR2	1			This column is used to indicate is global	Active
CARDINALITY_WITH_GLOBAL	VARCHAR2	5			This column is used to indicate cardinality with global	Active
CHANGE_TYPE	VARCHAR2	20			This column is used to indicate change type	Active
SYNC_STATUS	VARCHAR2	20			This column is used to indicate sync status	Active
SYNC_MODE	NUMBER				This column is used to indicate sync mode	Active
SYNC_STATUS_NOTES	VARCHAR2	500			This column is used to indicate sync status notes	Active
CREATED_ON	TIMESTAMP				This column is used to indicate created on	Active
COMPLETED_ON	TIMESTAMP				This column is used to indicate completed on	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_OPA_SYNC_ENTITY_MODEL_N1	Non Unique	Default	SYNC_ID, VIEW_OBJECT_NAME, SYNC_STATUS	Active
PSC_OPA_SYNC_ENTITY_MODEL_PK	Unique	Default	SYNC_ID	Active