...
You can find several subfolders inside the <PRODUCT_HOME>/dbscripts folder. These contain several .sql files which are used to create the tables required by specific features. The scripts found in the apimgt folder are related to the Product API Store feature. The scripts found in the bps folder are related to the Business Processes and Human Tasks related to the Work List functionality. The scripts found in the service-provider folder are related to the Identity Provider feature and the scripts found in the identity folder are related to the other identity functionalities such as OAuth, SCIM, OpenID and STS.
...