/
Data Dictionary

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

Jan 06, 2016

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: