Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OHAA_OH_Idnr int NUMBER(38,0) int int false ID of the agent authorization object.
OHAA_Client smallint NUMBER(38,0) smallint smallint false Client for which this authorizations are for.
OHAA_Use smallint NUMBER(38,0) smallint smallint true Has authorization to use.
OHAA_Read smallint NUMBER(38,0) smallint smallint true Has authorization to read.
OHAA_Write smallint NUMBER(38,0) smallint smallint true Has authorization to write.
OHAA_Execute smallint NUMBER(38,0) smallint smallint true Has authorization to execute.

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OHAA OHAA_OH_Idnr, OHAA_Client true true true false

Foreign Keys:

Name Local References Foreign References
FK_OHAA_OH OHAA_OH_Idnr OH_Idnr

Return to the Index File