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: Nov 16, 2017 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 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: