Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
MSGAN_OH_Idnr int NUMBER(38,0) int int false MLS primary key of the object header (OH)
MSGAN_Lnr int NUMBER(38,0) int int false MLS Lnr
MSGAN_From int NUMBER(38,0) int int true MLS from
MSGAN_To int NUMBER(38,0) int int true MLS to
MSGAN_Pattern varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true MLS Pattern

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_MSGAN MSGAN_OH_Idnr, MSGAN_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_MSGAN_MSGA MSGAN_OH_Idnr MSGA_OH_Idnr

Return to the Index File