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
The database scripts for WSO2 Identity Server can be found in the <IS_HOME>/dbscripts directory. Currently, the following databases are supported and a separate 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.
dbscripts
├── bps
│ └── bpel
│ ├── create
│ │ ├── db2.sql
│ │ ├── derby.sql
│ │ ├── h2.sql
│ │ ├── mssql.sql
│ │ ├── mysql.sql
│ │ ├── oracle.sql
│ │ └── postgresql.sql
│ ├── drop
│ │ ├── h2-drop.sql
│ │ ├── mssql-drop.sql
│ │ ├── mysql-drop.sql
│ │ ├── oracle-drop.sql
│ │ └── postgresql-drop.sql
│ └── truncate
│ ├── db2-truncate.sql
│ ├── h2-truncate.sql
│ ├── mssql-truncate.sql
│ ├── mysql-truncate.sql
│ ├── oracle-truncate.sql
│ └── postgresql-truncate.sql
├── db2.sql
├── h2.sql
├── identity
│ ├── db2.sql
│ ├── h2.sql
│ ├── informix.sql
│ ├── mssql.sql
│ ├── mysql-5.7.sql
│ ├── mysql.sql
│ ├── oracle_rac.sql
│ ├── oracle.sql
│ └── postgresql.sql
├── informix.sql
├── metrics
│ ├── h2.sql
│ ├── mssql.sql
│ ├── mysql.sql
│ ├── oracle.sql
│ └── postgresql.sql
├── mssql.sql
├── mysql5.7.sql
├── mysql_cluster.sql
├── mysql.sql
├── oracle_rac.sql
├── oracle.sql
└── postgresql.sql
The data tables in Identity Server can be categorized into several groups. They are listed below with diagrams illustrating the relationships among the tables: