Name | Type MSSql | Type Oracle | Type DB2 | Nullable | Description |
---|---|---|---|---|---|
OPSEA_OH_Idnr | int | NUMBER(38,0) | int | false | Oh_idnr of the Prompt Set |
OPSEA_OPSE_Name | varchar (32) | VARCHAR2 (32 CHAR) | varchar(32) | false | Prompt Set Element Variable Name |
OPSEA_Lnr | int | NUMBER(38,0) | int | false | Ascending number |
OPSEA_Value | varchar(max) | CLOB | clob(20480 k) INLINE LENGTH 1024 COMPACT | true | Value = Caption on MULTI+Array (Checkbox, Checklist) |
Name | Fields | Primary | Unique | Clustered | Nonclustered |
---|---|---|---|---|---|
PK_OPSEA | OPSEA_OH_Idnr, OPSEA_OPSE_Name, OPSEA_Lnr | true | true | true | false |
Name | Local References | Foreign References |
---|---|---|
FK_OPSEA_OPSE | OPSEA_OH_Idnr, OPSEA_OPSE_Name | OPSE_OH_Idnr, OPSE_Name |
Return to the Index File