Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
DIVDB_PK int NUMBER(38,0) int int false primary key
DIVDB_Int1 smallint NUMBER(38,0) smallint smallint true byte value
DIVDB_Int2 smallint NUMBER(38,0) smallint smallint true integer value
DIVDB_Int4 int NUMBER(38,0) int int true long integer value
DIVDB_Memo varbinary(256) RAW(256) varchar(256) for bit data bytea true memo field
DIVDB_Date datetime DATE timestamp timestamp true date/time field
DIVDB_String varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true character field (length=255)
DIVDB_String2 varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true character field (length=255)
DIVDB_String3 varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true character field (length=255)
DIVDB_CLOB varchar(5000) CLOB varchar(5000) varchar(5000) true Long string
DIVDB_BLOB varbinary(max) BLOB blob(128 M) INLINE LENGTH 1024 COMPACT bytea true for binary
DIVDB_Int8 bigint NUMBER(38,0) bigint bigint true

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_DIVDB DIVDB_PK true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File