| 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 |
| Name | Fields | Primary | Unique | Clustered | Nonclustered |
|---|---|---|---|---|---|
| PK_MSGA | MSGA_OH_Idnr | true | true | true | false |
| 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