DOO_TRANSACTION_EVENT_DETAILS
This table will store the EntityName,AttributeName, Attribute New and Old value for the triggering event.
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: TABLE
-
Tablespace: SUMMARY
Primary Key
Name | Columns |
---|---|
DOO_TXN_EVENT_DETAILS_PK |
TRANSACTION_EVENT_DETAIL_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
TRANSACTION_EVENT_DETAIL_ID | NUMBER | 18 | Yes | Unique Identifier of the DOO Transaction Event Details | |
TRANSACTION_EVENT_ID | NUMBER | 18 | Yes | Refers to the Transaction Event Id in DOO Transaction Events | |
EVENT_ENTITY_NAME | VARCHAR2 | 30 | Yes | Refers to the Entity Name for which the event is to be published. | |
EVENT_SOURCE_TRX_ID | NUMBER | 18 | Yes | Refers to the Identifier of the entity for which the event is to be published. | |
EVENT_ATTRIBUTE_NAME | VARCHAR2 | 30 | Yes | Refers to the attribute name on the entity on which the value has changed. | |
EVENT_ATTRIBUTE_TYPE | VARCHAR2 | 30 | Yes | Refers to the data type of the attribute on which the value has changed. | |
EVENT_ATTRIBUTE_NUM_VALUE | NUMBER | Refers to the new updated value of the attribute if the Event Attribute Type is NUMBER. | |||
EVENT_ATTRIBUTE_NUM_OLD_VALUE | NUMBER | Refers to the old value before the update of the attribute if the Event Attribute Type is NUMBER. | |||
EVENT_ATTRIBUTE_CHAR_VALUE | VARCHAR2 | 1000 | Refers to the new updated value of the attribute if the Event Attribute Type is CHAR. | ||
EVENT_ATTRIBUTE_CHAR_OLD_VALUE | VARCHAR2 | 1000 | Refers to the old value before the update of the attribute if the Event Attribute Type is CHAR. | ||
EVENT_ATTRIBUTE_DATE_VALUE | DATE | Refers to the new updated value of the attribute if the Event Attribute Type is DATE. | |||
EVENT_ATTRIBUTE_DATE_OLD_VALUE | DATE | Refers to the old value before the update of the attribute if the Event Attribute Type is DATE. | |||
EVENT_ATTRIBUTE_TIME_VALUE | TIMESTAMP | Refers to the new updated value of the attribute if the Event Attribute Type is TIMESTAMP. | |||
EVENT_ATTRIBUTE_TIME_OLD_VALUE | TIMESTAMP | Refers to the old value before the update of the attribute if the Event Attribute Type is TIMESTAMP. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
DOO_TRANSACTION_EVENT_DETAILS | doo_transaction_events | TRANSACTION_EVENT_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
DOO_TXN_EVENT_DETAILS_N1 | Non Unique | Default | TRANSACTION_EVENT_ID |
DOO_TXN_EVENT_DETAILS_N2 | Non Unique | Default | EVENT_SOURCE_TRX_ID |
DOO_TXN_EVENT_DETAILS_PK | Unique | Default | TRANSACTION_EVENT_DETAIL_ID |