Physical DB: solutions
| Logical DB | Tables |
|---|---|
| shield | ACT_CAP_PROCESS_USER_MAPPING.sql |
| auth_db | TBL_USER_DEVICE_INFO.sql |
| auth_db | TBL_WEB_USER_TOKEN.sql |
| auth_db | AUTH_CONFIG_KEY_VALUES.sql |
| auth_db | TBL_USER_INFO.sql |
| auth_db | TBL_USER_IDENTIFIER.sql |
| auth_db | TBL_ORG.sql |
| auth_db | TMP_BRAND_USER_OTP.sql |
| auth_db | AUTH_CONFIG_KEYS.sql |
| auth_db | TBL_USER.sql |
| crimson | TBL_TEMP_ORY.sql |
| camunda | ACT_RU_INCIDENT.sql |
| camunda | ACT_HI_ACTINST.sql |
| camunda | ACT_ID_GROUP.sql |
| camunda | ACT_HI_PROCINST.sql |
| camunda | ACT_RU_JOBDEF.sql |
| camunda | ACT_RU_CASE_SENTRY_PART.sql |
| camunda | ACT_ID_MEMBERSHIP.sql |
| camunda | ACT_HI_CASEINST.sql |
| camunda | ACT_HI_IDENTITYLINK.sql |
| camunda | ACT_HI_TASKINST.sql |
| camunda | ACT_RE_DEPLOYMENT.sql |
| camunda | ACT_GE_SCHEMA_LOG.sql |
| camunda | ACT_RU_METER_LOG.sql |
| camunda | ACT_RU_EXT_TASK.sql |
| camunda | ACT_RE_CAMFORMDEF.sql |
| camunda | ACT_RU_EXECUTION.sql |
| camunda | ACT_HI_INCIDENT.sql |
| camunda | ACT_HI_ATTACHMENT.sql |
| camunda | ACT_HI_DETAIL.sql |
| camunda | ACT_GE_BYTEARRAY.sql |
| camunda | ACT_RE_PROCDEF.sql |
| camunda | ACT_RU_FILTER.sql |
| camunda | ACT_RU_CASE_EXECUTION.sql |
| camunda | ACT_HI_COMMENT.sql |
| camunda | ACT_RU_JOB.sql |
| camunda | ACT_RU_EVENT_SUBSCR.sql |
| camunda | ACT_HI_BATCH.sql |
| camunda | ACT_HI_DEC_IN.sql |
| camunda | ACT_HI_VARINST.sql |
| camunda | ACT_RU_TASK.sql |
| camunda | ACT_RU_AUTHORIZATION.sql |
| camunda | ACT_RU_BATCH.sql |
| camunda | ACT_GE_PROPERTY.sql |
| camunda | ACT_ID_TENANT.sql |
| camunda | ACT_RE_DECISION_REQ_DEF.sql |
| camunda | ACT_RU_VARIABLE.sql |
| camunda | ACT_HI_DEC_OUT.sql |
| camunda | ACT_RE_CASE_DEF.sql |
| camunda | ACT_ID_USER.sql |
| camunda | ACT_HI_OP_LOG.sql |
| camunda | ACT_RU_IDENTITYLINK.sql |
| camunda | ACT_RE_DECISION_DEF.sql |
| camunda | ACT_HI_EXT_TASK_LOG.sql |
| camunda | ACT_HI_JOB_LOG.sql |
| camunda | ACT_ID_INFO.sql |
| camunda | ACT_HI_CASEACTINST.sql |
| camunda | ACT_HI_DECINST.sql |
| camunda | ACT_RU_TASK_METER_LOG.sql |
| camunda | ACT_ID_TENANT_MEMBER.sql |
| gamification_db_new | REF_GAME_ITEM_METADATA.sql |
| gamification_db_new | TBL_GAME_ITEM_AUD.sql |
| gamification_db_new | TBL_LANGUAGE.sql |
| gamification_db_new | LOG_MERGE_USER.sql |
| gamification_db_new | TBL_REDEMPTION_AUD.sql |
| gamification_db_new | TBL_GAME_AUD.sql |
| gamification_db_new | REF_USER_GAME.sql |
| gamification_db_new | TBL_REDEMPTION.sql |
| gamification_db_new | REF_GAME_DETAILS.sql |
| gamification_db_new | REF_GAME_ITEM_DETAILS_AUD.sql |
| gamification_db_new | REF_GAME_DETAILS_AUD.sql |
| gamification_db_new | TBL_BRAND_AUD.sql |
| gamification_db_new | LOG_USER_REDEMPTION.sql |
| gamification_db_new | REVINFO.sql |
| gamification_db_new | REF_GAME_ITEM_DETAILS.sql |
| gamification_db_new | TBL_GAME_ITEM.sql |
| gamification_db_new | TBL_GAME.sql |
| gamification_db_new | USER_GAME_ITEM.sql |
| gamification_db_new | TBL_BRAND.sql |
| gamification_db_new | REF_GAME_ITEM_METADATA_AUD.sql |
| gamification_db_new | TBL_USER.sql |
| emigran | versions.sql |
| oauth_db | scope_resource_mapping.sql |
| oauth_db | audit_log.sql |
| oauth_db | client_otp.sql |
| oauth_db | template_language.sql |
| oauth_db | template.sql |
| oauth_db | auth_client.sql |
| oauth_db | client_scope_mapping.sql |
| oauth_db | config_key_values.sql |
| oauth_db | authorization_code.sql |
| oauth_db | session.sql |
| oauth_db | scopes.sql |
| oauth_db | config_keys.sql |
| rewards_utf8_db | TBL_ISSUE_REVENUE.sql |
| rewards_utf8_db | TBL_RICH_CONTENT_META.sql |
| rewards_utf8_db | TBL_VENDOR.sql |
| rewards_utf8_db | REF_REWARD_GEOGRAPHY.sql |
| rewards_utf8_db | TBL_PAYMENT_CONFIG_CURRENCY.sql |
| rewards_utf8_db | TBL_TRANSACTION_ACTION_LOG.sql |
| rewards_utf8_db | TBL_LANGUAGE.sql |
| rewards_utf8_db | TBL_GROUP.sql |
| rewards_utf8_db | TBL_REWARD_OWNER.sql |
| rewards_utf8_db | TBL_REWARD_REDEMPTION_TYPES.sql |
| rewards_utf8_db | REF_REWARD_CATEGORY.sql |
| rewards_utf8_db | TBL_REWARD_CONSTRAINT_AUD.sql |
| rewards_utf8_db | LOG_MERGE_USER.sql |
| rewards_utf8_db | TBL_USER_REWARD_LINK.sql |
| rewards_utf8_db | REF_REWARD_LABELS_MAPPING.sql |
| rewards_utf8_db | TBL_FULFILLMENT_DETAILS.sql |
| rewards_utf8_db | TBL_USER_REDEMPTION_DETAILS.sql |
| rewards_utf8_db | TBL_VENDOR_DETAILS_EXTN_PROPERTY.sql |
| rewards_utf8_db | TBL_MIGRATE_TRANSACTIONS.sql |
| rewards_utf8_db | TBL_VENDOR_REDEMPTION.sql |
| rewards_utf8_db | TBL_USER_PAYMENT_CONFIG.sql |
| rewards_utf8_db | TBL_USER_TENDER_ITEMS.sql |
| rewards_utf8_db | REF_REWARD_PROGRAM_MAPPING.sql |
| rewards_utf8_db | REF_REWARD_CARDS_MAPPING.sql |
| rewards_utf8_db | TBL_FULFILLMENT_STATUS.sql |
| rewards_utf8_db | TBL_VENDOR_REDEMPTION_ACTION.sql |
| rewards_utf8_db | TBL_USER_CUSTOM_FIELD_MAPPING.sql |
| rewards_utf8_db | TBL_REWARD_REVENUE.sql |
| rewards_utf8_db | TBL_CUSTOM_FIELD_ENUMS.sql |
| rewards_utf8_db | TBL_COUNTRY.sql |
| rewards_utf8_db | TBL_VENDOR_DETAILS.sql |
| rewards_utf8_db | REF_CATALOG_PROMOTION_DETAILS_AUD.sql |
| rewards_utf8_db | TBL_REWARD_DETAILS_EXTN_PROPERTY_VALUES.sql |
| rewards_utf8_db | TBL_REWARD_EXPIRY_REMINDER.sql |
| rewards_utf8_db | TBL_PAYMENT_CONFIG.sql |
| rewards_utf8_db | TBL_USER_PAYMENT_CONFIG_CURRENCY.sql |
| rewards_utf8_db | TBL_REWARD_UPLOAD.sql |
| rewards_utf8_db | REVINFO.sql |
| rewards_utf8_db | TBL_AREA.sql |
| rewards_utf8_db | TBL_USER_REWARD.sql |
| rewards_utf8_db | TBL_CATALOG_PROMOTION.sql |
| rewards_utf8_db | TBL_CUSTOM_FIELD_MAPPING.sql |
| rewards_utf8_db | REF_REWARD_DETAILS.sql |
| rewards_utf8_db | TBL_REWARD_CONSTRAINT.sql |
| rewards_utf8_db | TBL_CONFIG_KEYS.sql |
| rewards_utf8_db | TBL_REWARD.sql |
| rewards_utf8_db | TBL_CATEGORY.sql |
| rewards_utf8_db | REF_REWARD_COMMUNICATION.sql |
| rewards_utf8_db | TBL_LINK_REWARD_CATALOG_PROMOTION_AUD.sql |
| rewards_utf8_db | TBL_ISSUE_REVENUE_DETAIL.sql |
| rewards_utf8_db | TBL_USER_TENDER_DETAILS.sql |
| rewards_utf8_db | TBL_COMMUNICATION.sql |
| rewards_utf8_db | REF_REWARD_SEGMENT_MAPPING.sql |
| rewards_utf8_db | TBL_BRAND.sql |
| rewards_utf8_db | TBL_REWARD_DETAILS_EXTN_PROPERTY.sql |
| rewards_utf8_db | TBL_CITY.sql |
| rewards_utf8_db | REF_CATALOG_PROMOTION_DETAILS.sql |
| rewards_utf8_db | TBL_CATALOG_PROMOTION_AUD.sql |
| rewards_utf8_db | TBL_LINK_REWARD_CATALOG_PROMOTION.sql |
| rewards_utf8_db | TBL_TRANSACTION.sql |
| rewards_utf8_db | TBL_CUSTOM_FIELDS.sql |
| rewards_utf8_db | TBL_REWARD_ISSUE_SUMMARY.sql |
| rewards_utf8_db | TBL_VENDOR_DETAILS_EXTN_PROPERTY_VALUES.sql |
| rewards_utf8_db | TBL_REWARD_GROUP_MAPPING.sql |
| rewards_utf8_db | TBL_CONFIG_VALUES.sql |
| rewards_utf8_db | TBL_REWARD_ISSUE_SUMMARY_AUD.sql |
| rewards_utf8_db | TBL_DETAILS_SCOPE.sql |
| rewards_utf8_db | LOG_DOWNSTREAM_FAILURE.sql |
| orchestrator | MASTER_KEY_TBL.sql |
| orchestrator | DATA_KEY_VERSION_TBL.sql |
| orchestrator | ACT_CAP_ORG_NOTIFICATION_CREDENTIALS.sql |
| orchestrator | ACT_CAP_ORG_WORKFLOW_META.sql |
| orchestrator | ACT_CAP_EXTERNAL_API_ERROR_MAPPING.sql |
| orchestrator | DATA_KEY_TBL.sql |
| orchestrator | ACT_CAP_DYNAMIC_PROPERTIES.sql |
| orchestrator | ACT_CAP_CALLBACK_LOGS.sql |
| orchestrator | ACT_CAP_TRANSACTIONS.sql |
| orchestrator | ACTION_DATA_LOG.sql |
| orchestrator | ACT_CAP_ACTION_DATA.sql |
| orchestrator | ACT_CAP_ACTION_DATA_LOG.sql |
Table: ACT_CAP_PROCESS_USER_MAPPING
ACT_CAP_PROCESS_USER_MAPPING| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| process_instance_id | varchar(64) | Part of UNIQUE KEY (process_instance_id) |
| user_id | bigint(20) | None |
| org_id | bigint(20) | Part of UNIQUE KEY (org_id) |
| till_id | bigint(20) | None |
| store_id | bigint(20) | None |
| concept_id | bigint(20) | None |
| zone_id | bigint(20) | None |
| request_type | varchar(255) | None |
| process_def_key | varchar(255) | None |
| user_name | varchar(255) | None |
Table: TBL_USER_DEVICE_INFO
TBL_USER_DEVICE_INFO| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| DEVICE_ID | varchar(255) | Part of KEY (DEVICE_ID) |
| USER_KEY | varchar(5096) | None |
| USER_ID | bigint(20) | Part of KEY (USER_ID) |
| USER_TOKEN | varchar(5096) | None |
| IS_MFA | tinyint(1) | None |
Table: TBL_WEB_USER_TOKEN
TBL_WEB_USER_TOKEN| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| IS_VALID | bit(1) | None |
| USER_TOKEN | varchar(5096) | None |
| USER_ID | bigint(20) | Part of KEY (USER_ID) |
| CREATE_OR_UPDATE_TIMESTAMP | timestamp | None |
| IS_MFA | tinyint(1) | None |
Table: AUTH_CONFIG_KEY_VALUES
AUTH_CONFIG_KEY_VALUES| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| KEY_ID | bigint(20) | Part of KEY (KEY_ID) |
| VALUE | varchar(5000) | None |
| IS_ACTIVE | tinyint(1) | None |
| UPDATED_ON | timestamp | None |
| AUTO_UPDATE_TIME | timestamp | Part of KEY (AUTO_UPDATE_TIME) |
Table: TBL_USER_INFO
TBL_USER_INFO| Column Name | Data Type | Index |
|---|---|---|
| USER_ID | bigint(20) | Part of PRIMARY KEY (USER_ID) |
| DEFAULT_STORE | varchar(255) | None |
| FIRST_TRANSACTED_STORE | varchar(255) | None |
| LAST_TRANSACTED_STORE | varchar(255) | None |
Table: TBL_USER_IDENTIFIER
TBL_USER_IDENTIFIER| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| IDENTIFIER_TYPE | varchar(255) | Part of UNIQUE KEY (IDENTIFIER_TYPE) |
| IDENTIFIER_VALUE | varchar(255) | Part of UNIQUE KEY (IDENTIFIER_VALUE) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| USER_ID | bigint(20) | Part of KEY (USER_ID) |
Table: TBL_ORG
TBL_ORG| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| API_USER | varchar(255) | None |
| BRAND | varchar(255) | Part of KEY (BRAND) |
| ORG_KEY | varchar(512) | None |
| NAME | varchar(255) | None |
| PARENT | bigint(20) | Part of KEY (PARENT) |
| TOKEN_EXPIRY_IN_HOURS | int(11) | None |
| IS_SMS_ENABLED | bit(1) | None |
| SESSION_EXPIRY_IN_MINUTES | int(11) | None |
| SMS_BODY | varchar(1024) | None |
| DEFAULT_MOBILE_NO | varchar(255) | None |
| DEFAULT_OTP | varchar(255) | None |
| OTP_MAX_COUNT | int(11) | None |
| IS_PASSWORD_ENABLED | bit(1) | None |
| PASSWORD_REGEX | varchar(255) | None |
| OTP_TIMEOUT | int(11) | None |
| IS_MULTI_LOGIN_DISABLED | bit(1) | None |
| NETWORK_MAX_COUNT | int(11) | None |
| IS_MFA_ENABLED | bit(1) | None |
| MFA_PASSWORD_REGEX | varchar(255) | None |
| IS_MFA_PASSWORD_ENABLED | bit(1) | None |
Table: TMP_BRAND_USER_OTP
TMP_BRAND_USER_OTP| Column Name | Data Type | Index |
|---|---|---|
| SESSION_ID | varchar(255) | Part of PRIMARY KEY (SESSION_ID) |
| BRAND_NAME | varchar(255) | Part of KEY (BRAND_NAME) |
| DEFAULT_ORG_ID | bigint(20) | Part of KEY (DEFAULT_ORG_ID) |
| DEVICE_ID | varchar(255) | Part of KEY (DEVICE_ID) |
| MOBILE | bigint(20) | Part of KEY (MOBILE) |
| OTP | varchar(255) | None |
| OTP_ATTEMPT_COUNT | int(11) | None |
| OTP_EXPIRY | datetime | None |
| PASSWORD | varchar(255) | None |
| PASSWORD_ATTEMPT_COUNT | int(11) | None |
| IDENTIFIER_TYPE | varchar(255) | None |
| IDENTIFIER_VALUE | varchar(255) | None |
| IS_VALIDATED | bit(1) | None |
| SALT | varchar(255) | None |
| IS_MFA | bit(1) | None |
| PARENT_USER_ID | bigint(20) | None |
Table: AUTH_CONFIG_KEYS
AUTH_CONFIG_KEYS| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| NAME | varchar(100) | Part of KEY (NAME) |
| DEFAULT_VALUE | varchar(5000) | None |
| IS_ACTIVE | tinyint(1) | None |
| CREATED_ON | datetime | None |
| AUTO_UPDATE_TIME | timestamp | Part of KEY (AUTO_UPDATE_TIME) |
Table: TBL_USER
TBL_USER| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| MOBILE | bigint(20) | Part of UNIQUE KEY (MOBILE) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| INTOUCH_USER_ID | bigint(20) | Part of KEY (INTOUCH_USER_ID) |
| IS_REGISTERED | bit(1) | None |
| IS_SUBSCRIPTION_INVALID | bit(1) | None |
| CREATION_TIMESTAMP | datetime | None |
| ROLE | varchar(30) | None |
| STORE | varchar(255) | None |
| PASSWORD | varchar(255) | None |
| salt | varchar(255) | None |
| MFA_PASSWORD | varchar(255) | None |
| mfa_salt | varchar(255) | None |
| is_mfa_password_registered | bit(1) | None |
| is_mfa | tinyint(1) | None |
| PC_USER_ID | bigint(20) | None |
Table: TBL_TEMP_ORY
TBL_TEMP_ORY| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| NAME | varchar(20) | None |
Table: ACT_RU_INCIDENT
ACT_RU_INCIDENT| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| INCIDENTTIMESTAMP | datetime | None |
| INCIDENTMSG | varchar(4000) | None |
| INCIDENTTYPE | varchar(255) | None |
| EXECUTIONID | varchar(64) | Part of KEY (EXECUTIONID) |
| ACTIVITYID | varchar(255) | None |
| FAILEDACTIVITY_ID | varchar(255) | None |
| PROCINST_ID | varchar(64) | Part of KEY (PROCINST_ID) |
| PROCDEF_ID | varchar(64) | Part of KEY (PROCDEF_ID) |
| CAUSEINCIDENT_ID | varchar(64) | Part of KEY (CAUSEINCIDENT_ID) |
| ROOTCAUSE_INCIDENT_ID | varchar(64) | Part of KEY (ROOTCAUSE_INCIDENT_ID) |
| CONFIGURATION_ | varchar(255) | Part of KEY (CONFIGURATION_) |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
| JOBDEF_ID | varchar(64) | Part of KEY (JOBDEF_ID) |
| ANNOTATION_ | varchar(4000) | None |
Table: ACT_HI_ACTINST
ACT_HI_ACTINST| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of KEY (ID_) |
| PARENTACT_INST_ID | varchar(64) | None |
| PROCDEF_KEY | varchar(255) | Part of KEY (PROCDEF_KEY) |
| PROCDEF_ID | varchar(64) | Part of KEY (PROCDEF_ID) |
| ROOTPROC_INST_ID | varchar(64) | Part of KEY (ROOTPROC_INST_ID) |
| PROCINST_ID | varchar(64) | Part of KEY (PROCINST_ID) |
| EXECUTIONID | varchar(64) | Part of KEY (EXECUTIONID) |
| ACTID | varchar(255) | Part of KEY (ACTID) |
| TASKID | varchar(64) | None |
| CALLPROC_INST_ID | varchar(64) | None |
| CALLCASE_INST_ID | varchar(64) | None |
| ACTNAME | varchar(255) | None |
| ACTTYPE | varchar(255) | None |
| ASSIGNEE_ | varchar(64) | None |
| STARTTIME | datetime | Part of KEY (STARTTIME) |
| ENDTIME | datetime | Part of KEY (ENDTIME) |
| DURATION_ | bigint(20) | None |
| ACTINST_STATE | int(11) | Part of KEY (ACTINST_STATE) |
| SEQUENCECOUNTER | bigint(20) | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
| REMOVALTIME | datetime | Part of KEY (REMOVALTIME) |
Table: ACT_ID_GROUP
ACT_ID_GROUP| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| NAME_ | varchar(255) | None |
| TYPE_ | varchar(255) | None |
Table: ACT_HI_PROCINST
ACT_HI_PROCINST| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| PROCINST_ID | varchar(64) | Part of UNIQUE KEY (PROCINST_ID) |
| BUSINESSKEY | varchar(255) | Part of KEY (BUSINESSKEY) |
| PROCDEF_KEY | varchar(255) | Part of KEY (PROCDEF_KEY) |
| PROCDEF_ID | varchar(64) | Part of KEY (PROCDEF_ID) |
| STARTTIME | datetime | Part of KEY (STARTTIME) |
| ENDTIME | datetime | Part of KEY (ENDTIME) |
| REMOVALTIME | datetime | Part of KEY (REMOVALTIME) |
| DURATION_ | bigint(20) | None |
| STARTUSER_ID | varchar(255) | None |
| STARTACT_ID | varchar(255) | None |
| ENDACT_ID | varchar(255) | None |
| SUPERPROCESS_INSTANCE_ID | varchar(64) | None |
| ROOTPROC_INST_ID | varchar(64) | Part of KEY (ROOTPROC_INST_ID) |
| SUPERCASE_INSTANCE_ID | varchar(64) | None |
| CASEINST_ID | varchar(64) | None |
| DELETEREASON | varchar(4000) | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
| STATE_ | varchar(255) | None |
Table: ACT_RU_JOBDEF
ACT_RU_JOBDEF| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| PROCDEF_ID | varchar(64) | Part of KEY (PROCDEF_ID) |
| PROCDEF_KEY | varchar(255) | None |
| ACTID | varchar(255) | None |
| JOBTYPE | varchar(255) | None |
| JOBCONFIGURATION | varchar(255) | None |
| SUSPENSIONSTATE | int(11) | None |
| JOBPRIORITY | bigint(20) | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
| DEPLOYMENTID | varchar(64) | None |
Table: ACT_RU_CASE_SENTRY_PART
ACT_RU_CASE_SENTRY_PART| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| CASEINST_ID | varchar(64) | Part of KEY (CASEINST_ID) |
| CASEEXEC_ID | varchar(64) | Part of KEY (CASEEXEC_ID) |
| SENTRYID | varchar(255) | None |
| TYPE_ | varchar(255) | None |
| SOURCECASE_EXEC_ID | varchar(64) | None |
| STANDARDEVENT | varchar(255) | None |
| SOURCE_ | varchar(255) | None |
| VARIABLEEVENT | varchar(255) | None |
| VARIABLENAME | varchar(255) | None |
| SATISFIED_ | tinyint(1) | None |
| TENANTID | varchar(64) | None |
Table: ACT_ID_MEMBERSHIP
ACT_ID_MEMBERSHIP| Column Name | Data Type | Index |
|---|---|---|
| USERID | varchar(64) | Part of PRIMARY KEY (USERID) |
| GROUPID | varchar(64) | Part of KEY (GROUPID) |
Table: ACT_HI_CASEINST
ACT_HI_CASEINST| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| CASEINST_ID | varchar(64) | Part of UNIQUE KEY (CASEINST_ID) |
| BUSINESSKEY | varchar(255) | Part of KEY (BUSINESSKEY) |
| CASEDEF_ID | varchar(64) | None |
| CREATETIME | datetime | None |
| CLOSETIME | datetime | Part of KEY (CLOSETIME) |
| DURATION_ | bigint(20) | None |
| STATE_ | int(11) | None |
| CREATEUSER_ID | varchar(255) | None |
| SUPERCASE_INSTANCE_ID | varchar(64) | None |
| SUPERPROCESS_INSTANCE_ID | varchar(64) | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
Table: ACT_HI_IDENTITYLINK
ACT_HI_IDENTITYLINK| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| TIMESTAMP_ | timestamp | Part of KEY (TIMESTAMP_) |
| TYPE_ | varchar(255) | None |
| USERID | varchar(255) | Part of KEY (USERID) |
| GROUPID | varchar(255) | Part of KEY (GROUPID) |
| TASKID | varchar(64) | Part of KEY (TASKID) |
| ROOTPROC_INST_ID | varchar(64) | Part of KEY (ROOTPROC_INST_ID) |
| PROCDEF_ID | varchar(64) | None |
| OPERATIONTYPE | varchar(64) | None |
| ASSIGNERID | varchar(64) | None |
| PROCDEF_KEY | varchar(255) | Part of KEY (PROCDEF_KEY) |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
| REMOVALTIME | datetime | Part of KEY (REMOVALTIME) |
Table: ACT_HI_TASKINST
ACT_HI_TASKINST| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of KEY (ID_) |
| TASKDEF_KEY | varchar(255) | None |
| PROCDEF_KEY | varchar(255) | Part of KEY (PROCDEF_KEY) |
| PROCDEF_ID | varchar(64) | None |
| ROOTPROC_INST_ID | varchar(64) | Part of KEY (ROOTPROC_INST_ID) |
| PROCINST_ID | varchar(64) | Part of KEY (PROCINST_ID) |
| EXECUTIONID | varchar(64) | None |
| CASEDEF_KEY | varchar(255) | None |
| CASEDEF_ID | varchar(64) | None |
| CASEINST_ID | varchar(64) | None |
| CASEEXECUTION_ID | varchar(64) | None |
| ACTINST_ID | varchar(64) | None |
| NAME_ | varchar(255) | None |
| PARENTTASK_ID | varchar(64) | None |
| DESCRIPTION_ | varchar(4000) | None |
| OWNER_ | varchar(255) | None |
| ASSIGNEE_ | varchar(255) | None |
| STARTTIME | datetime | Part of KEY (STARTTIME) |
| ENDTIME | datetime | Part of KEY (ENDTIME) |
| DURATION_ | bigint(20) | None |
| DELETEREASON | varchar(4000) | None |
| PRIORITY_ | int(11) | None |
| DUEDATE | datetime | None |
| FOLLOWUP_DATE | datetime | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
| REMOVALTIME | datetime | Part of KEY (REMOVALTIME) |
Table: ACT_RE_DEPLOYMENT
ACT_RE_DEPLOYMENT| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| NAME_ | varchar(255) | Part of KEY (NAME_) |
| DEPLOYTIME | datetime | None |
| SOURCE_ | varchar(255) | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
Table: ACT_GE_SCHEMA_LOG
ACT_GE_SCHEMA_LOG| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| TIMESTAMP_ | datetime | None |
| VERSION_ | varchar(255) | None |
Table: ACT_RU_METER_LOG
ACT_RU_METER_LOG| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| NAME_ | varchar(64) | Part of KEY (NAME_) |
| REPORTER_ | varchar(255) | Part of KEY (REPORTER_) |
| VALUE_ | bigint(20) | None |
| TIMESTAMP_ | datetime | Part of KEY (TIMESTAMP_) |
| MILLISECONDS_ | bigint(20) | Part of KEY (MILLISECONDS_) |
Table: ACT_RU_EXT_TASK
ACT_RU_EXT_TASK| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| WORKERID | varchar(255) | None |
| TOPICNAME | varchar(255) | Part of KEY (TOPICNAME) |
| RETRIES_ | int(11) | None |
| ERRORMSG | varchar(4000) | None |
| ERRORDETAILS_ID | varchar(64) | Part of KEY (ERRORDETAILS_ID) |
| LOCKEXP_TIME | datetime | None |
| SUSPENSIONSTATE | int(11) | None |
| EXECUTIONID | varchar(64) | Part of KEY (EXECUTIONID) |
| PROCINST_ID | varchar(64) | None |
| PROCDEF_ID | varchar(64) | None |
| PROCDEF_KEY | varchar(255) | None |
| ACTID | varchar(255) | None |
| ACTINST_ID | varchar(64) | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
| PRIORITY_ | bigint(20) | Part of KEY (PRIORITY_) |
| LASTFAILURE_LOG_ID | varchar(64) | None |
Table: ACT_RE_CAMFORMDEF
ACT_RE_CAMFORMDEF| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| KEY_ | varchar(255) | None |
| VERSION_ | int(11) | None |
| DEPLOYMENTID | varchar(64) | None |
| RESOURCENAME | varchar(4000) | None |
| TENANTID | varchar(64) | None |
Table: ACT_RU_EXECUTION
ACT_RU_EXECUTION| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| ROOTPROC_INST_ID | varchar(64) | Part of KEY (ROOTPROC_INST_ID) |
| PROCINST_ID | varchar(64) | Part of KEY (PROCINST_ID) |
| BUSINESSKEY | varchar(255) | Part of KEY (BUSINESSKEY) |
| PARENTID | varchar(64) | Part of KEY (PARENTID) |
| PROCDEF_ID | varchar(64) | Part of KEY (PROCDEF_ID) |
| SUPEREXEC | varchar(64) | Part of KEY (SUPEREXEC) |
| SUPERCASE_EXEC | varchar(64) | None |
| CASEINST_ID | varchar(64) | None |
| ACTID | varchar(255) | None |
| ACTINST_ID | varchar(64) | None |
| ISACTIVE | tinyint(4) | None |
| ISCONCURRENT | tinyint(4) | None |
| ISSCOPE | tinyint(4) | None |
| ISEVENT_SCOPE | tinyint(4) | None |
| SUSPENSIONSTATE | int(11) | None |
| CACHEDENT_STATE | int(11) | None |
| SEQUENCECOUNTER | bigint(20) | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
Table: ACT_HI_INCIDENT
ACT_HI_INCIDENT| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| PROCDEF_KEY | varchar(255) | Part of KEY (PROCDEF_KEY) |
| PROCDEF_ID | varchar(64) | None |
| ROOTPROC_INST_ID | varchar(64) | Part of KEY (ROOTPROC_INST_ID) |
| PROCINST_ID | varchar(64) | Part of KEY (PROCINST_ID) |
| EXECUTIONID | varchar(64) | None |
| CREATETIME | timestamp | Part of KEY (CREATETIME) |
| ENDTIME | timestamp | Part of KEY (ENDTIME) |
| INCIDENTMSG | varchar(4000) | None |
| INCIDENTTYPE | varchar(255) | None |
| ACTIVITYID | varchar(255) | None |
| FAILEDACTIVITY_ID | varchar(255) | None |
| CAUSEINCIDENT_ID | varchar(64) | None |
| ROOTCAUSE_INCIDENT_ID | varchar(64) | None |
| CONFIGURATION_ | varchar(255) | None |
| HISTORYCONFIGURATION | varchar(255) | None |
| INCIDENTSTATE | int(11) | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
| JOBDEF_ID | varchar(64) | None |
| ANNOTATION_ | varchar(4000) | None |
| REMOVALTIME | datetime | Part of KEY (REMOVALTIME) |
Table: ACT_HI_ATTACHMENT
ACT_HI_ATTACHMENT| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| USERID | varchar(255) | None |
| NAME_ | varchar(255) | None |
| DESCRIPTION_ | varchar(4000) | None |
| TYPE_ | varchar(255) | None |
| TASKID | varchar(64) | Part of KEY (TASKID) |
| ROOTPROC_INST_ID | varchar(64) | Part of KEY (ROOTPROC_INST_ID) |
| PROCINST_ID | varchar(64) | Part of KEY (PROCINST_ID) |
| URL_ | varchar(4000) | None |
| CONTENTID | varchar(64) | Part of KEY (CONTENTID) |
| TENANTID | varchar(64) | None |
| CREATETIME | datetime | None |
| REMOVALTIME | datetime | Part of KEY (REMOVALTIME) |
Table: ACT_HI_DETAIL
ACT_HI_DETAIL| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| TYPE_ | varchar(255) | None |
| PROCDEF_KEY | varchar(255) | Part of KEY (PROCDEF_KEY) |
| PROCDEF_ID | varchar(64) | None |
| ROOTPROC_INST_ID | varchar(64) | Part of KEY (ROOTPROC_INST_ID) |
| PROCINST_ID | varchar(64) | Part of KEY (PROCINST_ID) |
| EXECUTIONID | varchar(64) | None |
| CASEDEF_KEY | varchar(255) | None |
| CASEDEF_ID | varchar(64) | None |
| CASEINST_ID | varchar(64) | Part of KEY (CASEINST_ID) |
| CASEEXECUTION_ID | varchar(64) | Part of KEY (CASEEXECUTION_ID) |
| TASKID | varchar(64) | Part of KEY (TASKID) |
| ACTINST_ID | varchar(64) | Part of KEY (ACTINST_ID) |
| VARINST_ID | varchar(64) | Part of KEY (VARINST_ID) |
| NAME_ | varchar(255) | Part of KEY (NAME_) |
| VARTYPE | varchar(255) | None |
| REV_ | int(11) | None |
| TIME_ | datetime | Part of KEY (TIME_) |
| BYTEARRAYID | varchar(64) | Part of KEY (BYTEARRAYID) |
| DOUBLE_ | double | None |
| LONG_ | bigint(20) | None |
| TEXT_ | varchar(4000) | None |
| TEXT2_ | varchar(4000) | None |
| SEQUENCECOUNTER | bigint(20) | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
| OPERATIONID | varchar(64) | None |
| REMOVALTIME | datetime | Part of KEY (REMOVALTIME) |
| INITIAL_ | tinyint(1) | None |
Table: ACT_GE_BYTEARRAY
ACT_GE_BYTEARRAY| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| NAME_ | varchar(255) | Part of KEY (NAME_) |
| DEPLOYMENTID | varchar(64) | Part of KEY (DEPLOYMENTID) |
| BYTES_ | longblob | None |
| GENERATED_ | tinyint(4) | None |
| TENANTID | varchar(64) | None |
| TYPE_ | int(11) | None |
| CREATETIME | datetime | None |
| ROOTPROC_INST_ID | varchar(64) | Part of KEY (ROOTPROC_INST_ID) |
| REMOVALTIME | datetime | Part of KEY (REMOVALTIME) |
Table: ACT_RE_PROCDEF
ACT_RE_PROCDEF| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| CATEGORY_ | varchar(255) | None |
| NAME_ | varchar(255) | None |
| KEY_ | varchar(255) | None |
| VERSION_ | int(11) | None |
| DEPLOYMENTID | varchar(64) | Part of KEY (DEPLOYMENTID) |
| RESOURCENAME | varchar(4000) | None |
| DGRMRESOURCE_NAME | varchar(4000) | None |
| HASSTART_FORM_KEY | tinyint(4) | None |
| SUSPENSIONSTATE | int(11) | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
| VERSIONTAG | varchar(64) | Part of KEY (VERSIONTAG) |
| HISTORYTTL | int(11) | None |
| STARTABLE_ | tinyint(1) | None |
Table: ACT_RU_FILTER
ACT_RU_FILTER| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| RESOURCETYPE | varchar(255) | None |
| NAME_ | varchar(255) | None |
| OWNER_ | varchar(255) | None |
| QUERY_ | longtext | None |
| PROPERTIES_ | longtext | None |
Table: ACT_RU_CASE_EXECUTION
ACT_RU_CASE_EXECUTION| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| CASEINST_ID | varchar(64) | Part of KEY (CASEINST_ID) |
| SUPERCASE_EXEC | varchar(64) | None |
| SUPEREXEC | varchar(64) | None |
| BUSINESSKEY | varchar(255) | Part of KEY (BUSINESSKEY) |
| PARENTID | varchar(64) | Part of KEY (PARENTID) |
| CASEDEF_ID | varchar(64) | Part of KEY (CASEDEF_ID) |
| ACTID | varchar(255) | None |
| PREVSTATE | int(11) | None |
| CURRENTSTATE | int(11) | None |
| REQUIRED_ | tinyint(1) | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
Table: ACT_HI_COMMENT
ACT_HI_COMMENT| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| TYPE_ | varchar(255) | None |
| TIME_ | datetime | None |
| USERID | varchar(255) | None |
| TASKID | varchar(64) | Part of KEY (TASKID) |
| ROOTPROC_INST_ID | varchar(64) | Part of KEY (ROOTPROC_INST_ID) |
| PROCINST_ID | varchar(64) | Part of KEY (PROCINST_ID) |
| ACTION_ | varchar(255) | None |
| MESSAGE_ | varchar(4000) | None |
| FULLMSG | longblob | None |
| TENANTID | varchar(64) | None |
| REMOVALTIME | datetime | Part of KEY (REMOVALTIME) |
Table: ACT_RU_JOB
ACT_RU_JOB| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| TYPE_ | varchar(255) | None |
| LOCKEXP_TIME | datetime | None |
| LOCKOWNER | varchar(255) | None |
| EXCLUSIVE_ | tinyint(1) | None |
| EXECUTIONID | varchar(64) | Part of KEY (EXECUTIONID) |
| PROCESSINSTANCE_ID | varchar(64) | Part of KEY (PROCESSINSTANCE_ID) |
| PROCESSDEF_ID | varchar(64) | None |
| PROCESSDEF_KEY | varchar(255) | None |
| RETRIES_ | int(11) | None |
| EXCEPTIONSTACK_ID | varchar(64) | Part of KEY (EXCEPTIONSTACK_ID) |
| EXCEPTIONMSG | varchar(4000) | None |
| FAILEDACT_ID | varchar(255) | None |
| DUEDATE_ | datetime(3) | None |
| REPEAT_ | varchar(255) | None |
| REPEATOFFSET | bigint(20) | None |
| HANDLERTYPE | varchar(255) | Part of KEY (HANDLERTYPE) |
| HANDLERCFG | varchar(4000) | None |
| DEPLOYMENTID | varchar(64) | None |
| SUSPENSIONSTATE | int(11) | None |
| JOBDEF_ID | varchar(64) | Part of KEY (JOBDEF_ID) |
| PRIORITY_ | bigint(20) | None |
| SEQUENCECOUNTER | bigint(20) | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
| CREATETIME | datetime | None |
| LASTFAILURE_LOG_ID | varchar(64) | None |
Table: ACT_RU_EVENT_SUBSCR
ACT_RU_EVENT_SUBSCR| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| EVENTTYPE | varchar(255) | None |
| EVENTNAME | varchar(255) | Part of KEY (EVENTNAME) |
| EXECUTIONID | varchar(64) | Part of KEY (EXECUTIONID) |
| PROCINST_ID | varchar(64) | None |
| ACTIVITYID | varchar(255) | None |
| CONFIGURATION_ | varchar(255) | Part of KEY (CONFIGURATION_) |
| CREATED_ | datetime | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
Table: ACT_HI_BATCH
ACT_HI_BATCH| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| TYPE_ | varchar(255) | None |
| TOTALJOBS | int(11) | None |
| JOBSPER_SEED | int(11) | None |
| INVOCATIONSPER_JOB | int(11) | None |
| SEEDJOB_DEF_ID | varchar(64) | None |
| MONITORJOB_DEF_ID | varchar(64) | None |
| BATCHJOB_DEF_ID | varchar(64) | None |
| TENANTID | varchar(64) | None |
| CREATEUSER_ID | varchar(255) | None |
| STARTTIME | datetime | None |
| ENDTIME | datetime | None |
| REMOVALTIME | datetime | Part of KEY (REMOVALTIME) |
| EXECSTART_TIME | datetime | None |
Table: ACT_HI_DEC_IN
ACT_HI_DEC_IN| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| DECINST_ID | varchar(64) | Part of KEY (DECINST_ID) |
| CLAUSEID | varchar(64) | Part of KEY (CLAUSEID) |
| CLAUSENAME | varchar(255) | None |
| VARTYPE | varchar(100) | None |
| BYTEARRAYID | varchar(64) | None |
| DOUBLE_ | double | None |
| LONG_ | bigint(20) | None |
| TEXT_ | varchar(4000) | None |
| TEXT2_ | varchar(4000) | None |
| TENANTID | varchar(64) | None |
| CREATETIME | datetime | None |
| ROOTPROC_INST_ID | varchar(64) | Part of KEY (ROOTPROC_INST_ID) |
| REMOVALTIME | datetime | Part of KEY (REMOVALTIME) |
Table: ACT_HI_VARINST
ACT_HI_VARINST| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| PROCDEF_KEY | varchar(255) | Part of KEY (PROCDEF_KEY) |
| PROCDEF_ID | varchar(64) | None |
| ROOTPROC_INST_ID | varchar(64) | Part of KEY (ROOTPROC_INST_ID) |
| PROCINST_ID | varchar(64) | Part of KEY (PROCINST_ID) |
| EXECUTIONID | varchar(64) | None |
| ACTINST_ID | varchar(64) | Part of KEY (ACTINST_ID) |
| CASEDEF_KEY | varchar(255) | None |
| CASEDEF_ID | varchar(64) | None |
| CASEINST_ID | varchar(64) | Part of KEY (CASEINST_ID) |
| CASEEXECUTION_ID | varchar(64) | None |
| TASKID | varchar(64) | None |
| NAME_ | varchar(255) | Part of KEY (NAME_) |
| VARTYPE | varchar(100) | Part of KEY (VARTYPE) |
| CREATETIME | datetime | None |
| REV_ | int(11) | None |
| BYTEARRAYID | varchar(64) | Part of KEY (BYTEARRAYID) |
| DOUBLE_ | double | None |
| LONG_ | bigint(20) | None |
| TEXT_ | varchar(4000) | None |
| TEXT2_ | varchar(4000) | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
| STATE_ | varchar(20) | None |
| REMOVALTIME | datetime | Part of KEY (REMOVALTIME) |
Table: ACT_RU_TASK
ACT_RU_TASK| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| EXECUTIONID | varchar(64) | Part of KEY (EXECUTIONID) |
| PROCINST_ID | varchar(64) | Part of KEY (PROCINST_ID) |
| PROCDEF_ID | varchar(64) | Part of KEY (PROCDEF_ID) |
| CASEEXECUTION_ID | varchar(64) | Part of KEY (CASEEXECUTION_ID) |
| CASEINST_ID | varchar(64) | None |
| CASEDEF_ID | varchar(64) | Part of KEY (CASEDEF_ID) |
| NAME_ | varchar(255) | None |
| PARENTTASK_ID | varchar(64) | Part of KEY (PARENTTASK_ID) |
| DESCRIPTION_ | varchar(4000) | None |
| TASKDEF_KEY | varchar(255) | None |
| OWNER_ | varchar(255) | Part of KEY (OWNER_) |
| ASSIGNEE_ | varchar(255) | Part of KEY (ASSIGNEE_) |
| DELEGATION_ | varchar(64) | None |
| PRIORITY_ | int(11) | None |
| CREATETIME | datetime | Part of KEY (CREATETIME) |
| LASTUPDATED | datetime | Part of KEY (LASTUPDATED) |
| DUEDATE | datetime | None |
| FOLLOWUP_DATE | datetime | None |
| SUSPENSIONSTATE | int(11) | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
Table: ACT_RU_AUTHORIZATION
ACT_RU_AUTHORIZATION| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| TYPE_ | int(11) | Part of UNIQUE KEY (TYPE_) |
| GROUPID | varchar(255) | Part of KEY (GROUPID) |
| USERID | varchar(255) | Part of UNIQUE KEY (USERID) |
| RESOURCETYPE | int(11) | Part of UNIQUE KEY (RESOURCETYPE) |
| RESOURCEID | varchar(255) | Part of KEY (RESOURCEID) |
| PERMS_ | int(11) | None |
| REMOVALTIME | datetime | Part of KEY (REMOVALTIME) |
| ROOTPROC_INST_ID | varchar(64) | Part of KEY (ROOTPROC_INST_ID) |
Table: ACT_RU_BATCH
ACT_RU_BATCH| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| TYPE_ | varchar(255) | None |
| TOTALJOBS | int(11) | None |
| JOBSCREATED | int(11) | None |
| JOBSPER_SEED | int(11) | None |
| INVOCATIONSPER_JOB | int(11) | None |
| SEEDJOB_DEF_ID | varchar(64) | Part of KEY (SEEDJOB_DEF_ID) |
| BATCHJOB_DEF_ID | varchar(64) | Part of KEY (BATCHJOB_DEF_ID) |
| MONITORJOB_DEF_ID | varchar(64) | Part of KEY (MONITORJOB_DEF_ID) |
| SUSPENSIONSTATE | int(11) | None |
| CONFIGURATION_ | varchar(255) | None |
| TENANTID | varchar(64) | None |
| CREATEUSER_ID | varchar(255) | None |
| STARTTIME | datetime | None |
| EXECSTART_TIME | datetime | None |
Table: ACT_GE_PROPERTY
ACT_GE_PROPERTY| Column Name | Data Type | Index |
|---|---|---|
| NAME_ | varchar(64) | Part of PRIMARY KEY (NAME_) |
| VALUE_ | varchar(300) | None |
| REV_ | int(11) | None |
Table: ACT_ID_TENANT
ACT_ID_TENANT| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| NAME_ | varchar(255) | None |
Table: ACT_RE_DECISION_REQ_DEF
ACT_RE_DECISION_REQ_DEF| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| CATEGORY_ | varchar(255) | None |
| NAME_ | varchar(255) | None |
| KEY_ | varchar(255) | None |
| VERSION_ | int(11) | None |
| DEPLOYMENTID | varchar(64) | None |
| RESOURCENAME | varchar(4000) | None |
| DGRMRESOURCE_NAME | varchar(4000) | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
Table: ACT_RU_VARIABLE
ACT_RU_VARIABLE| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| TYPE_ | varchar(255) | Part of KEY (TYPE_) |
| NAME_ | varchar(255) | Part of KEY (NAME_) |
| EXECUTIONID | varchar(64) | Part of KEY (EXECUTIONID) |
| PROCINST_ID | varchar(64) | Part of KEY (PROCINST_ID) |
| PROCDEF_ID | varchar(64) | None |
| CASEEXECUTION_ID | varchar(64) | Part of KEY (CASEEXECUTION_ID) |
| CASEINST_ID | varchar(64) | Part of KEY (CASEINST_ID) |
| TASKID | varchar(64) | Part of KEY (TASKID) |
| BATCHID | varchar(64) | Part of KEY (BATCHID) |
| BYTEARRAYID | varchar(64) | Part of KEY (BYTEARRAYID) |
| DOUBLE_ | double | None |
| LONG_ | bigint(20) | None |
| TEXT_ | varchar(4000) | None |
| TEXT2_ | varchar(4000) | None |
| VARSCOPE | varchar(64) | Part of UNIQUE KEY (VARSCOPE) |
| SEQUENCECOUNTER | bigint(20) | None |
| ISCONCURRENT_LOCAL | tinyint(4) | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
Table: ACT_HI_DEC_OUT
ACT_HI_DEC_OUT| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| DECINST_ID | varchar(64) | Part of KEY (DECINST_ID) |
| CLAUSEID | varchar(64) | Part of KEY (CLAUSEID) |
| CLAUSENAME | varchar(255) | None |
| RULEID | varchar(64) | None |
| RULEORDER | int(11) | Part of KEY (RULEORDER) |
| VARNAME | varchar(255) | None |
| VARTYPE | varchar(100) | None |
| BYTEARRAYID | varchar(64) | None |
| DOUBLE_ | double | None |
| LONG_ | bigint(20) | None |
| TEXT_ | varchar(4000) | None |
| TEXT2_ | varchar(4000) | None |
| TENANTID | varchar(64) | None |
| CREATETIME | datetime | None |
| ROOTPROC_INST_ID | varchar(64) | Part of KEY (ROOTPROC_INST_ID) |
| REMOVALTIME | datetime | Part of KEY (REMOVALTIME) |
Table: ACT_RE_CASE_DEF
ACT_RE_CASE_DEF| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| CATEGORY_ | varchar(255) | None |
| NAME_ | varchar(255) | None |
| KEY_ | varchar(255) | None |
| VERSION_ | int(11) | None |
| DEPLOYMENTID | varchar(64) | None |
| RESOURCENAME | varchar(4000) | None |
| DGRMRESOURCE_NAME | varchar(4000) | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
| HISTORYTTL | int(11) | None |
Table: ACT_ID_USER
ACT_ID_USER| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| FIRST_ | varchar(255) | None |
| LAST_ | varchar(255) | None |
| EMAIL_ | varchar(255) | None |
| PWD_ | varchar(255) | None |
| SALT_ | varchar(255) | None |
| LOCKEXP_TIME | datetime | None |
| ATTEMPTS_ | int(11) | None |
| PICTUREID | varchar(64) | None |
Table: ACT_HI_OP_LOG
ACT_HI_OP_LOG| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| DEPLOYMENTID | varchar(64) | None |
| PROCDEF_ID | varchar(64) | Part of KEY (PROCDEF_ID) |
| PROCDEF_KEY | varchar(255) | None |
| ROOTPROC_INST_ID | varchar(64) | Part of KEY (ROOTPROC_INST_ID) |
| PROCINST_ID | varchar(64) | Part of KEY (PROCINST_ID) |
| EXECUTIONID | varchar(64) | None |
| CASEDEF_ID | varchar(64) | None |
| CASEINST_ID | varchar(64) | None |
| CASEEXECUTION_ID | varchar(64) | None |
| TASKID | varchar(64) | Part of KEY (TASKID) |
| JOBID | varchar(64) | None |
| JOBDEF_ID | varchar(64) | None |
| BATCHID | varchar(64) | None |
| USERID | varchar(255) | Part of KEY (USERID) |
| TIMESTAMP_ | timestamp | Part of KEY (TIMESTAMP_) |
| OPERATIONTYPE | varchar(64) | Part of KEY (OPERATIONTYPE) |
| OPERATIONID | varchar(64) | None |
| ENTITYTYPE | varchar(30) | Part of KEY (ENTITYTYPE) |
| PROPERTY_ | varchar(64) | None |
| ORGVALUE | varchar(4000) | None |
| NEWVALUE | varchar(4000) | None |
| TENANTID | varchar(64) | None |
| REMOVALTIME | datetime | Part of KEY (REMOVALTIME) |
| CATEGORY_ | varchar(64) | None |
| EXTERNALTASK_ID | varchar(64) | None |
| ANNOTATION_ | varchar(4000) | None |
Table: ACT_RU_IDENTITYLINK
ACT_RU_IDENTITYLINK| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| GROUPID | varchar(255) | Part of KEY (GROUPID) |
| TYPE_ | varchar(255) | None |
| USERID | varchar(255) | Part of KEY (USERID) |
| TASKID | varchar(64) | Part of KEY (TASKID) |
| PROCDEF_ID | varchar(64) | Part of KEY (PROCDEF_ID) |
| TENANTID | varchar(64) | None |
Table: ACT_RE_DECISION_DEF
ACT_RE_DECISION_DEF| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| CATEGORY_ | varchar(255) | None |
| NAME_ | varchar(255) | None |
| KEY_ | varchar(255) | None |
| VERSION_ | int(11) | None |
| DEPLOYMENTID | varchar(64) | None |
| RESOURCENAME | varchar(4000) | None |
| DGRMRESOURCE_NAME | varchar(4000) | None |
| DECREQ_ID | varchar(64) | Part of KEY (DECREQ_ID) |
| DECREQ_KEY | varchar(255) | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
| HISTORYTTL | int(11) | None |
| VERSIONTAG | varchar(64) | None |
Table: ACT_HI_EXT_TASK_LOG
ACT_HI_EXT_TASK_LOG| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| TIMESTAMP_ | timestamp | None |
| EXTTASK_ID | varchar(64) | None |
| RETRIES_ | int(11) | None |
| TOPICNAME | varchar(255) | None |
| WORKERID | varchar(255) | None |
| PRIORITY_ | bigint(20) | None |
| ERRORMSG | varchar(4000) | None |
| ERRORDETAILS_ID | varchar(64) | Part of KEY (ERRORDETAILS_ID) |
| ACTID | varchar(255) | None |
| ACTINST_ID | varchar(64) | None |
| EXECUTIONID | varchar(64) | None |
| ROOTPROC_INST_ID | varchar(64) | Part of KEY (ROOTPROC_INST_ID) |
| PROCINST_ID | varchar(64) | Part of KEY (PROCINST_ID) |
| PROCDEF_ID | varchar(64) | Part of KEY (PROCDEF_ID) |
| PROCDEF_KEY | varchar(255) | Part of KEY (PROCDEF_KEY) |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
| STATE_ | int(11) | None |
| REV_ | int(11) | None |
| REMOVALTIME | datetime | Part of KEY (REMOVALTIME) |
Table: ACT_HI_JOB_LOG
ACT_HI_JOB_LOG| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| TIMESTAMP_ | datetime | None |
| JOBID | varchar(64) | None |
| JOBDUEDATE | datetime | None |
| JOBRETRIES | int(11) | None |
| JOBPRIORITY | bigint(20) | None |
| JOBEXCEPTION_MSG | varchar(4000) | None |
| JOBEXCEPTION_STACK_ID | varchar(64) | Part of KEY (JOBEXCEPTION_STACK_ID) |
| JOBSTATE | int(11) | None |
| JOBDEF_ID | varchar(64) | Part of KEY (JOBDEF_ID) |
| JOBDEF_TYPE | varchar(255) | None |
| JOBDEF_CONFIGURATION | varchar(255) | Part of KEY (JOBDEF_CONFIGURATION) |
| ACTID | varchar(255) | None |
| FAILEDACT_ID | varchar(255) | None |
| EXECUTIONID | varchar(64) | None |
| ROOTPROC_INST_ID | varchar(64) | Part of KEY (ROOTPROC_INST_ID) |
| PROCESSINSTANCE_ID | varchar(64) | Part of KEY (PROCESSINSTANCE_ID) |
| PROCESSDEF_ID | varchar(64) | Part of KEY (PROCESSDEF_ID) |
| PROCESSDEF_KEY | varchar(255) | Part of KEY (PROCESSDEF_KEY) |
| DEPLOYMENTID | varchar(64) | None |
| SEQUENCECOUNTER | bigint(20) | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
| HOSTNAME_ | varchar(255) | None |
| REMOVALTIME | datetime | Part of KEY (REMOVALTIME) |
Table: ACT_ID_INFO
ACT_ID_INFO| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| REV_ | int(11) | None |
| USERID | varchar(64) | None |
| TYPE_ | varchar(64) | None |
| KEY_ | varchar(255) | None |
| VALUE_ | varchar(255) | None |
| PASSWORD_ | longblob | None |
| PARENTID | varchar(255) | None |
Table: ACT_HI_CASEACTINST
ACT_HI_CASEACTINST| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of KEY (ID_) |
| PARENTACT_INST_ID | varchar(64) | None |
| CASEDEF_ID | varchar(64) | None |
| CASEINST_ID | varchar(64) | Part of KEY (CASEINST_ID) |
| CASEACT_ID | varchar(255) | Part of KEY (CASEACT_ID) |
| TASKID | varchar(64) | None |
| CALLPROC_INST_ID | varchar(64) | None |
| CALLCASE_INST_ID | varchar(64) | None |
| CASEACT_NAME | varchar(255) | None |
| CASEACT_TYPE | varchar(255) | None |
| CREATETIME | datetime | Part of KEY (CREATETIME) |
| ENDTIME | datetime | Part of KEY (ENDTIME) |
| DURATION_ | bigint(20) | None |
| STATE_ | int(11) | None |
| REQUIRED_ | tinyint(1) | None |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
Table: ACT_HI_DECINST
ACT_HI_DECINST| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| DECDEF_ID | varchar(64) | Part of KEY (DECDEF_ID) |
| DECDEF_KEY | varchar(255) | Part of KEY (DECDEF_KEY) |
| DECDEF_NAME | varchar(255) | None |
| PROCDEF_KEY | varchar(255) | None |
| PROCDEF_ID | varchar(64) | None |
| PROCINST_ID | varchar(64) | Part of KEY (PROCINST_ID) |
| CASEDEF_KEY | varchar(255) | None |
| CASEDEF_ID | varchar(64) | None |
| CASEINST_ID | varchar(64) | Part of KEY (CASEINST_ID) |
| ACTINST_ID | varchar(64) | Part of KEY (ACTINST_ID) |
| ACTID | varchar(255) | Part of KEY (ACTID) |
| EVALTIME | datetime | Part of KEY (EVALTIME) |
| REMOVALTIME | datetime | Part of KEY (REMOVALTIME) |
| COLLECTVALUE | double | None |
| USERID | varchar(255) | None |
| ROOTDEC_INST_ID | varchar(64) | Part of KEY (ROOTDEC_INST_ID) |
| ROOTPROC_INST_ID | varchar(64) | Part of KEY (ROOTPROC_INST_ID) |
| DECREQ_ID | varchar(64) | Part of KEY (DECREQ_ID) |
| DECREQ_KEY | varchar(255) | Part of KEY (DECREQ_KEY) |
| TENANTID | varchar(64) | Part of KEY (TENANTID) |
Table: ACT_RU_TASK_METER_LOG
ACT_RU_TASK_METER_LOG| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| ASSIGNEEHASH | bigint(20) | None |
| TIMESTAMP_ | datetime | Part of KEY (TIMESTAMP_) |
Table: ACT_ID_TENANT_MEMBER
ACT_ID_TENANT_MEMBER| Column Name | Data Type | Index |
|---|---|---|
| ID_ | varchar(64) | Part of PRIMARY KEY (ID_) |
| TENANTID | varchar(64) | Part of UNIQUE KEY (TENANTID) |
| USERID | varchar(64) | Part of KEY (USERID) |
| GROUPID | varchar(64) | Part of KEY (GROUPID) |
Table: REF_GAME_ITEM_METADATA
REF_GAME_ITEM_METADATA| Column Name | Data Type | Index |
|---|---|---|
| EXHAUSED_LIMIT | int(11) | None |
| GAME_ITEM_ID | bigint(20) | Part of PRIMARY KEY (GAME_ITEM_ID) |
| MAX_LIMIT | int(11) | None |
| WIN_PERCENTAGE | double | None |
| LAST_UPDATED_ON | timestamp | None |
| CREATED_ON | timestamp | None |
Table: TBL_GAME_ITEM_AUD
TBL_GAME_ITEM_AUD| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| REV | int(11) | Part of KEY (REV) |
| REVTYPE | tinyint(4) | None |
| COLOR_CODE | varchar(255) | None |
| DESCRIPTION | varchar(255) | None |
| ENABLED | bit(1) | None |
| GAME_ID | bigint(20) | None |
| IMAGE_URL | varchar(255) | None |
| NAME | varchar(255) | None |
| REDEMPTION_ID | bigint(20) | None |
Table: TBL_LANGUAGE
TBL_LANGUAGE| Column Name | Data Type | Index |
|---|---|---|
| CODE | varchar(255) | Part of PRIMARY KEY (CODE) |
| IS_ENABLED | bit(1) | None |
| NAME | varchar(255) | None |
| LAST_UPDATED_ON | timestamp | None |
| CREATED_ON | timestamp | None |
Table: LOG_MERGE_USER
LOG_MERGE_USER| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint | Part of PRIMARY KEY (ID) |
| ERROR_MESSAGE | text | None |
| FROM_USER_ID | int(11) | None |
| MERGED_DATE | datetime | None |
| NOTES | text | None |
| ORG_ID | int(11) | Part of KEY (ORG_ID) |
| REQUEST_ID | varchar(100) | None |
| STATUS | enum('SUCCESS','FAIL') | None |
| TILL_ID | int(11) | None |
| TO_USER_ID | int(11) | None |
| CREATED_ON | timestamp | None |
Table: TBL_REDEMPTION_AUD
TBL_REDEMPTION_AUD| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| REV | int(11) | Part of KEY (REV) |
| REVTYPE | tinyint(4) | None |
| API_BODY | json | None |
| API_HEADERS | json | None |
| API_QUERY_PARAMS | json | None |
| API_RESPONSE_EXTRACT_KEY | varchar(255) | None |
| API_TYPE | int(11) | None |
| API_URL | varchar(255) | None |
| BRAND_ID | bigint(20) | None |
| CREATED_BY | varchar(255) | None |
| CREATION_TIME | datetime | None |
| DESCRIPTION | varchar(255) | None |
| ENABLED | bit(1) | None |
| NAME | varchar(255) | None |
| TYPE | varchar(255) | None |
| UPDATED_BY | varchar(255) | None |
| UPDATION_TIME | datetime | None |
Table: TBL_GAME_AUD
TBL_GAME_AUD| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| REV | int(11) | Part of KEY (REV) |
| REVTYPE | tinyint(4) | None |
| ALLOWED_PLAY | int(11) | None |
| AVAILABLE_FOR_ALL | bit(1) | None |
| BRAND_ID | bigint(20) | None |
| CREATED_BY | varchar(255) | None |
| CREATION_TIME | datetime | None |
| DESCRIPTION | varchar(255) | None |
| ENABLED | bit(1) | None |
| END_TIME | datetime | None |
| LESS_COUPON_WARNING | int(11) | None |
| NAME | varchar(255) | None |
| START_TIME | datetime | None |
| IS_STARTED | bit(1) | None |
| TYPE | varchar(255) | None |
| UPDATED_BY | varchar(255) | None |
| UPDATION_TIME | datetime | None |
| USER_GAME_ITEM_LIMIT_ENABLED | bit(1) | None |
| WEB_URL | varchar(255) | None |
Table: REF_USER_GAME
REF_USER_GAME| Column Name | Data Type | Index |
|---|---|---|
| ALLOWED_PLAY | int(11) | None |
| EXHAUSTED_PLAY | int(11) | None |
| GAME_ID | bigint(20) | Part of KEY (GAME_ID) |
| MAX_POSSIBLE_PLAY | int(11) | None |
| USER_ID | bigint(20) | Part of KEY (USER_ID) |
| ACTIVE | bit(1) | None |
| LAST_UPDATED_ON | timestamp | None |
| CREATED_ON | timestamp | Part of KEY (CREATED_ON) |
Table: TBL_REDEMPTION
TBL_REDEMPTION| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| API_BODY | json | None |
| API_HEADERS | json | None |
| API_QUERY_PARAMS | json | None |
| API_RESPONSE_EXTRACT_KEY | varchar(255) | None |
| API_TYPE | int(11) | None |
| API_URL | varchar(255) | None |
| BRAND_ID | bigint(20) | Part of KEY (BRAND_ID) |
| CREATED_BY | varchar(255) | None |
| CREATION_TIME | datetime | None |
| DESCRIPTION | varchar(255) | None |
| ENABLED | bit(1) | None |
| NAME | varchar(255) | None |
| TYPE | varchar(255) | None |
| UPDATED_BY | varchar(255) | None |
| UPDATION_TIME | datetime | None |
Table: REF_GAME_DETAILS
REF_GAME_DETAILS| Column Name | Data Type | Index |
|---|---|---|
| DESCRIPTION | varchar(255) | None |
| IS_ENABLED | bit(1) | None |
| GAME_ID | bigint(20) | Part of KEY (GAME_ID) |
| IMAGE_URI | varchar(255) | None |
| LANGUAGE_CODE | varchar(255) | Part of KEY (LANGUAGE_CODE) |
| NAME | varchar(255) | None |
| TERM_N_CONDITIONS | varchar(255) | None |
| LAST_UPDATED_ON | timestamp | None |
| CREATED_ON | timestamp | None |
Table: REF_GAME_ITEM_DETAILS_AUD
REF_GAME_ITEM_DETAILS_AUD| Column Name | Data Type | Index |
|---|---|---|
| GAME_ITEM_ID | bigint(20) | Part of PRIMARY KEY (GAME_ITEM_ID) |
| LANGUAGE_CODE | varchar(255) | Part of PRIMARY KEY (LANGUAGE_CODE) |
| REV | int(11) | Part of KEY (REV) |
| REVTYPE | tinyint(4) | None |
| DESCRIPTION | varchar(255) | None |
| IMAGE_URI | varchar(255) | None |
| NAME | varchar(255) | None |
| LAST_UPDATED_ON | timestamp | None |
| CREATED_ON | timestamp | None |
Table: REF_GAME_DETAILS_AUD
REF_GAME_DETAILS_AUD| Column Name | Data Type | Index |
|---|---|---|
| GAME_ID | bigint(20) | Part of PRIMARY KEY (GAME_ID) |
| LANGUAGE_CODE | varchar(255) | Part of PRIMARY KEY (LANGUAGE_CODE) |
| REV | int(11) | Part of KEY (REV) |
| REVTYPE | tinyint(4) | None |
| DESCRIPTION | varchar(255) | None |
| IS_ENABLED | bit(1) | None |
| IMAGE_URI | varchar(255) | None |
| NAME | varchar(255) | None |
| TERM_N_CONDITIONS | varchar(255) | None |
| LAST_UPDATED_ON | timestamp | None |
| CREATED_ON | timestamp | None |
Table: TBL_BRAND_AUD
TBL_BRAND_AUD| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| REV | int(11) | Part of KEY (REV) |
| REVTYPE | tinyint(4) | None |
| IS_ENABLED | bit(1) | None |
| NAME | varchar(255) | None |
| ORG_ID | bigint | None |
| TILL_CODE | varchar(255) | None |
Table: LOG_USER_REDEMPTION
LOG_USER_REDEMPTION| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| API_RESPONSE_BODY | varchar(4096) | None |
| API_RESPONSE_HEADERS | json | None |
| GAME_ID | bigint(20) | Part of KEY (GAME_ID) |
| BRAND_ID | bigint(20) | None |
| PLAY_TIME | datetime | None |
| USER_ID | bigint(20) | Part of KEY (USER_ID) |
| CREATED_ON | timestamp | None |
Table: REVINFO
REVINFO| Column Name | Data Type | Index |
|---|---|---|
| REV | int(11) | Part of PRIMARY KEY (REV) |
| REVTSTMP | bigint(20) | None |
Table: REF_GAME_ITEM_DETAILS
REF_GAME_ITEM_DETAILS| Column Name | Data Type | Index |
|---|---|---|
| DESCRIPTION | varchar(255) | None |
| GAME_ITEM_ID | bigint(20) | Part of KEY (GAME_ITEM_ID) |
| IMAGE_URI | varchar(255) | None |
| LANGUAGE_CODE | varchar(255) | Part of KEY (LANGUAGE_CODE) |
| NAME | varchar(255) | None |
| LAST_UPDATED_ON | timestamp | None |
| CREATED_ON | timestamp | None |
Table: TBL_GAME_ITEM
TBL_GAME_ITEM| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| COLOR_CODE | varchar(255) | None |
| GAME_ID | bigint(20) | Part of KEY (GAME_ID) |
| REDEMPTION_ID | bigint(20) | Part of KEY (REDEMPTION_ID) |
| LAST_UPDATED_ON | timestamp | None |
| CREATED_ON | timestamp | None |
Table: TBL_GAME
TBL_GAME| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ALLOWED_PLAY | int(11) | None |
| AVAILABLE_FOR_ALL | bit(1) | None |
| BRAND_ID | bigint(20) | Part of KEY (BRAND_ID) |
| CREATED_BY | varchar(255) | None |
| CREATION_TIME | datetime | None |
| ENABLED | bit(1) | None |
| END_TIME | datetime | None |
| LESS_COUPON_WARNING | int(11) | None |
| START_TIME | datetime | None |
| IS_STARTED | bit(1) | None |
| TYPE | varchar(255) | None |
| UPDATED_BY | varchar(255) | None |
| UPDATION_TIME | datetime | None |
| USER_GAME_ITEM_LIMIT_ENABLED | bit(1) | None |
Table: USER_GAME_ITEM
USER_GAME_ITEM| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| USER_ID | bigint(20) | Part of KEY (USER_ID) |
| GAME_ID | bigint(20) | Part of KEY (GAME_ID) |
| GAME_ITEM_ID | bigint(20) | Part of KEY (GAME_ITEM_ID) |
| BRAND_ID | bigint(20) | Part of KEY (BRAND_ID) |
| USER_GAME_ITEM_WINS_COUNT | int(11) | None |
Table: TBL_BRAND
TBL_BRAND| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| IS_ENABLED | bit(1) | None |
| NAME | varchar(255) | Part of UNIQUE KEY (NAME) |
| ORG_ID | bigint | None |
| TILL_CODE | varchar(255) | None |
| LAST_UPDATED_ON | timestamp | None |
| CREATED_ON | timestamp | None |
Table: REF_GAME_ITEM_METADATA_AUD
REF_GAME_ITEM_METADATA_AUD| Column Name | Data Type | Index |
|---|---|---|
| GAME_ITEM_ID | bigint(20) | Part of PRIMARY KEY (GAME_ITEM_ID) |
| REV | int(11) | Part of KEY (REV) |
| REVTYPE | tinyint(4) | None |
| EXHAUSED_LIMIT | int(11) | None |
| MAX_LIMIT | int(11) | None |
| WIN_PERCENTAGE | double | None |
| LAST_UPDATED_ON | timestamp | None |
| CREATED_ON | timestamp | None |
Table: TBL_USER
TBL_USER| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| IS_BLACKLISTED | bit(1) | None |
| BRAND_ID | bigint(20) | Part of KEY (BRAND_ID) |
| varchar(255) | Part of KEY (EMAIL) | |
| EXTERNAL_ID | varchar(255) | Part of KEY (EXTERNAL_ID) |
| MOBILE | bigint(20) | Part of KEY (MOBILE) |
| INTOUCH_USER_ID | bigint(20) | Part of KEY (INTOUCH_USER_ID) |
| ACTIVE | bit(1) | None |
| LAST_UPDATED_ON | timestamp | None |
| CREATED_ON | timestamp | None |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of UNIQUE KEY (id) |
| uuId | varchar(250) | Part of UNIQUE KEY (uuId) |
| is_active | int(1) | None |
Table: scope_resource_mapping
scope_resource_mapping| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| org_id | bigint | Part of KEY (org_id) |
| scope_id | bigint | Part of KEY (scope_id) |
| request_type | varchar(50) | None |
| resource | varchar(50) | None |
| updated_by | bigint | None |
| is_active | boolean | None |
| updated_on | timestamp | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: audit_log
audit_log| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| org_id | bigint | Part of KEY (org_id) |
| entity_id | bigint | Part of KEY (entity_id) |
| audit_log_type | enum('CLIENT', | Part of KEY (audit_log_type) |
| details | mediumtext | None |
| created_on | datetime | None |
| created_by | bigint | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: client_otp
client_otp| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| org_id | bigint | Part of KEY (org_id) |
| session_id | bigint | Part of KEY (session_id) |
| otp | varchar(20) | None |
| otp_status | enum('VALIDATED', | None |
| user_id | bigint | Part of KEY (user_id) |
| identifier_type | enum('MOBILE', | None |
| otp_expiration_date | datetime | None |
| created_on | datetime | None |
| identifier_value | varchar(50) | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
| modified_on | datetime | None |
Table: template_language
template_language| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| org_id | bigint | Part of KEY (org_id) |
| client_id | bigint | None |
| template_id | bigint | Part of KEY (template_id) |
| language | varchar(20) | None |
| text | mediumtext | None |
| subject | text | None |
| is_active | boolean | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: template
template| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of KEY (id) |
| org_id | bigint | Part of KEY (org_id) |
| client_id | bigint | Part of KEY (client_id) |
| name | varchar(255) | None |
| type | enum('MOBILE','EMAIL') | None |
| is_active | boolean | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: auth_client
auth_client| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of UNIQUE KEY (id) |
| org_id | bigint | Part of KEY (org_id) |
| client_key | varchar(255) | Part of KEY (client_key) |
| client_secret | varchar(255) | None |
| client_name | varchar(255) | Part of UNIQUE KEY (client_name) |
| jwt_key | varchar(2000) | None |
| is_active | boolean | None |
| created_on | datetime | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: client_scope_mapping
client_scope_mapping| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| org_id | bigint | Part of KEY (org_id) |
| client_id | bigint | Part of KEY (client_id) |
| scope_id | bigint | Part of KEY (scope_id) |
| created_by | bigint | None |
| is_active | boolean | None |
| created_on | datetime | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: config_key_values
config_key_values| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| org_id | bigint | Part of KEY (org_id) |
| client_id | bigint | Part of KEY (client_id) |
| key_id | bigint | None |
| value | varchar(255) | None |
| updated_by | bigint | None |
| is_active | boolean | None |
| updated_on | timestamp | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: authorization_code
authorization_code| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| org_id | bigint | Part of KEY (org_id) |
| session_id | bigint | Part of KEY (session_id) |
| client_id | bigint | Part of KEY (client_id) |
| user_id | bigint | Part of KEY (user_id) |
| code | varchar(20) | Part of KEY (code) |
| status | enum('OPEN','CLOSED') | None |
| created_on | datetime | None |
| expired_on | datetime | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
| modified_on | datetime | None |
Table: session
session| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| org_id | bigint | Part of KEY (org_id) |
| uuid | varchar(50) | Part of KEY (uuid) |
| ip_address | varchar(50) | None |
| redirect_uri | mediumtext | None |
| client_id | bigint | Part of KEY (client_id) |
| state | varchar(20) | None |
| scopes | varchar(255)COLLATE | None |
| response_type | varchar(30) | None |
| response_mode | varchar(30) | None |
| session_expiry_date | datetime | None |
| created_on | datetime | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
| modified_on | datetime | None |
Table: scopes
scopes| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of UNIQUE KEY (id) |
| org_id | bigint | Part of KEY (org_id) |
| name | varchar(255) | Part of KEY (name) |
| updated_by | bigint | None |
| is_active | boolean | None |
| updated_on | timestamp | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: config_keys
config_keys| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| name | varchar(100) | Part of KEY (name) |
| default_value | varchar(255) | None |
| is_active | boolean | None |
| created_on | datetime | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: TBL_ISSUE_REVENUE
TBL_ISSUE_REVENUE| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| REWARD_ID | bigint(20) | None |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| USER_REWARD_ID | bigint(20) | Part of KEY (USER_REWARD_ID) |
| ISSUE_REVENUE_DETAIL_ID | bigint(20) | None |
| CREATED_ON | timestamp | None |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| LAST_UPDATED_BY | varchar(50) | None |
| CREATED_BY | varchar(50) | None |
Table: TBL_RICH_CONTENT_META
TBL_RICH_CONTENT_META| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of UNIQUE KEY (ID) |
| ORG_ID | bigint(20) | Part of UNIQUE KEY (ORG_ID) |
| NAME | varchar(255) | None |
| DESCRIPTION | varchar(255) | None |
| IS_MANDATORY | bit(1) | None |
| IS_ACTIVE | bit(1) | None |
| SCOPE | enum('REWARD') | None |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | None |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_VENDOR
TBL_VENDOR| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| BRAND_ID | bigint(20) | None |
| ORG_ID | bigint(20) | Part of UNIQUE KEY (ORG_ID) |
| IS_ENABLED | bit(1) | None |
| NAME | varchar(255) | Part of UNIQUE KEY (NAME) |
| IS_ENCRYPTIOM_REQUIRED | bit(1) | None |
| VENDOR_CLASS | varchar(255) | None |
| TYPE | enum('REWARDS','POINTS') | None |
| RANK | int(11) | None |
| VENDOR_CODE | varchar(255) | Part of UNIQUE KEY (VENDOR_CODE) |
| DESCRIPTION | varchar(1034) | None |
| LAST_UPDATED_ON | timestamp | None |
| CREATED_ON | timestamp | None |
Table: REF_REWARD_GEOGRAPHY
REF_REWARD_GEOGRAPHY| Column Name | Data Type | Index |
|---|---|---|
| AREA_ID | bigint(20) | Part of KEY (AREA_ID) |
| CITY_ID | bigint(20) | Part of KEY (CITY_ID) |
| COUNTRY_ID | bigint(20) | Part of KEY (COUNTRY_ID) |
| LATITUDE | double | None |
| LONGITUDE | double | None |
| REWARD_ID | bigint(20) | Part of KEY (REWARD_ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| CREATED_ON | timestamp | None |
Table: TBL_PAYMENT_CONFIG_CURRENCY
TBL_PAYMENT_CONFIG_CURRENCY| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| CONFIG_ID | bigint(20) | Part of KEY (CONFIG_ID) |
| CURRENCY_TYPE | enum('POINTS', | Part of KEY (CURRENCY_TYPE) |
| CURRENCY_VALUE | decimal(13,4) | None |
| IS_ENABLED | bit(1) | Part of KEY (IS_ENABLED) |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_TRANSACTION_ACTION_LOG
TBL_TRANSACTION_ACTION_LOG| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| TRANSACTION_ID | bigint(20) | Part of KEY (TRANSACTION_ID) |
| STAGE | enum('IS_REDEEM','CONSTRAINT','ISSUE','REDEEM','REVOKE','CATALOG') | None |
| VENDOR_NAME | varchar(255) | None |
| VENDOR_ID | varchar(50) | None |
| POINTS | bigint(20) | None |
| STAGE_REFERENCE_ID | bigint(20) | None |
| EXTERNAL_REFERENCE_ID | varchar(255) | None |
| STATUS_CODE | varchar(50) | None |
| REQUEST_BODY | text | None |
| RESPONSE_BODY | text | None |
| HEADERS | text | None |
| STATUS_MESSAGE | varchar(512) | None |
| SUCCESS | bit(1) | None |
| IS_EXTERNAL | bit(1) | None |
| CREATED_ON | timestamp | None |
Table: TBL_LANGUAGE
TBL_LANGUAGE| Column Name | Data Type | Index |
|---|---|---|
| CODE | varchar(255) | Part of PRIMARY KEY (CODE) |
| IS_ENABLED | bit(1) | None |
| NAME | varchar(255) | None |
| LAST_UPDATED_ON | timestamp | None |
| CREATED_ON | timestamp | None |
Table: TBL_GROUP
TBL_GROUP| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of PRIMARY KEY (ORG_ID) |
| NAME | varchar(255) | None |
| RANK | int(11) | None |
| IS_ACTIVE | bit(1) | None |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | None |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_REWARD_OWNER
TBL_REWARD_OWNER| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| REWARD_ID | bigint(20) | Part of KEY (REWARD_ID) |
| IS_ACTIVE | bit(1) | Part of KEY (IS_ACTIVE) |
| OWNER_TYPE | enum('LOYALTY_PROGRAM', | Part of KEY (OWNER_TYPE) |
| OWNER_ID | varchar(255) | Part of KEY (OWNER_ID) |
| CREATED_BY | varchar(50) | None |
| CREATED_ON | timestamp | None |
| LAST_UPDATED_ON | timestamp | None |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_REWARD_REDEMPTION_TYPES
TBL_REWARD_REDEMPTION_TYPES| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| NAME | varchar(100) | None |
| IDENTIFIER | bigint(20) | None |
| IS_PARTNER | bit(1) | None |
| IS_ENABLED | bit(1) | None |
| DESCRIPTION | varchar(255) | None |
| CREATED_ON | timestamp | None |
| CREATED_BY | bigint(20) | None |
| LAST_UPDATED_ON | timestamp | None |
| LAST_UPDATED_BY | bigint(20) | None |
Table: REF_REWARD_CATEGORY
REF_REWARD_CATEGORY| Column Name | Data Type | Index |
|---|---|---|
| CATEGORY_ID | bigint(20) | Part of KEY (CATEGORY_ID) |
| REWARD_ID | bigint(20) | Part of KEY (REWARD_ID) |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| CREATED_ON | timestamp | None |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
Table: TBL_REWARD_CONSTRAINT_AUD
TBL_REWARD_CONSTRAINT_AUD| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| REWARD_ID | bigint(20) | None |
| REV | int(11) | Part of KEY (REV) |
| REVTYPE | tinyint(4) | None |
| ENABLED | bit(1) | None |
| ORG_ID | bigint(20) | Part of PRIMARY KEY (ORG_ID) |
| KPI | enum('TRANSACTION_COUNT','QUANTITY','POINTS','REDEMPTION_VALUE') | None |
| CONSTRAINT_LEVEL | enum('REWARD','CUSTOMER','TRANSACTION','CUSTOMER_REDEMPTION_TYPE','CUSTOMER_TIER' | None |
| CONSTRAINT_ATTRIBUTE | varchar(100) | None |
| WINDOW_TYPE | enum | None |
| OPERATOR | enum('EQUALS') | None |
| REPEAT_FREQUENCY_TYPE | enum('DAYS','MONTHS','WEEKS','NO_LIMIT') | None |
| INTERVAL_VALUE | int(20) | None |
| LIMIT_VALUE | int(20) | None |
| END_DATE | datetime | None |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | None |
Table: LOG_MERGE_USER
LOG_MERGE_USER| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint | Part of PRIMARY KEY (ID) |
| ERROR_MESSAGE | text | None |
| FROM_USER_ID | int(11) | None |
| MERGED_DATE | datetime | None |
| NOTES | text | None |
| ORG_ID | int(11) | Part of KEY (ORG_ID) |
| REQUEST_ID | varchar(100) | None |
| STATUS | enum('SUCCESS','FAIL') | None |
| TILL_ID | int(11) | None |
| TO_USER_ID | int(11) | None |
| CREATED_ON | timestamp | None |
Table: TBL_USER_REWARD_LINK
TBL_USER_REWARD_LINK| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| USER_REWARD_ID | bigint(20) | Part of KEY (USER_REWARD_ID) |
| USER_PAYMENT_CONFIG_ID | bigint(20) | None |
| USER_REDEMPTION_DETAILS_ID | bigint(20) | None |
| ISSUE_REVENUE_DETAIL_ID | bigint(20) | None |
| USER_TENDER_DETAILS_ID | bigint(20) | None |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| LAST_UPDATED_BY | varchar(50) | None |
Table: REF_REWARD_LABELS_MAPPING
REF_REWARD_LABELS_MAPPING| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| REWARD_ID | bigint(20) | Part of KEY (REWARD_ID) |
| LABEL_ID | bigint(20) | None |
| IS_ENABLED | bit(1) | Part of KEY (IS_ENABLED) |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_FULFILLMENT_DETAILS
TBL_FULFILLMENT_DETAILS| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| STATUS_ID | bigint(20) | Part of KEY (STATUS_ID) |
| SCOPE_ID | bigint(20) | Part of KEY (SCOPE_ID) |
| ENTITY_ID | bigint(20) | Part of KEY (ENTITY_ID) |
| IS_ENABLED | bit(1) | None |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_USER_REDEMPTION_DETAILS
TBL_USER_REDEMPTION_DETAILS| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| REWARD_ID | bigint(20) | None |
| REDEMPTION_TYPE | int(11) | None |
| REDEMPTION_VALUE | decimal(13,4) | None |
| VENDOR_REDEMPTION_ID | bigint(20) | None |
| VENDOR_ID | bigint(20) | None |
| TRANSACTION_ID | bigint(20) | Part of KEY (TRANSACTION_ID) |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| CREATED_ON | timestamp | None |
Table: TBL_VENDOR_DETAILS_EXTN_PROPERTY
TBL_VENDOR_DETAILS_EXTN_PROPERTY| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| TYPE | varchar(255) | Part of UNIQUE KEY (TYPE) |
| DESCRIPTION | varchar(255) | None |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | None |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_MIGRATE_TRANSACTIONS
TBL_MIGRATE_TRANSACTIONS| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| TRANSACTION_ID | bigint(20) | None |
| IS_MIG | bit(1) | None |
| LAST_UPDATED_ON | timestamp | None |
| CREATED_ON | timestamp | None |
Table: TBL_VENDOR_REDEMPTION
TBL_VENDOR_REDEMPTION| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| NAME | varchar(255) | None |
| REDEMPTION_TYPE | int(11) | Part of KEY (REDEMPTION_TYPE) |
| IS_ENABLED | bit(1) | Part of KEY (IS_ENABLED) |
| RESPONSE_KEYS | json | None |
| VENDOR_ID | bigint(20) | Part of KEY (VENDOR_ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| LAST_UPDATED_ON | timestamp | None |
| CREATED_ON | timestamp | None |
Table: TBL_USER_PAYMENT_CONFIG
TBL_USER_PAYMENT_CONFIG| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| REWARD_ID | bigint(20) | None |
| PAYMENT_CONFIG_ID | bigint(20) | Part of KEY (PAYMENT_CONFIG_ID) |
| CONFIG_TYPE | enum('FREE', | None |
| TRANSACTION_ID | bigint(20) | None |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| CREATED_ON | timestamp | None |
Table: TBL_USER_TENDER_ITEMS
TBL_USER_TENDER_ITEMS| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of PRIMARY KEY (ORG_ID) |
| TENDER_DETAILS_ID | bigint(20) | None |
| MODE | varchar(255) | None |
| IDENTIFIER | varchar(255) | None |
| TENDER_TRANX_ID | varchar(255) | None |
| AMOUNT | decimal(13,4) | None |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| CREATED_ON | timestamp | None |
Table: REF_REWARD_PROGRAM_MAPPING
REF_REWARD_PROGRAM_MAPPING| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| REWARD_ID | bigint(20) | Part of KEY (REWARD_ID) |
| LOYALTY_PROGRAM_ID | bigint(20) | Part of KEY (LOYALTY_PROGRAM_ID) |
| ENTITY_TYPE | enum('TIER','SUBSCRIPTION','ALL_LOYALTY') | Part of KEY (ENTITY_TYPE) |
| ENTITY_ID | bigint(20) | None |
| IS_ENABLED | bit(1) | None |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | None |
| LAST_UPDATED_BY | varchar(50) | None |
Table: REF_REWARD_CARDS_MAPPING
REF_REWARD_CARDS_MAPPING| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| REWARD_ID | bigint(20) | Part of KEY (REWARD_ID) |
| CARD_SERIES_ID | bigint(20) | None |
| IS_ENABLED | bit(1) | Part of KEY (IS_ENABLED) |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_FULFILLMENT_STATUS
TBL_FULFILLMENT_STATUS| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| NAME | varchar(255) | Part of KEY (NAME) |
| IS_ENABLED | bit(1) | Part of KEY (IS_ENABLED) |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_VENDOR_REDEMPTION_ACTION
TBL_VENDOR_REDEMPTION_ACTION| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| API_BODY | json | None |
| API_HEADERS | json | None |
| API_TYPE | varchar(255) | None |
| API_URL | varchar(255) | None |
| CONTEXT_KEYS | json | None |
| IS_ENABLED | bit(1) | None |
| EXEC_ORDER | int(11) | None |
| NAME | varchar(255) | None |
| IS_RETRY_ACTION | bit(1) | None |
| VENDOR_REDEMPTION_ID | bigint(20) | Part of KEY (VENDOR_REDEMPTION_ID) |
| ORG_ID | bigint(20) | Part of PRIMARY KEY (ORG_ID) |
| LAST_UPDATED_ON | timestamp | None |
| CREATED_ON | timestamp | None |
Table: TBL_USER_CUSTOM_FIELD_MAPPING
TBL_USER_CUSTOM_FIELD_MAPPING| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| CUSTOM_FIELD_ID | bigint(20) | Part of KEY (CUSTOM_FIELD_ID) |
| SCOPE_ID | bigint(20) | Part of KEY (SCOPE_ID) |
| ENTITY_ID | bigint(20) | Part of KEY (ENTITY_ID) |
| CUSTOM_FIELD_VALUE | varchar(255) | None |
| IS_ACTIVE | bit(1) | Part of KEY (IS_ACTIVE) |
| CREATED_BY | varchar(50) | None |
| CREATED_ON | timestamp | None |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_REWARD_REVENUE
TBL_REWARD_REVENUE| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| REWARD_ID | bigint(20) | Part of KEY (REWARD_ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| COMMISSION_PARTICIPANT | enum('BRAND','CAPILLARY','AFFILIATE','END_CUSTOMER') | Part of KEY (COMMISSION_PARTICIPANT) |
| COMMISSION_RATE | decimal(10,2) | None |
| CYCLE_START_DATE | datetime | None |
| CYCLE_END_DATE | datetime | None |
| IS_ACTIVE | bit(1) | Part of KEY (IS_ACTIVE) |
| CREATED_ON | timestamp | None |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| LAST_UPDATED_BY | varchar(50) | None |
| CREATED_BY | varchar(50) | None |
Table: TBL_CUSTOM_FIELD_ENUMS
TBL_CUSTOM_FIELD_ENUMS| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of UNIQUE KEY (ORG_ID) |
| CUSTOM_FIELD_ID | bigint(20) | Part of UNIQUE KEY (CUSTOM_FIELD_ID) |
| ENUM_VALUE | varchar(256) | Part of UNIQUE KEY (ENUM_VALUE) |
| IS_ENABLED | bit(1) | Part of UNIQUE KEY (IS_ENABLED) |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | None |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_COUNTRY
TBL_COUNTRY| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| BRAND_ID | bigint(20) | None |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| IS_ENABLED | bit(1) | None |
| NAME | varchar(255) | Part of KEY (NAME) |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| CREATED_ON | timestamp | None |
Table: TBL_VENDOR_DETAILS
TBL_VENDOR_DETAILS| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| NAME | varchar(255) | Part of UNIQUE KEY (NAME) |
| VALUE | varchar(255) | None |
| VENDOR_ID | bigint(20) | Part of UNIQUE KEY (VENDOR_ID) |
| ORG_ID | bigint(20) | Part of PRIMARY KEY (ORG_ID) |
| LAST_UPDATED_ON | timestamp | None |
| CREATED_ON | timestamp | None |
Table: REF_CATALOG_PROMOTION_DETAILS_AUD
REF_CATALOG_PROMOTION_DETAILS_AUD| Column Name | Data Type | Index |
|---|---|---|
| PROMOTION_ID | bigint(20) | Part of PRIMARY KEY (PROMOTION_ID) |
| LANGUAGE_CODE | varchar(255) | Part of PRIMARY KEY (LANGUAGE_CODE) |
| REV | int(11) | Part of KEY (REV) |
| IS_ENABLED | bit(1) | None |
| REVTYPE | tinyint(4) | None |
| ORG_ID | bigint(20) | Part of PRIMARY KEY (ORG_ID) |
| NAME | varchar(255) | None |
| DESCRIPTION | text | None |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | None |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_REWARD_DETAILS_EXTN_PROPERTY_VALUES
TBL_REWARD_DETAILS_EXTN_PROPERTY_VALUES| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| REWARD_ID | bigint(20) | Part of KEY (REWARD_ID) |
| LANGUAGE_CODE | char(10) | Part of KEY (LANGUAGE_CODE) |
| TYPE_ID | bigint(20) | Part of KEY (TYPE_ID) |
| PROPERTY_NAME | varchar(255) | None |
| PROPERTY_VALUE | varchar(4096) | None |
| IS_ENABLED | bit(1) | Part of KEY (IS_ENABLED) |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | None |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_REWARD_EXPIRY_REMINDER
TBL_REWARD_EXPIRY_REMINDER| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| IS_ACTIVE | bit(1) | Part of KEY (IS_ACTIVE) |
| DURATION | bigint(20) | None |
| DURATION_TYPE | enum('DAYS') | None |
| TIMING | varchar(20) | None |
| CRON_TASK_ID | bigint(20) | None |
| CREATED_BY | varchar(50) | None |
| CREATED_ON | timestamp | None |
| LAST_UPDATED_ON | timestamp | None |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_PAYMENT_CONFIG
TBL_PAYMENT_CONFIG| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| REWARD_ID | bigint(20) | Part of KEY (REWARD_ID) |
| CONFIG_TYPE | enum('FREE', | None |
| IS_ENABLED | bit(1) | Part of KEY (IS_ENABLED) |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_USER_PAYMENT_CONFIG_CURRENCY
TBL_USER_PAYMENT_CONFIG_CURRENCY| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| USER_CONFIG_ID | bigint(20) | Part of KEY (USER_CONFIG_ID) |
| CURRENCY_TYPE | enum('POINTS', | Part of KEY (CURRENCY_TYPE) |
| CURRENCY_VALUE | decimal(13,4) | None |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| CREATED_ON | timestamp | None |
Table: TBL_REWARD_UPLOAD
TBL_REWARD_UPLOAD| Column Name | Data Type | Index |
|---|---|---|
| ID | int(11) | None |
| ORG_ID | int(11) | None |
| JOB_STATUS | enum('CREATED','PROCESSING','COMPLETED','FAILED') | None |
| STATUS_CODE | int(11) | None |
| TOTAL_UPLOAD_COUNT | int(11) | None |
| SUCCESS_COUNT | int(11) | None |
| ERROR_COUNT | int(11) | None |
| UPLOADED_FILE_NAME | varchar(255) | None |
| UPLOADED_FILE_HANDLE | varchar(255) | None |
| UPLOADED_FILE_URL | varchar(1024) | None |
| UPLOADED_FILE_TYPE | enum('CSV','EXCEL') | None |
| SUCCESS_FILE_HANDLE | varchar(255) | None |
| SUCCESS_FILE_URL | varchar(1024) | None |
| ERROR_FILE_HANDLE | varchar(255) | None |
| ERROR_FILE_URL | varchar(1024) | None |
| CREATED_ON | timestamp | None |
| CREATED_BY | bigint(20) | None |
| UPDATED_ON | timestamp | None |
| UPDATED_BY | bigint(20) | None |
Table: REVINFO
REVINFO| Column Name | Data Type | Index |
|---|---|---|
| REV | int(11) | Part of PRIMARY KEY (REV) |
| REVTSTMP | bigint(20) | None |
Table: TBL_AREA
TBL_AREA| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| CITY_ID | bigint(20) | Part of KEY (CITY_ID) |
| IS_ENABLED | bit(1) | None |
| NAME | varchar(255) | Part of KEY (NAME) |
| ORG_ID | bigint(20) | Part of PRIMARY KEY (ORG_ID) |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| CREATED_ON | timestamp | None |
Table: TBL_USER_REWARD
TBL_USER_REWARD| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| BRAND_ID | bigint(20) | Part of KEY (BRAND_ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| INTOUCH_VOUCHER | varchar(255) | None |
| INTOUCH_VOUCHER_EXPIRY | varchar(255) | None |
| MOBILE | varchar(255) | Part of KEY (MOBILE) |
| INTOUCH_USER_ID | bigint(20) | Part of KEY (INTOUCH_USER_ID) |
| INTOUCH_POINTS_DEDUCTED | varchar(255) | None |
| IS_REDEEMED | bit(1) | None |
| REWARD_ID | bigint(20) | Part of KEY (REWARD_ID) |
| PROMOTION_ID | bigint(20) | None |
| REWARD_PROMOTION_LINK_ID | bigint(20) | None |
| VENDOR_REWARD | json | None |
| AUDIT_INFO | json | None |
| ISSUE_REWARD_REF_ID | varchar(255) | Part of KEY (ISSUE_REWARD_REF_ID) |
| ISSUED_REF_ID | varchar(255) | None |
| POINTS_REF_ID | varchar(255) | Part of KEY (POINTS_REF_ID) |
| TRANSACTION_ID | bigint(20) | Part of KEY (TRANSACTION_ID) |
| IS_ACTIVE | bit(1) | None |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| CREATED_ON | timestamp | Part of KEY (CREATED_ON) |
Table: TBL_CATALOG_PROMOTION
TBL_CATALOG_PROMOTION| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| IS_ENABLED | bit(1) | None |
| START_DATE | datetime | Part of KEY (START_DATE) |
| END_DATE | datetime | Part of KEY (END_DATE) |
| DISCOUNT_TYPE | enum('ABSOLUTE','PERCENTAGE', | None |
| DISCOUNT_VALUE | decimal(13,2) | None |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_CUSTOM_FIELD_MAPPING
TBL_CUSTOM_FIELD_MAPPING| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| CUSTOM_FIELD_ID | bigint(20) | Part of KEY (CUSTOM_FIELD_ID) |
| SCOPE | enum('REWARD','CATALOGUE_PROMOTION','ISSUE_REWARD') | Part of KEY (SCOPE) |
| ENTITY_ID | bigint(20) | Part of KEY (ENTITY_ID) |
| LANGUAGE_CODE | char(10) | Part of KEY (LANGUAGE_CODE) |
| CUSTOM_FIELD_VALUE | varchar(255) | None |
| IS_ACTIVE | bit(1) | Part of KEY (IS_ACTIVE) |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| LAST_UPDATED_BY | varchar(50) | None |
Table: REF_REWARD_DETAILS
REF_REWARD_DETAILS| Column Name | Data Type | Index |
|---|---|---|
| DESCRIPTION | text | None |
| IS_ENABLED | bit(1) | None |
| IMAGE_URI | varchar(255) | None |
| LANGUAGE_CODE | varchar(255) | Part of KEY (LANGUAGE_CODE) |
| NAME | varchar(255) | None |
| REWARD_ID | bigint(20) | Part of KEY (REWARD_ID) |
| TERM_N_CONDITIONS | varchar(255) | None |
| THUMBNAIL_URI | varchar(255) | None |
| IMAGE_PATH | varchar(255) | None |
| THUMBNAIL_PATH | varchar(255) | None |
| TERM_N_CONDITIONS_PATH | varchar(255) | None |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| CREATED_ON | timestamp | None |
| IS_MIGRATED | bit(1) | Part of KEY (IS_MIGRATED) |
Table: TBL_REWARD_CONSTRAINT
TBL_REWARD_CONSTRAINT| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| REWARD_ID | bigint(20) | Part of KEY (REWARD_ID) |
| ENABLED | bit(1) | Part of KEY (ENABLED) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| KPI | enum('TRANSACTION_COUNT','QUANTITY','POINTS','REDEMPTION_VALUE') | None |
| CONSTRAINT_LEVEL | enum('REWARD','CUSTOMER','TRANSACTION','CUSTOMER_REDEMPTION_TYPE','CUSTOMER_TIER' | None |
| CONSTRAINT_ATTRIBUTE | varchar(100) | None |
| WINDOW_TYPE | enum | None |
| OPERATOR | enum('EQUALS') | None |
| REPEAT_FREQUENCY_TYPE | enum('DAYS','MONTHS','WEEKS','NO_LIMIT') | None |
| INTERVAL_VALUE | int(20) | None |
| LIMIT_VALUE | int(20) | None |
| END_DATE | datetime | Part of KEY (END_DATE) |
| CREATED_BY | varchar(50) | None |
| CREATED_ON | timestamp | None |
| LAST_UPDATED_ON | timestamp | None |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_CONFIG_KEYS
TBL_CONFIG_KEYS| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| CONFIG_KEY | varchar(255) | None |
| DEFAULT_VALUE | varchar(255) | None |
| LABEL | varchar(255) | None |
Table: TBL_REWARD
TBL_REWARD| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of KEY (ID) |
| BRAND_ID | bigint(20) | None |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| IS_ENABLED | bit(1) | Part of KEY (IS_ENABLED) |
| END_DATE | datetime | Part of KEY (END_DATE) |
| INTOUCH_GROUP | varchar(255) | Part of KEY (INTOUCH_GROUP) |
| INTOUCH_POINTS | int(11) | None |
| INTOUCH_SERIES_ID | varchar(255) | None |
| LABEL | varchar(255) | Part of KEY (LABEL) |
| PRIORITY | int(11) | Part of KEY (PRIORITY) |
| REDEMPTION_TYPE | int(11) | None |
| START_DATE | datetime | Part of KEY (START_DATE) |
| INTOUCH_TIER | varchar(255) | Part of KEY (INTOUCH_TIER) |
| TYPE | varchar(255) | Part of KEY (TYPE) |
| VENDOR_REDEMPTION_ID | bigint(20) | Part of KEY (VENDOR_REDEMPTION_ID) |
| INTOUCH_TILL_ID | bigint(20) | None |
| PROGRAM_ID | bigint(20) | None |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| LAST_UPDATED_BY | varchar(50) | None |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| GROUP_ID | bigint(20) | None |
| GROUP_RANK | int(11) | None |
| REWARD_RANK | int(11) | None |
Table: TBL_CATEGORY
TBL_CATEGORY| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| BRAND_ID | bigint(20) | None |
| ORG_ID | bigint(20) | Part of UNIQUE KEY (ORG_ID) |
| IS_ENABLED | bit(1) | None |
| NAME | varchar(255) | Part of UNIQUE KEY (NAME) |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| CREATED_ON | timestamp | None |
Table: REF_REWARD_COMMUNICATION
REF_REWARD_COMMUNICATION| Column Name | Data Type | Index |
|---|---|---|
| COMMUNICATION_ID | bigint(20) | Part of KEY (COMMUNICATION_ID) |
| IS_ENABLED | bit(1) | None |
| REWARD_ID | bigint(20) | Part of KEY (REWARD_ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| LAST_UPDATED_ON | timestamp | None |
| CREATED_ON | timestamp | None |
Table: TBL_LINK_REWARD_CATALOG_PROMOTION_AUD
TBL_LINK_REWARD_CATALOG_PROMOTION_AUD| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| REV | int(11) | Part of KEY (REV) |
| REVTYPE | tinyint(4) | None |
| ORG_ID | bigint(20) | Part of PRIMARY KEY (ORG_ID) |
| IS_ACTIVE | bit(1) | None |
| REWARD_ID | bigint(20) | None |
| PROMOTION_ID | bigint(20) | None |
| LINK_START_DATE | datetime | None |
| LINK_END_DATE | datetime | None |
| INTOUCH_POINTS_POST_DISCOUNT | int(11) | None |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | None |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_ISSUE_REVENUE_DETAIL
TBL_ISSUE_REVENUE_DETAIL| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of KEY (ID) |
| REWARD_ID | bigint(20) | Part of KEY (REWARD_ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| BRAND_COMMISSION | decimal(10,2) | None |
| CAPILLARY_COMMISSION | decimal(10,2) | None |
| AFFILIATE_COMMISSION | decimal(10,2) | None |
| END_CUSTOMER_COMMISSION`decimal(10,2) | NOT | None |
| TRANSACTION_ID | bigint(20) | Part of KEY (TRANSACTION_ID) |
| CREATED_ON | timestamp | None |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| LAST_UPDATED_BY | varchar(50) | None |
| CREATED_BY | varchar(50) | None |
Table: TBL_USER_TENDER_DETAILS
TBL_USER_TENDER_DETAILS| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of PRIMARY KEY (ORG_ID) |
| ISSUE_REFERENCE_ID | varchar(255) | None |
| TOTAL_AMOUNT | decimal(13,4) | None |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| CREATED_ON | timestamp | None |
Table: TBL_COMMUNICATION
TBL_COMMUNICATION| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| API_BODY | json | None |
| API_HEADERS | json | None |
| API_TYPE | varchar(255) | None |
| API_URL | varchar(255) | None |
| BRAND_ID | bigint(20) | None |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| IS_ENABLED | bit(1) | None |
| NAME | varchar(255) | None |
| LAST_UPDATED_ON | timestamp | None |
| CREATED_ON | timestamp | None |
Table: REF_REWARD_SEGMENT_MAPPING
REF_REWARD_SEGMENT_MAPPING| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| REWARD_ID | bigint(20) | Part of KEY (REWARD_ID) |
| SEGMENT_ID | varchar(255) | None |
| PARTITION_ID | varchar(255) | None |
| IS_ENABLED | bit(1) | Part of KEY (IS_ENABLED) |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | None |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_BRAND
TBL_BRAND| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| IS_ENABLED | bit(1) | None |
| NAME | varchar(255) | Part of UNIQUE KEY (NAME) |
| ORG_ID | bigint(20) | Part of PRIMARY KEY (ORG_ID) |
| LAST_UPDATED_ON | timestamp | None |
| CREATED_ON | timestamp | None |
Table: TBL_REWARD_DETAILS_EXTN_PROPERTY
TBL_REWARD_DETAILS_EXTN_PROPERTY| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| TYPE | varchar(255) | Part of UNIQUE KEY (TYPE) |
| DESCRIPTION | varchar(255) | None |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | None |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_CITY
TBL_CITY| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| COUNTRY_ID | bigint(20) | Part of KEY (COUNTRY_ID) |
| IS_ENABLED | bit(1) | None |
| NAME | varchar(255) | Part of KEY (NAME) |
| ORG_ID | bigint(20) | Part of PRIMARY KEY (ORG_ID) |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| CREATED_ON | timestamp | None |
Table: REF_CATALOG_PROMOTION_DETAILS
REF_CATALOG_PROMOTION_DETAILS| Column Name | Data Type | Index |
|---|---|---|
| PROMOTION_ID | bigint(20) | Part of KEY (PROMOTION_ID) |
| IS_ENABLED | bit(1) | None |
| LANGUAGE_CODE | varchar(255) | Part of KEY (LANGUAGE_CODE) |
| ORG_ID | bigint(20) | Part of PRIMARY KEY (ORG_ID) |
| NAME | varchar(255) | None |
| DESCRIPTION | text | None |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_CATALOG_PROMOTION_AUD
TBL_CATALOG_PROMOTION_AUD| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of PRIMARY KEY (ORG_ID) |
| REV | int(11) | Part of KEY (REV) |
| REVTYPE | tinyint(4) | None |
| IS_ENABLED | bit(1) | None |
| START_DATE | datetime | None |
| END_DATE | datetime | None |
| DISCOUNT_TYPE | enum('ABSOLUTE','PERCENTAGE', | None |
| DISCOUNT_VALUE | decimal(13,2) | None |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | None |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_LINK_REWARD_CATALOG_PROMOTION
TBL_LINK_REWARD_CATALOG_PROMOTION| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| IS_ACTIVE | bit(1) | Part of KEY (IS_ACTIVE) |
| REWARD_ID | bigint(20) | Part of KEY (REWARD_ID) |
| PAYMENT_CONFIG_ID | bigint(20) | None |
| PROMOTION_ID | bigint(20) | Part of KEY (PROMOTION_ID) |
| LINK_START_DATE | datetime | Part of KEY (LINK_START_DATE) |
| LINK_END_DATE | datetime | Part of KEY (LINK_END_DATE) |
| INTOUCH_POINTS_POST_DISCOUNT | int(11) | None |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_TRANSACTION
TBL_TRANSACTION| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| REWARD_ID | bigint(20) | None |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| QUANTITY | bigint(20) | None |
| REQUESTED_QUANTITY | bigint(20) | None |
| STATUS_CODE | varchar(50) | None |
| INTOUCH_SERIES_ID | varchar(255) | None |
| REQUEST_ID | varchar(255) | None |
| EVENT_LOG_ID | varchar(255) | None |
| STATUS_MESSAGE | varchar(512) | None |
| SUCCESS | bit(1) | None |
| ISSUE_REFERENCE_ID | varchar(255) | None |
| TENDER_DETAILS_ID | bigint(20) | None |
| USER_ID | bigint(20) | Part of KEY (USER_ID) |
| OWNER_TYPE | enum('LOYALTY_PROGRAM', | None |
| OWNER_ID | varchar(255) | None |
| GROUP_LOYALTY_REDEMPTION | bit(1) | None |
| CREATED_BY | varchar(50) | None |
| CREATED_ON | timestamp | Part of KEY (CREATED_ON) |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| LAST_UPDATED_BY | varchar(50) | None |
| EVENT_DATE | timestamp | None |
Table: TBL_CUSTOM_FIELDS
TBL_CUSTOM_FIELDS| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of UNIQUE KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| NAME | varchar(255) | None |
| DESCRIPTION | varchar(255) | None |
| IS_MANDATORY | bit(1) | Part of KEY (IS_MANDATORY) |
| IS_ACTIVE | bit(1) | Part of KEY (IS_ACTIVE) |
| SCOPE | enum('REWARD','CATALOGUE_PROMOTION','ISSUE_REWARD') | Part of KEY (SCOPE) |
| DEFAULT_VALUE | varchar(255) | None |
| DATA_TYPE | enum('INTEGER','BOOLEAN', | None |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | Part of KEY (LAST_UPDATED_ON) |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_REWARD_ISSUE_SUMMARY
TBL_REWARD_ISSUE_SUMMARY| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| REWARD_ID | bigint(20) | Part of KEY (REWARD_ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| KPI | enum('TRANSACTION_COUNT','QUANTITY','POINTS','REDEMPTION_VALUE') | Part of KEY (KPI) |
| CONSTRAINT_LEVEL | enum('REWARD','CUSTOMER','TRANSACTION','CUSTOMER_REDEMPTION_TYPE','CUSTOMER_TIER' | Part of KEY (CONSTRAINT_LEVEL) |
| CONSTRAINT_ATTRIBUTE | varchar(100) | Part of KEY (CONSTRAINT_ATTRIBUTE) |
| CONSUMED | decimal(13,4) | None |
| USER_ID | bigint(20) | Part of KEY (USER_ID) |
| ISSUE_DATE | timestamp | Part of KEY (ISSUE_DATE) |
| CREATED_ON | timestamp | None |
| LAST_UPDATED_ON | timestamp | None |
| LAST_UPDATED_BY | varchar(50) | None |
| CREATED_BY | varchar(50) | None |
Table: TBL_VENDOR_DETAILS_EXTN_PROPERTY_VALUES
TBL_VENDOR_DETAILS_EXTN_PROPERTY_VALUES| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| VENDOR_ID | bigint(20) | Part of KEY (VENDOR_ID) |
| TYPE_ID | bigint(20) | Part of KEY (TYPE_ID) |
| PROPERTY_NAME | varchar(255) | None |
| ALT_TEXT | varchar(255) | None |
| PROPERTY_VALUE | varchar(4096) | None |
| IS_ENABLED | bit(1) | Part of KEY (IS_ENABLED) |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | None |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_REWARD_GROUP_MAPPING
TBL_REWARD_GROUP_MAPPING| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| REWARD_ID | bigint(20) | Part of KEY (REWARD_ID) |
| GROUP_ID | bigint(20) | None |
| REWARD_GROUP_RANK | int(11) | None |
| IS_ACTIVE | boolean | Part of KEY (IS_ACTIVE) |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | None |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_CONFIG_VALUES
TBL_CONFIG_VALUES| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| CONFIG_KEY_ID | bigint(20) | Part of KEY (CONFIG_KEY_ID) |
| BRAND_ID | bigint(20) | None |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| VALUE | varchar(255) | None |
Table: TBL_REWARD_ISSUE_SUMMARY_AUD
TBL_REWARD_ISSUE_SUMMARY_AUD| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| REWARD_ID | bigint(20) | None |
| REV | int(11) | Part of PRIMARY KEY (REV) |
| REVTYPE | tinyint(4) | None |
| ORG_ID | bigint(20) | Part of PRIMARY KEY (ORG_ID) |
| KPI | enum('TRANSACTION_COUNT','QUANTITY') | None |
| CONSTRAINT_LEVEL | enum('REWARD','CUSTOMER','TRANSACTION') | None |
| CONSUMED | bigint(20) | None |
| USER_ID | bigint(20) | None |
| ISSUE_DATE | timestamp | None |
| CREATED_ON | timestamp | None |
| CREATED_BY | varchar(50) | None |
| LAST_UPDATED_ON | timestamp | None |
| LAST_UPDATED_BY | varchar(50) | None |
Table: TBL_DETAILS_SCOPE
TBL_DETAILS_SCOPE| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| NAME | varchar(255) | None |
| CREATED_ON | timestamp | None |
| LAST_UPDATED_ON | timestamp | None |
Table: LOG_DOWNSTREAM_FAILURE
LOG_DOWNSTREAM_FAILURE| Column Name | Data Type | Index |
|---|---|---|
| ID | bigint(20) | Part of PRIMARY KEY (ID) |
| ORG_ID | bigint(20) | Part of KEY (ORG_ID) |
| CUSTOMER_ID | bigint(20) | Part of KEY (CUSTOMER_ID) |
| API | varchar(255) | None |
| TYPE | varchar(20) | None |
| MARVEL_REQUEST_ID | varchar(50) | Part of KEY (MARVEL_REQUEST_ID) |
| DOWNSTREAM_REQUEST_ID | varchar(50) | Part of KEY (DOWNSTREAM_REQUEST_ID) |
| REQUEST | TEXT | None |
| RESPONSE | TEXT | None |
| STATUS_CODE | bigint(20) | Part of KEY (STATUS_CODE) |
| CREATED_ON | timestamp | None |
Table: MASTER_KEY_TBL
MASTER_KEY_TBL| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| master_key_type | enum('AWS_KMS') | None |
| cluster | varchar(255) | None |
| reference_id | varchar(255) | None |
| created_time | timestamp | None |
| updated_time | timestamp | None |
Table: DATA_KEY_VERSION_TBL
DATA_KEY_VERSION_TBL| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| org_id | bigint(20) | Part of PRIMARY KEY (org_id) |
| data_key_id | bigint(20) | None |
| encrypted_key_blob | BLOB | None |
| is_default | bit(1) | None |
| version | int(11) | None |
| created_time | timestamp | None |
| updated_time | timestamp | None |
Table: ACT_CAP_ORG_NOTIFICATION_CREDENTIALS
ACT_CAP_ORG_NOTIFICATION_CREDENTIALS| Column Name | Data Type | Index |
|---|---|---|
| id | bigint | Part of PRIMARY KEY (id) |
| org_id | varchar(255) | None |
| publisher_id | varchar(255) | None |
| subscriber_id | varchar(255) | None |
Table: ACT_CAP_ORG_WORKFLOW_META
ACT_CAP_ORG_WORKFLOW_META| Column Name | Data Type | Index |
|---|---|---|
| id | bigint | Part of PRIMARY KEY (id) |
| auto_update_time | datetime | None |
| created_by | bigint | None |
| created_on | datetime | None |
| diff_json | json | None |
| is_active | bit(1) | None |
| is_approved | bit(1) | None |
| is_async | bit(1) | None |
| is_default | bit(1) | None |
| merchant_id_strategy | varchar(255) | None |
| org_id | bigint | None |
| process_id | varchar(255) | None |
| promoted_on | datetime | None |
| use_case | varchar(255) | None |
| version_name | varchar(255) | None |
| workflow_json | json | None |
| workflow_name | varchar(255) | None |
Table: ACT_CAP_EXTERNAL_API_ERROR_MAPPING
ACT_CAP_EXTERNAL_API_ERROR_MAPPING| Column Name | Data Type | Index |
|---|---|---|
| id | bigint | Part of PRIMARY KEY (id) |
| api_name | varchar(255) | None |
| brand | varchar(255) | None |
| error_number | int | None |
| is_retryable | bit(1) | None |
| ota_error_number | varchar(255) | None |
| use_case | varchar(255) | None |
| error_identifier | varchar(200) | None |
Table: DATA_KEY_TBL
DATA_KEY_TBL| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| org_id | bigint(20) | Part of PRIMARY KEY (org_id) |
| master_key_id | bigint(20) | None |
| is_active | bit(1) | None |
| data_key_owner | varchar(100) | None |
| created_time | timestamp | None |
| updated_time | timestamp | None |
Table: ACT_CAP_DYNAMIC_PROPERTIES
ACT_CAP_DYNAMIC_PROPERTIES| Column Name | Data Type | Index |
|---|---|---|
| id | bigint | Part of PRIMARY KEY (id) |
| is_active | bit(1) | None |
| org_id | bigint | None |
| property_key | varchar(255) | None |
| property_type | varchar(255) | None |
| property_value | text | None |
| version | varchar(255) | None |
| workflow_name | varchar(255) | None |
Table: ACT_CAP_CALLBACK_LOGS
ACT_CAP_CALLBACK_LOGS| Column Name | Data Type | Index |
|---|---|---|
| id | bigint | Part of PRIMARY KEY (id) |
| callback_verified_with_psp | bit(1) | None |
| capture_amount | varchar(255) | None |
| created_time | datetime | None |
| currency_code | varchar(255) | None |
| invoice_number | varchar(255) | None |
| merchant_id | varchar(255) | None |
| merchant_identifier_strategy | varchar(255) | None |
| meta_data | json | None |
| next_step | varchar(255) | None |
| org_id | bigint | None |
| payment_id | varchar(255) | None |
| payment_provider_name | varchar(255) | None |
| pre_auth_amount | varchar(255) | None |
| process_instance_id | varchar(255) | None |
| psp_name | varchar(255) | None |
| x_cap_request_id | varchar(255) | None |
| status | varchar(255) | None |
| terminating_error_location | varchar(255) | None |
| terminating_error_message | varchar(255) | None |
| message | varchar(255) | None |
| transaction_failure | varchar(255) | None |
| txn_processing_state | varchar(255) | None |
| txn_reference_number | varchar(255) | None |
| updated_time | datetime | None |
| user_id | bigint | None |
| workflow_name | varchar(255) | None |
Table: ACT_CAP_TRANSACTIONS
ACT_CAP_TRANSACTIONS| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| callback_verified_with_psp | bit(1) | None |
| capture_amount | varchar(15) | None |
| created_time | datetime | None |
| currency_code | varchar(10) | None |
| invoice_number | varchar(100) | None |
| merchant_id | varchar(50) | None |
| merchant_identifier_strategy | varchar(10) | None |
| meta_data | json | None |
| next_step | varchar(50) | None |
| org_id | bigint(20) | Part of KEY (org_id) |
| payment_id | varchar(30) | Part of UNIQUE KEY (payment_id) |
| payment_provider_name | varchar(50) | None |
| pre_auth_amount | varchar(15) | None |
| process_instance_id | varchar(50) | Part of KEY (process_instance_id) |
| psp_name | varchar(30) | None |
| x_cap_request_id | varchar(50) | None |
| schema_version | varchar(5) | None |
| status | varchar(15) | None |
| terminating_error_location | varchar(50) | None |
| terminating_error_message | varchar(255) | None |
| message | varchar(255) | None |
| transaction_failure | varchar(100) | None |
| txn_processing_state | varchar(100) | None |
| journey_status_cause | varchar(100) | None |
| txn_reference_number | varchar(100) | None |
| updated_time | datetime | None |
| user_id | bigint(20) | None |
| workflow_name | varchar(30) | None |
| approval_code | varchar(50) | None |
| auto_update_time | timestamp | None |
Table: ACTION_DATA_LOG
ACTION_DATA_LOG| Column Name | Data Type | Index |
|---|---|---|
| action_log_id | bigint | Part of PRIMARY KEY (action_log_id) |
| API_message | varchar(255) | None |
| API_response_code | varchar(255) | None |
| action_name | varchar(255) | None |
| action_skipped | bit(1) | None |
| attempt | varchar(255) | None |
| http_status_code | varchar(255) | None |
| respond_time_stamp | varchar(255) | None |
| Start_time_stamp | varchar(255) | None |
| status | varchar(255) | None |
| created_time | datetime | None |
| org_id | bigint | None |
| updated_time | datetime | None |
| txn_id | bigint | Part of KEY (txn_id) |
Table: ACT_CAP_ACTION_DATA
ACT_CAP_ACTION_DATA| Column Name | Data Type | Index |
|---|---|---|
| CallBackLogsDto_id | bigint | Part of KEY (CallBackLogsDto_id) |
| API_message | varchar(255) | None |
| API_response_code | varchar(255) | None |
| action_name | varchar(255) | None |
| action_skipped | bit(1) | None |
| attempt | varchar(255) | None |
| http_status_code | varchar(255) | None |
| respond_time_stamp | varchar(255) | None |
| Start_time_stamp | varchar(255) | None |
| status | varchar(255) | None |
| created_time | datetime | None |
| org_id | bigint | None |
| updated_time | datetime | None |
Table: ACT_CAP_ACTION_DATA_LOG
ACT_CAP_ACTION_DATA_LOG| Column Name | Data Type | Index |
|---|---|---|
| action_log_id | bigint(20) | Part of PRIMARY KEY (action_log_id) |
| API_message | varchar(250) | None |
| API_response_code | varchar(20) | None |
| action_name | varchar(100) | None |
| action_skipped | bit(1) | None |
| attempt | varchar(10) | None |
| http_status_code | varchar(30) | None |
| respond_time_stamp | varchar(255) | None |
| Start_time_stamp | varchar(255) | None |
| status | varchar(20) | None |
| created_time | datetime | None |
| org_id | bigint(20) | None |
| updated_time | datetime | None |
| txn_id | bigint(20) | Part of KEY (txn_id) |
Updated 1 day ago