| 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 |
| Name | Fields | Primary | Unique | Clustered | Nonclustered |
|---|---|---|---|---|---|
| PK_MSGAN | MSGAN_OH_Idnr, MSGAN_Lnr | true | true | true | false |
| Name | Local References | Foreign References |
|---|---|---|
| FK_MSGAN_MSGA | MSGAN_OH_Idnr | MSGA_OH_Idnr |
Return to the Index File