Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
MSGA_OH_Idnr int NUMBER(38,0) int int false MLS (LOCA) OH Idnr
MSGA_MSGDT_Short char (1) CHAR (1 CHAR) char(1) char (1) false MLS type (N: Numeric)
MSGA_MSGKD_Short char (1) CHAR (1 CHAR) char(1) char (1) false MLS type (U: UC4, C: Custom)
MSGA_Text varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true MLS Message
MSGA_Resp varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true MLS Resp

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_MSGA MSGA_OH_Idnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_MSGA_MSGKD MSGA_MSGKD_Short MSGKD_Short
FK_MSGA_MSGDT MSGA_MSGDT_Short MSGDT_Short
FK_MSGA_OH MSGA_OH_Idnr OH_Idnr

Return to the Index File