This site contains the documentation that is relevant to older WSO2 product versions and offerings.
For the latest WSO2 documentation, visit https://wso2.com/documentation/.

Data Dictionary

Owned by Former user (Deleted)
Last updated: Jan 06, 2016
1 min read
The database scripts for WSO2 Identity Server can be found in the <IS_HOME>/dbscripts directory. Currently, the following databases are supported and a seperate file is included in the dbscripts folder containing SQL commands for database and table creation for each type of database: 
  • IBM DB2
  • Oracle
  • Oracle RAC
  • MySQL
  • H2
  • Microsoft SQL Server
  • Informix
  • PostgreSQL
  • OpenEdge
The folder structure of the <IS_HOME>/dbscripts directory is outlined below. The generic database table creation scripts are directly located inside the dbscripts directory and the identity specific table creation scripts are located inside the <IS_HOME>/dbscripts/identity directory. The table creation database scripts related to identity related application management are located inside <IS_HOME>/dbscripts/identity/application-mgt directory.

 

dbscripts/
├── db2.sql
├── derby.sql
├── h2.sql
├── identity
│   ├── application-mgt
│   │   ├── db2.sql
│   │   ├── h2.sql
│   │   ├── informix.sql
│   │   ├── mssql.sql
│   │   ├── mysql.sql
│   │   ├── oracle_rac.sql
│   │   ├── oracle.sql
│   │   └── postgresql.sql
│   ├── db2.sql
│   ├── h2.sql
│   ├── informix.sql
│   ├── mssql.sql
│   ├── mysql.sql
│   ├── oracle_rac.sql
│   ├── oracle.sql
│   └── postgresql.sql
├── informix.sql
├── mssql.sql
├── mysql_cluster.sql
├── mysql.sql
├── openedge.sql
├── oracle_rac.sql
├── oracle.sql
└── postgresql.sql

The data tables in Identity Server can be categorized in to several groups. They are listed below with diagrams illustrating the relationships among the tables: