Management Saga

Tables (3)

Compensation (COMPENSATION)

  • SagaKey (SAGA_KEY) — varchar(50) — Foreign key → SagaInstance.SagaKey — NOT NULL
  • AppName (APP_NAME) — varchar(20)
  • CompensationStatus (COMPENSATION_STATUS) — varchar(10)
  • CurrentStepIndex (CURRENT_STEP_INDEX) — int
  • Updated (UPDATED) — varchar(20)

EventMessage (EVENT_MESSAGE)

  • MessageId (MESSAGE_ID) — varchar(50) — Primary key — NOT NULL
  • MessageStatus (MESSAGE_STATUS) — varchar(3) — Primary key — NOT NULL
  • SagaKey (SAGA_KEY) — varchar(50) — Foreign key → SagaInstance.SagaKey — NOT NULL
  • AppName (APP_NAME) — varchar(20)
  • SagaFlag (SAGA_FLAG) — varchar(10)
  • MetaData (META_DATA) — longtext
  • Payload (PAYLOAD) — longtext
  • Topic (TOPIC) — varchar(50)
  • EventType (EVENT_TYPE) — longtext
  • TimeStamp (TIME_STAMP) — varchar(30)
  • Success (SUCCESS) — varchar(2)

SagaInstance (SAGA_INSTANCE)

  • SagaKey (SAGA_KEY) — varchar(50) — Primary key — NOT NULL
  • AppName (APP_NAME) — varchar(20)
  • SagaEvent (SAGA_EVENT) — varchar(50)
  • SagaObjectId (SAGA_OBJECT_ID) — varchar(50)
  • SagaObjectRootId (SAGA_OBJECT_ROOT_ID) — varchar(50)
  • SagaObjectType (SAGA_OBJECT_TYPE) — longtext
  • SagaObject (SAGA_OBJECT) — longtext
  • ServiceBeanName (SERVICE_BEAN_NAME) — varchar(50)
  • CurrentStepIndex (CURRENT_STEP_INDEX) — int
  • WorkflowStatus (WORKFLOW_STATUS) — varchar(10)
  • WorflowStepStatus (WORKFLOW_STEP_STATUS) — varchar(100)
  • Updated (UPDATED) — varchar(30)