Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
TERM_Id bigint NUMBER(38,0) bigint bigint false
TERM_Shortname varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true
TERM_Glossary int NUMBER(38,0) int int true
TERM_Deprecated int NUMBER(38,0) int int true
TERM_DeprecatedVer varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true
TERM_Notes varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true
TERM_Version varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true
TERM_ReplacedBy bigint NUMBER(38,0) bigint bigint true
TERM_CrDate datetime DATE timestamp timestamp true
TERM_CrUser varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true
TERM_ModDate datetime DATE timestamp timestamp true
TERM_ModUser varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true
TERM_HtmFile varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_TERM TERM_Id true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File