Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
LIC_Lnr int NUMBER(38,0) int int false Unique Key
LIC_Platform varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false platform
LIC_Class char (1) CHAR (1 CHAR) char(1) char (1) false license class
LIC_Category varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false license category
LIC_Date datetime DATE timestamp timestamp true license date
LIC_Number int NUMBER(38,0) int int true number of licenses
LIC_Event char (1) CHAR (1 CHAR) char(1) char (1) true Y=with event
LIC_Volume1 int NUMBER(38,0) int int true license volume1 (processors, professional users)
LIC_Volume2 int NUMBER(38,0) int int true license volume2 (limited professional users)
LIC_Volume3 int NUMBER(38,0) int int true license volume3 (employee users)
LIC_Volume4 int NUMBER(38,0) int int true license volume4 (warehouse users)
LIC_Volume5 int NUMBER(38,0) int int true license volume5 (reserved)
LIC_Restriction varchar (250) VARCHAR2 (250 CHAR) varchar(250) varchar (250) true license restriction (e.g. 5 jobs/day)
LIC_EmergencyMode char (1) CHAR (1 CHAR) char(1) char (1) true Y=emergency mode allowed

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_LIC LIC_Lnr true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File