ZCA_FEED_ELEMENTS
This table stores the feed elements for a given top level object feed.
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ZCA_FEED_ELEMENTS_PK |
FEED_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| FEED_ID | NUMBER | 18 | Yes | Auto generated primary key of the table. | |
| FEED_OBJ_ID | NUMBER | 18 | Yes | The id of the top level object that owns the feed element. | |
| FEED_OBJ_TYPE | VARCHAR2 | 64 | Yes | The name of the top level object that owns the feed element. | |
| EVENT_OBJ_TYPE | VARCHAR2 | 64 | Yes | The name of the actual object that owns the feed element. | |
| EVENT_OBJ_ID | NUMBER | 18 | Yes | The id of the actual object that owns the feed element. | |
| PARENT_OBJ_ID | NUMBER | 18 | The id of the parent object that owns the feed element. | ||
| PARENT_OBJ_TYPE | VARCHAR2 | 64 | The name of the parent object that owns the feed element. | ||
| EVENT_TYPE | VARCHAR2 | 225 | Yes | Type of event that generated the feed (e.g. CREATE, UPDATE, DELETE). | |
| EVENT_TIMESTAMP | TIMESTAMP | Yes | Event timestamp of the cloud event. | ||
| SIGNAL_ID | VARCHAR2 | 225 | Signal id of the cloud event. | ||
| SIGNAL_DEF_ID | VARCHAR2 | 225 | Signal definition id of the cloud event. | ||
| SIGNAL_CORRELATION_ID | VARCHAR2 | 225 | Signal correlation id of the cloud event. | ||
| ACTOR_PARTY_ID | NUMBER | 18 | The party id of the actor who created the event. | ||
| ACTOR_USERNAME | VARCHAR2 | 225 | Yes | The user name of the actor who created the event. | |
| ACTOR_TYPE | VARCHAR2 | 64 | The type of the actor, examples are Person, ESS System etc. | ||
| 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. | ||
| PAYLOAD | CLOB | The payload representing the cloud event. | |||
| SOURCE_SYSTEM_NAME | VARCHAR2 | 32 | Name of the system which generates the cloud event. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| ZCA_FEED_ELEMENTS_N1 | Non Unique | Default | CREATION_DATE | |
| ZCA_FEED_ELEMENTS_N2 | Non Unique | Default | LAST_UPDATE_DATE | |
| ZCA_FEED_ELEMENTS_N3 | Non Unique | Default | FEED_OBJ_ID | |
| ZCA_FEED_ELEMENTS_N4 | Non Unique | Default | FEED_OBJ_TYPE | Obsolete |
| ZCA_FEED_ELEMENTS_N5 | Non Unique | Default | EVENT_TYPE, FEED_OBJ_TYPE, EVENT_OBJ_TYPE | |
| ZCA_FEED_ELEMENTS_N6 | Non Unique | Default | FEED_OBJ_TYPE, EVENT_OBJ_ID, PARENT_OBJ_ID, PARENT_OBJ_TYPE, EVENT_OBJ_TYPE | |
| ZCA_FEED_ELEMENTS_U1 | Unique | Default | FEED_ID | |
| zca_feed_elements_U1 | Unique | Default | EVENT_OBJ_ID, EVENT_OBJ_TYPE, FEED_OBJ_ID, FEED_OBJ_TYPE, EVENT_TYPE, SIGNAL_ID, SOURCE_SYSTEM_NAME |