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: Mar 22, 2018 by Former user (Deleted)
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. 

Note: Some of the dbscripts in this directory are named with the relevant version number (e.g., "mysql5.7.sql"). Use the relevant scripts accordingly if you are using that version of the database. If there is a set of dbscripts without a specific mysql version indicated, that script is valid for all database versions. 

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
├── consent
│   ├── db2.sql
│   ├── h2.sql
│   ├── informix.sql
│   ├── mssql.sql
│   ├── mysql-5.7.sql
│   ├── mysql.sql
│   ├── oracle_rac.sql
│   ├── oracle.sql
│   └── postgresql.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 in to several groups. They are listed below with diagrams illustrating the relationships among the tables: