PUBSUB_CONSUMER



Column Section Relationship Section Top of Page


Table-level Detail

Description: PUBSUB_CONSUMER
Definition: A list of consumers and the topic where they expect events they subscribed to go.
Table Type: REFERENCE





Column Detail - PUBSUB_CONSUMER


Column Name Type Null? Definition
CONSUMER_DESC VARCHAR(100) Y Discription of a consumer
CONSUMER_NAME VARCHAR(255) Y The unique name of the Consumer
MAPPED_TEQ_QUEUE_NAME VARCHAR(122) Y Name of the internally-assigned TEQ queue on the Millennium database where events associated to this topic are published
MAPPED_TEQ_SUBSCRIBER VARCHAR(122) Y Name of the internally-assigned TEQ Subscriber
PUBSUB_CONSUMER_ID DOUBLE N PRIMARY KEY
UPDT_APPLCTX DOUBLE Y The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE Y Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - PUBSUB_CONSUMER




Parent Column in PUBSUB_CONSUMER (PK) Child Table Name Child Column Name
Children: PUBSUB_CONSUMER_ID PUBSUB_SUBSCRIPTION PUBSUB_CONSUMER_ID


PUBSUB_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: PUBSUB_EVENT
Definition: Stores list of producer-owned event types eligible for publishing in the Millennium pub/sub system.
Table Type: REFERENCE





Column Detail - PUBSUB_EVENT


Column Name Type Null? Definition
EVENT_DESC VARCHAR(100) Y Description of the Event
EVENT_NAME VARCHAR(64) Y The unique name of the Event
PUBSUB_EVENT_ID DOUBLE N PRIMARY KEY
PUBSUB_TOPIC_ID DOUBLE Y Events published for this consumer will be published to this topic
UPDT_APPLCTX DOUBLE Y The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE Y Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - PUBSUB_EVENT


Child Column in PUBSUB_EVENT(FK) Parent Table Name Parent Column Name
Parents: PUBSUB_TOPIC_ID PUBSUB_TOPIC PUBSUB_TOPIC_ID




Parent Column in PUBSUB_EVENT (PK) Child Table Name Child Column Name
Children: PUBSUB_EVENT_ID PUBSUB_EVENT_SCHEMA PUBSUB_EVENT_ID
PUBSUB_SUBSCRIPTION PUBSUB_EVENT_ID


PUBSUB_EVENT_SCHEMA



Column Section Relationship Section Top of Page


Table-level Detail

Description: PUBSUB_EVENT_SCHEMA
Definition: Stores list of Millennium pub/sub versioned payload schemas associated to event types
Table Type: REFERENCE





Column Detail - PUBSUB_EVENT_SCHEMA


Column Name Type Null? Definition
PARTITION_KEY_FIELD_NAME VARCHAR(400) Y A structured string identifier used to extract a field in the payload schema used for grouping/ordering related events into assigned pub/sub partitions.
PAYLOAD_SCHEMA_CLOB LONGTEXT Y String representation of structured payload schema convertible to a data format (e.g. JSON)
PAYLOAD_SCHEMA_ENCODING_TFLG VARCHAR(100) Y Identifies data format associated to payload_schema (default: JSON)
PUBSUB_EVENT_ID DOUBLE Y This is the value of the unique primary identifier of the PUBSUB_EVENT table. It is an internal system assigned number.
PUBSUB_EVENT_SCHEMA_ID DOUBLE N PRIMARY KEY
RELATION_KEY_FIELD_NAME VARCHAR(400) Y A structured string identifier optionally used to extract a field in the payload schema used for grouping related events for consumer-facing processing purposes.
UPDT_APPLCTX DOUBLE Y The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE Y Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VERSION_NBR DOUBLE Y This is the ascending verseion of the event schema - such that the row with the highest value for a given event type represents the latest version of the payload schema.



Relationship Detail - PUBSUB_EVENT_SCHEMA


Child Column in PUBSUB_EVENT_SCHEMA(FK) Parent Table Name Parent Column Name
Parents: PUBSUB_EVENT_ID PUBSUB_EVENT PUBSUB_EVENT_ID


PUBSUB_SUBSCRIPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: PUBSUB_SUBSCRIPTION
Definition: The present of a row in this table will cause a message to be published to the consumers topic when that event occurs. Rows are added and deleted, never updated.
Table Type: REFERENCE





Column Detail - PUBSUB_SUBSCRIPTION


Column Name Type Null? Definition
PUBSUB_CONSUMER_ID DOUBLE Y Consumer that wants the event published.
PUBSUB_EVENT_ID DOUBLE Y The event that will be published
PUBSUB_SUBSCRIPTION_ID DOUBLE N PRIMARY KEY
UPDT_APPLCTX DOUBLE Y The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE Y Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - PUBSUB_SUBSCRIPTION


Child Column in PUBSUB_SUBSCRIPTION(FK) Parent Table Name Parent Column Name
Parents: PUBSUB_CONSUMER_ID PUBSUB_CONSUMER PUBSUB_CONSUMER_ID
PUBSUB_EVENT_ID PUBSUB_EVENT PUBSUB_EVENT_ID


PUBSUB_TOPIC



Column Section Relationship Section Top of Page


Table-level Detail

Description: PUBSUB_TOPIC
Definition: Stores list of Millennium pub/sub topics and corresponding configuration - e.g. mapped TEQ queue name etc.
Table Type: REFERENCE





Column Detail - PUBSUB_TOPIC


Column Name Type Null? Definition
PUBSUB_TOPIC_ID DOUBLE N PRIMARY KEY
TOPIC_DESC VARCHAR(100) Y The description for the pub/sub topic
TOPIC_NAME VARCHAR(255) Y This is the unique name identifying the pub/sub topic
UPDT_APPLCTX DOUBLE Y The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE Y Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - PUBSUB_TOPIC




Parent Column in PUBSUB_TOPIC (PK) Child Table Name Child Column Name
Children: PUBSUB_TOPIC_ID PUBSUB_EVENT PUBSUB_TOPIC_ID