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. |
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