UM_* — Users, roles, tenants¶

24 tables in APIM 3.2.0.

UM_ACCOUNT_MAPPING¶

Shared DB (WSO2SHARED_DB) · PK: UM_ID · Unique: UM_USER_NAME, UM_TENANT_ID, UM_USER_STORE_DOMAIN, UM_ACC_LINK_ID

Column	Type	Notes
`UM_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_USER_NAME`	`VARCHAR(255)`	NOT NULL
`UM_TENANT_ID`	`INTEGER`	FK → UM_TENANT · NOT NULL
`UM_USER_STORE_DOMAIN`	`VARCHAR(100)`
`UM_ACC_LINK_ID`	`INTEGER`	NOT NULL

Foreign keys

UM_TENANT_ID → UM_TENANT UM_ID (on delete: CASCADE)

UM_CLAIM¶

Shared DB (WSO2SHARED_DB) · PK: UM_ID, UM_TENANT_ID · Unique: UM_DIALECT_ID, UM_CLAIM_URI, UM_TENANT_ID, UM_MAPPED_ATTRIBUTE_DOMAIN

Column	Type	Notes
`UM_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_DIALECT_ID`	`INTEGER`	FK → UM_DIALECT · NOT NULL
`UM_CLAIM_URI`	`VARCHAR(255)`	NOT NULL
`UM_DISPLAY_TAG`	`VARCHAR(255)`
`UM_DESCRIPTION`	`VARCHAR(255)`
`UM_MAPPED_ATTRIBUTE_DOMAIN`	`VARCHAR(255)`
`UM_MAPPED_ATTRIBUTE`	`VARCHAR(255)`
`UM_REG_EX`	`VARCHAR(255)`
`UM_SUPPORTED`	`SMALLINT`
`UM_REQUIRED`	`SMALLINT`
`UM_DISPLAY_ORDER`	`INTEGER`
`UM_CHECKED_ATTRIBUTE`	`SMALLINT`
`UM_READ_ONLY`	`SMALLINT`
`UM_TENANT_ID`	`INTEGER`	PK · FK → UM_DIALECT · DEFAULT 0

Foreign keys

UM_DIALECT_ID, UM_TENANT_ID → UM_DIALECT UM_ID, UM_TENANT_ID

Referenced by

UM_CLAIM_BEHAVIOR via UM_CLAIM_ID, UM_TENANT_ID

UM_CLAIM_BEHAVIOR¶

Shared DB (WSO2SHARED_DB) · PK: UM_ID, UM_TENANT_ID

Column	Type	Notes
`UM_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_PROFILE_ID`	`INTEGER`	FK → UM_PROFILE_CONFIG
`UM_CLAIM_ID`	`INTEGER`	FK → UM_CLAIM
`UM_BEHAVIOUR`	`SMALLINT`
`UM_TENANT_ID`	`INTEGER`	PK · FK → UM_CLAIM · DEFAULT 0

Foreign keys

UM_PROFILE_ID, UM_TENANT_ID → UM_PROFILE_CONFIG UM_ID, UM_TENANT_ID
UM_CLAIM_ID, UM_TENANT_ID → UM_CLAIM UM_ID, UM_TENANT_ID

UM_DIALECT¶

Shared DB (WSO2SHARED_DB) · PK: UM_ID, UM_TENANT_ID · Unique: UM_DIALECT_URI, UM_TENANT_ID

Column	Type	Notes
`UM_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_DIALECT_URI`	`VARCHAR(255)`	NOT NULL
`UM_TENANT_ID`	`INTEGER`	PK · DEFAULT 0

Referenced by

UM_CLAIM via UM_DIALECT_ID, UM_TENANT_ID
UM_PROFILE_CONFIG via UM_DIALECT_ID, UM_TENANT_ID

UM_DOMAIN¶

Shared DB (WSO2SHARED_DB) · PK: UM_DOMAIN_ID, UM_TENANT_ID · Unique: UM_DOMAIN_NAME, UM_TENANT_ID

Column	Type	Notes
`UM_DOMAIN_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_DOMAIN_NAME`	`VARCHAR(255)`	NOT NULL
`UM_TENANT_ID`	`INTEGER`	PK · DEFAULT 0

Referenced by

UM_HYBRID_USER_ROLE via UM_DOMAIN_ID, UM_TENANT_ID
UM_ROLE_PERMISSION via UM_DOMAIN_ID, UM_TENANT_ID
UM_UUID_DOMAIN_MAPPER via UM_DOMAIN_ID, UM_TENANT_ID

UM_HYBRID_REMEMBER_ME¶

Shared DB (WSO2SHARED_DB) · PK: UM_ID, UM_TENANT_ID

Column	Type	Notes
`UM_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_USER_NAME`	`VARCHAR(255)`	NOT NULL
`UM_COOKIE_VALUE`	`VARCHAR(1024)`
`UM_CREATED_TIME`	`TIMESTAMP`
`UM_TENANT_ID`	`INTEGER`	PK · DEFAULT 0

UM_HYBRID_ROLE¶

Shared DB (WSO2SHARED_DB) · PK: UM_ID, UM_TENANT_ID · Unique: UM_ROLE_NAME, UM_TENANT_ID

Column	Type	Notes
`UM_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_ROLE_NAME`	`VARCHAR(255)`	NOT NULL
`UM_TENANT_ID`	`INTEGER`	PK · DEFAULT 0

Referenced by

UM_HYBRID_USER_ROLE via UM_ROLE_ID, UM_TENANT_ID

UM_HYBRID_USER_ROLE¶

Shared DB (WSO2SHARED_DB) · PK: UM_ID, UM_TENANT_ID · Unique: UM_USER_NAME, UM_ROLE_ID, UM_TENANT_ID, UM_DOMAIN_ID

Column	Type	Notes
`UM_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_USER_NAME`	`VARCHAR(255)`
`UM_ROLE_ID`	`INTEGER`	FK → UM_HYBRID_ROLE · NOT NULL
`UM_TENANT_ID`	`INTEGER`	PK · FK → UM_DOMAIN · DEFAULT 0
`UM_DOMAIN_ID`	`INTEGER`	FK → UM_DOMAIN

Foreign keys

UM_ROLE_ID, UM_TENANT_ID → UM_HYBRID_ROLE UM_ID, UM_TENANT_ID (on delete: CASCADE)
UM_DOMAIN_ID, UM_TENANT_ID → UM_DOMAIN UM_DOMAIN_ID, UM_TENANT_ID (on delete: CASCADE)

UM_MODULE¶

Shared DB (WSO2SHARED_DB) · PK: UM_ID · Unique: UM_MODULE_NAME

Column	Type	Notes
`UM_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_MODULE_NAME`	`VARCHAR(100)`

Referenced by

UM_MODULE_ACTIONS via UM_MODULE_ID

UM_MODULE_ACTIONS¶

Shared DB (WSO2SHARED_DB) · PK: UM_ACTION, UM_MODULE_ID

Column	Type	Notes
`UM_ACTION`	`VARCHAR(255)`	PK · NOT NULL
`UM_MODULE_ID`	`INTEGER`	PK · FK → UM_MODULE · NOT NULL

Foreign keys

UM_MODULE_ID → UM_MODULE UM_ID (on delete: CASCADE)

UM_PERMISSION¶

Shared DB (WSO2SHARED_DB) · PK: UM_ID, UM_TENANT_ID · Unique: UM_RESOURCE_ID, UM_ACTION, UM_TENANT_ID

Column	Type	Notes
`UM_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_RESOURCE_ID`	`VARCHAR(255)`	NOT NULL
`UM_ACTION`	`VARCHAR(255)`	NOT NULL
`UM_TENANT_ID`	`INTEGER`	PK · DEFAULT 0
`UM_MODULE_ID`	`INTEGER`	DEFAULT 0

Referenced by

UM_ROLE_PERMISSION via UM_PERMISSION_ID, UM_TENANT_ID
UM_USER_PERMISSION via UM_PERMISSION_ID, UM_TENANT_ID

UM_PROFILE_CONFIG¶

Shared DB (WSO2SHARED_DB) · PK: UM_ID, UM_TENANT_ID

Column	Type	Notes
`UM_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_DIALECT_ID`	`INTEGER`	FK → UM_DIALECT · NOT NULL
`UM_PROFILE_NAME`	`VARCHAR(255)`
`UM_TENANT_ID`	`INTEGER`	PK · FK → UM_DIALECT · DEFAULT 0

Foreign keys

UM_DIALECT_ID, UM_TENANT_ID → UM_DIALECT UM_ID, UM_TENANT_ID

Referenced by

UM_CLAIM_BEHAVIOR via UM_PROFILE_ID, UM_TENANT_ID

UM_ROLE¶

Shared DB (WSO2SHARED_DB) · PK: UM_ID, UM_TENANT_ID · Unique: UM_ROLE_NAME, UM_TENANT_ID

Column	Type	Notes
`UM_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_ROLE_NAME`	`VARCHAR(255)`	NOT NULL
`UM_TENANT_ID`	`INTEGER`	PK · DEFAULT 0
`UM_SHARED_ROLE`	`BOOLEAN`	DEFAULT FALSE

Referenced by

UM_SHARED_USER_ROLE via UM_ROLE_ID, UM_ROLE_TENANT_ID
UM_USER_ROLE via UM_ROLE_ID, UM_TENANT_ID

UM_ROLE_PERMISSION¶

Shared DB (WSO2SHARED_DB) · PK: UM_ID, UM_TENANT_ID · Unique: UM_PERMISSION_ID, UM_ROLE_NAME, UM_TENANT_ID, UM_DOMAIN_ID

Column	Type	Notes
`UM_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_PERMISSION_ID`	`INTEGER`	FK → UM_PERMISSION · NOT NULL
`UM_ROLE_NAME`	`VARCHAR(255)`	NOT NULL
`UM_IS_ALLOWED`	`SMALLINT`	NOT NULL
`UM_TENANT_ID`	`INTEGER`	PK · FK → UM_DOMAIN · DEFAULT 0
`UM_DOMAIN_ID`	`INTEGER`	FK → UM_DOMAIN

Foreign keys

UM_PERMISSION_ID, UM_TENANT_ID → UM_PERMISSION UM_ID, UM_TENANT_ID (on delete: CASCADE)
UM_DOMAIN_ID, UM_TENANT_ID → UM_DOMAIN UM_DOMAIN_ID, UM_TENANT_ID (on delete: CASCADE)

UM_SHARED_USER_ROLE¶

Shared DB (WSO2SHARED_DB) · PK: — · Unique: UM_USER_ID, UM_ROLE_ID, UM_USER_TENANT_ID, UM_ROLE_TENANT_ID

Column	Type	Notes
`UM_ROLE_ID`	`INTEGER`	FK → UM_ROLE · NOT NULL
`UM_USER_ID`	`INTEGER`	FK → UM_USER · NOT NULL
`UM_USER_TENANT_ID`	`INTEGER`	FK → UM_USER · NOT NULL
`UM_ROLE_TENANT_ID`	`INTEGER`	FK → UM_ROLE · NOT NULL

Foreign keys

UM_ROLE_ID, UM_ROLE_TENANT_ID → UM_ROLE UM_ID, UM_TENANT_ID (on delete: CASCADE)
UM_USER_ID, UM_USER_TENANT_ID → UM_USER UM_ID, UM_TENANT_ID (on delete: CASCADE)

UM_SYSTEM_ROLE¶

Shared DB (WSO2SHARED_DB) · PK: UM_ID, UM_TENANT_ID · Unique: UM_ROLE_NAME, UM_TENANT_ID

Column	Type	Notes
`UM_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_ROLE_NAME`	`VARCHAR(255)`	NOT NULL
`UM_TENANT_ID`	`INTEGER`	PK · DEFAULT 0

Referenced by

UM_SYSTEM_USER_ROLE via UM_ROLE_ID, UM_TENANT_ID

UM_SYSTEM_USER¶

Shared DB (WSO2SHARED_DB) · PK: UM_ID, UM_TENANT_ID · Unique: UM_USER_NAME, UM_TENANT_ID

Column	Type	Notes
`UM_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_USER_NAME`	`VARCHAR(255)`	NOT NULL
`UM_USER_PASSWORD`	`VARCHAR(255)`	NOT NULL
`UM_SALT_VALUE`	`VARCHAR(31)`
`UM_REQUIRE_CHANGE`	`BOOLEAN`	DEFAULT FALSE
`UM_CHANGED_TIME`	`TIMESTAMP`	NOT NULL
`UM_TENANT_ID`	`INTEGER`	PK · DEFAULT 0

UM_SYSTEM_USER_ROLE¶

Shared DB (WSO2SHARED_DB) · PK: UM_ID, UM_TENANT_ID · Unique: UM_USER_NAME, UM_ROLE_ID, UM_TENANT_ID

Column	Type	Notes
`UM_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_USER_NAME`	`VARCHAR(255)`
`UM_ROLE_ID`	`INTEGER`	FK → UM_SYSTEM_ROLE · NOT NULL
`UM_TENANT_ID`	`INTEGER`	PK · FK → UM_SYSTEM_ROLE · DEFAULT 0

Foreign keys

UM_ROLE_ID, UM_TENANT_ID → UM_SYSTEM_ROLE UM_ID, UM_TENANT_ID

UM_TENANT¶

Shared DB (WSO2SHARED_DB) · PK: UM_ID · Unique: UM_DOMAIN_NAME

Column	Type	Notes
`UM_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_DOMAIN_NAME`	`VARCHAR(255)`	NOT NULL
`UM_EMAIL`	`VARCHAR(255)`
`UM_ACTIVE`	`BOOLEAN`	DEFAULT FALSE
`UM_CREATED_DATE`	`TIMESTAMP`	NOT NULL
`UM_USER_CONFIG`	`LONGBLOB`

Referenced by

UM_ACCOUNT_MAPPING via UM_TENANT_ID

UM_USER¶

Shared DB (WSO2SHARED_DB) · PK: UM_ID, UM_TENANT_ID · Unique: UM_USER_ID, UM_TENANT_ID

Column	Type	Notes
`UM_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_USER_ID`	`VARCHAR(255)`	NOT NULL
`UM_USER_NAME`	`VARCHAR(255)`	NOT NULL
`UM_USER_PASSWORD`	`VARCHAR(255)`	NOT NULL
`UM_SALT_VALUE`	`VARCHAR(31)`
`UM_REQUIRE_CHANGE`	`BOOLEAN`	DEFAULT FALSE
`UM_CHANGED_TIME`	`TIMESTAMP`	NOT NULL
`UM_TENANT_ID`	`INTEGER`	PK · DEFAULT 0

Referenced by

UM_SHARED_USER_ROLE via UM_USER_ID, UM_USER_TENANT_ID
UM_USER_ATTRIBUTE via UM_USER_ID, UM_TENANT_ID
UM_USER_ROLE via UM_USER_ID, UM_TENANT_ID

UM_USER_ATTRIBUTE¶

Shared DB (WSO2SHARED_DB) · PK: UM_ID, UM_TENANT_ID

Column	Type	Notes
`UM_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_ATTR_NAME`	`VARCHAR(255)`	NOT NULL
`UM_ATTR_VALUE`	`VARCHAR(1024)`
`UM_PROFILE_ID`	`VARCHAR(255)`
`UM_USER_ID`	`INTEGER`	FK → UM_USER
`UM_TENANT_ID`	`INTEGER`	PK · FK → UM_USER · DEFAULT 0

Foreign keys

UM_USER_ID, UM_TENANT_ID → UM_USER UM_ID, UM_TENANT_ID

UM_USER_PERMISSION¶

Shared DB (WSO2SHARED_DB) · PK: UM_ID, UM_TENANT_ID

Column	Type	Notes
`UM_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_PERMISSION_ID`	`INTEGER`	FK → UM_PERMISSION · NOT NULL
`UM_USER_NAME`	`VARCHAR(255)`	NOT NULL
`UM_IS_ALLOWED`	`SMALLINT`	NOT NULL
`UM_TENANT_ID`	`INTEGER`	PK · FK → UM_PERMISSION · DEFAULT 0

Foreign keys

UM_PERMISSION_ID, UM_TENANT_ID → UM_PERMISSION UM_ID, UM_TENANT_ID (on delete: CASCADE)

UM_USER_ROLE¶

Shared DB (WSO2SHARED_DB) · PK: UM_ID, UM_TENANT_ID · Unique: UM_USER_ID, UM_ROLE_ID, UM_TENANT_ID

Column	Type	Notes
`UM_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_ROLE_ID`	`INTEGER`	FK → UM_ROLE · NOT NULL
`UM_USER_ID`	`INTEGER`	FK → UM_USER · NOT NULL
`UM_TENANT_ID`	`INTEGER`	PK · FK → UM_USER · DEFAULT 0

Foreign keys

UM_ROLE_ID, UM_TENANT_ID → UM_ROLE UM_ID, UM_TENANT_ID
UM_USER_ID, UM_TENANT_ID → UM_USER UM_ID, UM_TENANT_ID

UM_UUID_DOMAIN_MAPPER¶

Shared DB (WSO2SHARED_DB) · PK: UM_ID · Unique: UM_USER_ID

Column	Type	Notes
`UM_ID`	`INTEGER`	PK · NOT NULL AUTO_INCREMENT
`UM_USER_ID`	`VARCHAR(255)`	NOT NULL
`UM_DOMAIN_ID`	`INTEGER`	FK → UM_DOMAIN · NOT NULL
`UM_TENANT_ID`	`INTEGER`	FK → UM_DOMAIN · DEFAULT 0

Foreign keys

UM_DOMAIN_ID, UM_TENANT_ID → UM_DOMAIN UM_DOMAIN_ID, UM_TENANT_ID (on delete: CASCADE)