Name | Type MSSql | Type Oracle | Type DB2 | Type Postgresql | Nullable | Description |
---|---|---|---|---|---|---|
HTYP_SW | varchar (32) | VARCHAR2 (32 CHAR) | varchar(32) | varchar (32) | false | software |
HTYP_SWVers | varchar (32) | VARCHAR2 (32 CHAR) | varchar(32) | varchar (32) | false | version |
HTYP_HW | varchar (32) | VARCHAR2 (32 CHAR) | varchar(32) | varchar (32) | false | hardware |
HTYP_Text | varchar (81) | VARCHAR2 (81 CHAR) | varchar(81) | varchar (81) | true | description |
HTYP_HostAttrType | varchar (8) | VARCHAR2 (8 CHAR) | varchar(8) | varchar (8) | true | "BS2000", "UNIX", "WINDOWS"... for editing |
HTYP_LicenseType | varchar (32) | VARCHAR2 (32 CHAR) | varchar(32) | varchar (32) | true | license type |
HTYP_LicenseClass | char (1) | CHAR (1 CHAR) | char(1) | char (1) | true | licence class (minimum) |
HTYP_SystemId | char (3) | CHAR (3 CHAR) | char(3) | char (3) | true | system id for Exekutor |
HTYP_PCount | int | NUMBER(38,0) | int | int | false | this license class is valid for up to HTYP_PCount processors |
HTYP_LoginMask | varchar (32) | VARCHAR2 (32 CHAR) | varchar(32) | varchar (32) | true | login description mask |
Name | Fields | Primary | Unique | Clustered | Nonclustered |
---|---|---|---|---|---|
PK_HTYP | HTYP_SW, HTYP_SWVers, HTYP_HW, HTYP_PCount | true | true | true | false |
NK_HTYP_HostAttrType | HTYP_HostAttrType | false | false | false | false |
Name | Local References | Foreign References |
---|
Return to the Index File