Where can I find schema information on the Identity Manager tables?
The database schema document is located in the IDM tools directory. For example:
..\CA\Identity Manager\IAM Suite\Identity Manager\tools\db\IM_R12.5_DB_schema_descriptions.doc
The schema represents both 12.5.x and 12.6.x Identity Manager versions and includes schema for the Object Store tables, Task persistence, Audit, etc.