Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OPSEA_OH_Idnr int NUMBER(38,0) int int false ID of the prompt set.
OPSEA_OPSE_Name varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Variable name of the prompt set element.
OPSEA_Lnr int NUMBER(38,0) int int false Sequenced number for the prompt set array elements.
OPSEA_Value varchar(max) CLOB clob(20480 k) INLINE LENGTH 1024 COMPACT text true Value of the prompt set array element.

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