| Name | Type MSSql | Type Oracle | Type DB2 | Type Postgresql | Nullable | Description |
|---|---|---|---|---|---|---|
| MSGTX_MSG_Idnr | int | NUMBER(38,0) | int | int | false | MLS ID nummer |
| MSGTX_MSGL_Short | varchar (3) | VARCHAR2 (3 CHAR) | varchar(3) | varchar (3) | false | MLS language |
| MSGTX_Text | varchar (1024) | VARCHAR2 (1024 CHAR) | varchar(1024) | varchar (1024) | true | MLS Text (short) |
| MSGTX_LText | varchar(max) | CLOB | clob(20480 k) INLINE LENGTH 1024 COMPACT | text | true | MLS Text (long) |
| MSGTX_OH_Idnr | int | NUMBER(38,0) | int | int | true | primary key of the object header |
| Name | Fields | Primary | Unique | Clustered | Nonclustered |
|---|---|---|---|---|---|
| PK_MSGTX | MSGTX_MSG_Idnr, MSGTX_MSGL_Short | true | true | true | false |
| Name | Local References | Foreign References |
|---|---|---|
| FK_MSGTX_MSG | MSGTX_MSG_Idnr | MSG_Idnr |
| FK_MSGTX_MSGL | MSGTX_MSGL_Short | MSGL_Short |
Return to the Index File