| Name | Type MSSql | Type Oracle | Type DB2 | Type Postgresql | Nullable | Description |
|---|---|---|---|---|---|---|
| MSG_Idnr | int | NUMBER(38,0) | int | int | false | MLS ID |
| MSG_MSGT_Type | char (1) | CHAR (1 CHAR) | char(1) | char (1) | false | primary key of the MSGT |
| MSG_OH_Idnr | int | NUMBER(38,0) | int | int | true | primary key of the object header |
| MSG_TicketNumber | varchar (200) | VARCHAR2 (200 CHAR) | varchar(200) | varchar (200) | true | MLS Ticket nummer |
| MSG_SpeakingId | varchar (200) | VARCHAR2 (200 CHAR) | varchar(200) | varchar (200) | true | MLS Speaker |
| MSG_CheckFlag | char (1) | CHAR (1 CHAR) | char(1) | char (1) | true | MLS entry should be check |
| Name | Fields | Primary | Unique | Clustered | Nonclustered |
|---|---|---|---|---|---|
| PK_MSG | MSG_Idnr | true | true | true | false |
| Name | Local References | Foreign References |
|---|---|---|
| FK_MSG_MSGT | MSG_MSGT_Type | MSGT_Type |
| FK_MSG_MSGA | MSG_OH_Idnr | MSGA_OH_Idnr |
Return to the Index File