Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
VERSI_Major int NUMBER(38,0) int int false major version number
VERSI_Minor int NUMBER(38,0) int int false minor version number
VERSI_DateRel datetime DATE timestamp timestamp false release date
VERSI_DateImpl datetime DATE timestamp timestamp false date of operation
VERSI_DBVersion varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true DB version number (e.g. 1.00C)
VERSI_V24_3 smallint NUMBER(38,0) smallint smallint true name = actual version - has to be the LAST field !!!

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_VERSI VERSI_Major, VERSI_Minor true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File