ZCA_SIGNAL_CONSUMERS
ZCA_SIGNAL_CONSUMERS: This table will contain topological information related to Signals Consumer registration for use in Spectra OCI.
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ZCA_SIGNAL_CONSUMERS_PK |
SIGNAL_CONSUMER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SIGNAL_CONSUMER_ID | NUMBER | 18 | Yes | Auto generated primary key of the table | |
| SIGNAL_TOPIC_NAME | VARCHAR2 | 512 | Yes | The Topic Name value which corresponds to the "TopicName" referenced in a Signal Definition Configuration document | |
| DELIVERY_TYPE | VARCHAR2 | 1000 | Yes | The type of delivery which this consumer registration records corresponds to. Values may include "WebHook", "Stream", "Queue", etc. | |
| DELIVERY_NAME | VARCHAR2 | 512 | Yes | The target name of the delivery implementation. The usage of this value depends on the delivery type, for example this will be used to store the ONS Logical Topic Name for WebHook delivery type. | |
| DELIVERY_ENDPOINT | VARCHAR2 | 4000 | For delivery types that correspond to a physical endpoint, such as "WebHook", store the URN. | ||
| CONSUMER_DETAILS | CLOB | An optional JSON document used to store subsidiary information required to initiate the runtime connection. | |||
| 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. | ||
| 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 |
|---|---|---|---|
| ZCA_SIGNAL_CONSUMERS_UK1 | Unique | Default | SIGNAL_CONSUMER_ID |
| ZCA_SIGNAL_CONSUMERS_UK2 | Unique | Default | SIGNAL_TOPIC_NAME, DELIVERY_NAME |