Saga

Tables (3)

Correlation (CORRELATION)

  • CorrelationId (CORRELATION_ID) — varchar(200) — Primary key — NOT NULL
  • SagaKey (SAGA_KEY2) — varchar(200) — Foreign key → SagaInstanceParameter.SagaKey — NOT NULL
  • SagaObjectRootId (SAGA_OBJECT_ROOT_ID) — varchar(200) — Foreign key → SagaInstanceParameter.SagaObjectRootId — NOT NULL
  • Timestamp (TIME_STAMP) — varchar(50)
  • UseYn (USE_YN) — varchar(1)

SagaInstanceParameter (SAGA_INSTANCE_PARAMETER)

  • SagaKey (SAGA_KEY) — varchar(200) — Primary key — NOT NULL
  • SagaObjectRootId (SAGA_OBJECT_ROOT_ID) — varchar(200) — Primary key — NOT NULL
  • SagaObjectId (SAGA_OBJECT_ID) — varchar(200)
  • ServiceBeanName (SERVICE_BEAN_NAME) — varchar(100)
  • CurrentStepIndex (CURRENT_STEP_INDEX) — int
  • WorflowStatus (WORKFLOW_STATUS) — varchar(100)
  • WorkflowStepStatusList (WORKFLOW_STEP_STATUS_LIST) — varchar(200)
  • Timestamp (TIME_STAMP) — varchar(50)

SagaObject (SAGA_OBJECT)

  • SagaObjectId (SAGA_OBJECT_ID) — varchar(50) — Primary key — NOT NULL
  • SagaObjectRootId (SAGA_OBJECT_ROOT_ID) — varchar(200) — Foreign key → SagaInstanceParameter.SagaObjectRootId — NOT NULL
  • SagaObjectType (SAGA_OBJECT_TYPE) — varchar(100)
  • SagaObjectJson (SAGA_OBJECT_JSON) — varchar(4000)
  • Timestamp (TIME_STAMP) — varchar(50)