Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OHAF_OH_Idnr int NUMBER(38,0) int int false ID of agent authorization object.
OHAF_Lnr int NUMBER(38,0) int int false Sequenced number for filter entries.
OHAF_Name varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the agent.
OHAF_HostAttrType varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Platform the agent runs on.
OHAF_Version varchar (12) VARCHAR2 (12 CHAR) varchar(12) varchar (12) true Version of the agent.
OHAF_HTYP_HW varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Hardware of the host.
OHAF_HTYP_SW varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Software of the host.
OHAF_HTYP_SWVers varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Version of the software.
OHAF_HostRoles varchar(256) VARCHAR2 (256 CHAR) varchar(256) varchar(256) true Role of the agent (from the ini file or directly taken from the agent object)
OHAF_TcpIpAddr varchar (64) VARCHAR2 (64 CHAR) varchar(64) varchar (64) true TCP/IP address
OHAF_LicCategory varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true License category
OHAF_ExcludeFlag smallint NUMBER(38,0) smallint smallint true Indicates whether to include or exclude this row.

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OHAF OHAF_OH_Idnr, OHAF_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_OHAF_OH OHAF_OH_Idnr OH_Idnr

Return to the Index File