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)

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OPSEA OPSEA_OH_Idnr, OPSEA_OPSE_Name, OPSEA_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_OPSEA_OPSE OPSEA_OH_Idnr, OPSEA_OPSE_Name OPSE_OH_Idnr, OPSE_Name

Return to the Index File