Chris Snow
Chris Snow

Reputation: 24646

wso2 carbon database table definitions

I can see a bunch of scripts in the $CARBON_HOME/dbscripts folder, but would like some more information about the schema.

Is there any documentation that describes all the tables that are created by carbon?

Here are the tables used by Carbon 4.0.1. It looks like there are two major types of data being managed: Registry (REG_x) and User Management (UM_x).

REG_CLUSTER_LOCK
REG_LOG
REG_PATH
REG_CONTENT
REG_CONTENT_HISTORY
REG_RESOURCE
REG_RESOURCE_HISTORY
REG_COMMENT
REG_RESOURCE_COMMENT
REG_RATING
REG_RESOURCE_RATING
REG_TAG
REG_RESOURCE_TAG
REG_PROPERTY
REG_RESOURCE_PROPERTY
REG_ASSOCIATION
REG_SNAPSHOT

UM_TENANT
UM_USER
UM_USER_ATTRIBUTE
UM_ROLE
UM_PERMISSION
UM_ROLE_PERMISSION
UM_USER_PERMISSION
UM_USER_ROLE
UM_DIALECT
UM_CLAIM
UM_PROFILE_CONFIG
UM_CLAIM_BEHAVIOR
UM_HYBRID_ROLE
UM_HYBRID_USER_ROLE
UM_HYBRID_REMEMBER_ME

Upvotes: 0

Views: 851

Answers (2)

thariyarox
thariyarox

Reputation: 464

You can find the database table definitions of WSO2 Identity Server in [1]. Most of the tables are common to other products as well.

[1] http://tharindue.blogspot.com/2015/04/wso2-identity-server-data-dictionary.html

Upvotes: 2

Chris Snow
Chris Snow

Reputation: 24646

The closest answer I have found is here

I guess I will need to look through the DAO's and try and work out what is happening from there.

Upvotes: 0

Related Questions