Registry Related Tables

This section lists out all the registry related tables and their attributes in the WSO2 Identity Server database.

REG_CLUSTER_LOCK

If you are using Registry separation implementation and sharing configuration and governance registries among cluster nodes of any WSO2 product when a node is restarting, locks can be defined to avoid database schema creation and data population from multiple nodes for JDBC-base databases.These locks are defined in this table.

REG_LOCK_NAME
REG_LOCK_STATUS
REG_LOCKED_TIME
REG_TENANT_ID

REG_LOG

All registry activities are logged in this table. Details such as the registry resource path, the user who did the modification, the action performed, timestamp and tenant ID of the user are recorded in this table. Following are the columns in the table.

REG_LOG_ID
REG_PATH
REG_USER_ID
REG_LOGGED_TIME
REG_ACTION
REG_ACTION_DATA
REG_TENANT_ID

REG_PATH

The paths of all registry resources are stored in this table along with an ID for the registry path. From other tables when referring a resource path, this ID is used.

REG_PATH_ID
REG_PATH_VALUE
REG_PATH_PARENT_ID
REG_TENANT_ID

REG_CONTENT

Actual content of the registry resources are stored as binary objects in this table. Following are the columns of the table.

REG_CONTENT_ID
REG_CONTENT_DATA
REG_TENANT_ID

REG_CONTENT_HISTORY

History of the actual content of registry resource is maintained in this table. Following are the columns of the table.

REG_CONTENT_ID
REG_CONTENT_DATA
REG_DELETED
REG_TENANT_ID

REG_RESOURCE

The details about the registry resource are stored in this table. Following are the columns of the table.

REG_PATH_ID
REG_NAME
REG_VERSION
REG_MEDIA_TYPE
REG_CREATOR
REG_CREATED_TIME
REG_LAST_UPDATOR
REG_LAST_UPDATED_TIME
REG_DESCRIPTION
REG_CONTENT_ID
REG_TENANT_ID
REG_UUID

REG_RESOURCE_HISTORY

Upon modifying details of the registry resource (not the actual content), history for those details are maintained in this table. Following are the columns of the table.

REG_PATH_ID
REG_NAME
REG_VERSION
REG_MEDIA_TYPE
REG_CREATOR
REG_CREATED_TIME
REG_LAST_UPDATOR
REG_LAST_UPDATED_TIME
REG_DESCRIPTION
REG_CONTENT_ID
REG_DELETED
REG_TENANT_ID
REG_UUID

REG_COMMENT

The details of a comment added for a registry resource are stored in this table. Comments in this table are mapped with the records in REG_RESOURCE_COMMENT table. Following are the columns of the table.

REG_ID
REG_COMMENT_TEXT
REG_USER_ID
REG_COMMENTED_TIME
REG_TENANT_ID

REG_RESOURCE_COMMENT

For a registry resource, we can add multiple comments for describing the resource. Those comments are stored in this table along with the registry path ID. Following are the columns of the table.

REG_COMMENT_ID
REG_VERSION
REG_PATH_ID
REG_RESOURCE_NAME
REG_TENANT_ID

REG_RATING

Ratings for the registry resources are stored in this table. Following are the columns of the table.

REG_ID
REG_RATING
REG_USER_ID
REG_RATED_TIME
REG_TENANT_ID

REG_RESOURCE_RATING

The resources in the registry can be given a rating based on a scale 1-5. Actual rating value is stored in the table REG_RATING and records in this table acts as mappings to the records in REG_RATING.

REG_RATING_ID
REG_VERSION
REG_PATH_ID
REG_RESOURCE_NAME
REG_TENANT_ID

REG_TAG

Tags of a registry resource are stored in this table. Following are the columns of the table.

REG_ID
REG_TAG_NAME
REG_USER_ID
REG_TAGGED_TIME
REG_TENANT_ID

REG_RESOURCE_TAG

Registry resources can be tagged with a name. Actual tag name is stored in the REG_TAG table. This table is mapping records with the registry path and the records in REG_TAG. Following are the columns of the table.

REG_TAG_ID
REG_VERSION
REG_PATH_ID
REG_RESOURCE_NAME
REG_TENANT_ID

REG_PROPERTY

Properties for a registry resource are stored as key value pairs in this table. Following are the columns of the table.

REG_ID
REG_NAME
REG_VALUE
REG_TENANT_ID

REG_RESOURCE_PROPERTY

Properties can be added for a registry resource. Actual key value pairs of the properties are stored in REG_PROPERTY table. This table is providing the mapping for the records in REG_PROPERTY table with the resource registry path. Following are the columns of the table.

REG_PROPERTY_ID
REG_VERSION
REG_PATH_ID
REG_RESOURCE_NAME
REG_TENANT_ID

REG_ASSOCIATION

An association can be created from any resource (or collection) on the registry to another resource (or collection) on the registry or an external resource which can be referred to by a URL. While the source should be a resource existing on the registry, the destination resource can be anything for which a URL can be given. Association has a type associated.

eg: Document A that confirms to a standard B, You can create an association between those two by stating A "confirms to" B, where association name is "confirms to". The registry associations are stored in this table.

REG_ASSOCIATION_ID
REG_SOURCEPATH
REG_TARGETPATH
REG_ASSOCIATION_TYPE
REG_TENANT_ID

REG_SNAPSHOT

This table is used to create track of revisions that you create for a specific resource. Data will be populated upon creating a revision for a resource from the Registry Browser (Creating a checkpoint in the meta data section of a resource). Apart from that, versioning can be done per each change made for a resource which can be an extremely expensive operation at runtime (especially if there are many resources that change). By setting the <versionResourcesOnChange> parameter in <IS_HOME>/repository/conf/registry.xml to true/false, you can enable/disable versioning resources on change. If it is enabled, upon modification to a resource, a new version will be created from the resource and also a new record is added to this table. Following are the columns of the table.

REG_SNAPSHOT_ID
REG_PATH_ID
REG_RESOURCE_NAME
REG_RESOURCE_VIDS
REG_TENANT_ID