| 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