
Database Schema Reference
Table
Name | Index Null? Type | Description |
APPLICATIONID
COMPATIBILITYLEVEL
LIBRARYNAME
✔
✔
NOT | VARCHAR2(32) | Name of the installed application for this |
NULL |
| iIS plan. |
NOT | NUMBER(38) | Compatibility level of the installed |
NULL |
| library of this iIS plan. |
| VARCHAR2(64) | Name of the installed library for this iIS |
|
| plan. |
LOADOPTIONS
PROJECTNAME
REGISTRATIONNAME
TYPE
WUSAGE
CREATETIME
OBSOLETE
✔
✔
✔
| NUMBER(38) | Internal use only. |
| VARCHAR2(67) | Name of the generated TOOL project of |
|
| the compiled iIS plan. |
NOT | VARCHAR2(64) | Name of the source iIS plan from which |
NULL |
| the iIS component is derived. |
NOT | NUMBER(38) | Type of iIS plan: |
NULL |
| |
|
| |
|
| |
|
| |
|
| |
| NUMBER(38) | Internal use only. |
| DATE | Date and time of registration. |
NOT | NUMBER(38) | Internal use only. |
NULL |
|
|
History Log Tables
The following is an alphabetical list of all history log tables in the engine database. “State Values” on page 357 lists the possible values for the State field present in many of the history log tables.
For a description of each of these tables, refer to Table
Appendix B Engine Database Schema 347