Name | Type MSSql | Type Oracle | Type DB2 | Nullable | Description |
---|---|---|---|---|---|
EV_AH_Idnr | int | NUMBER(38,0) | int | false | Reference to AH |
EV_VName | varchar (32) | VARCHAR2 (32 CHAR) | varchar(32) | false | Value Name |
EV_Value | varchar(max) | CLOB | clob(20480 k) INLINE LENGTH 30000 COMPACT | true | Value |
EV_Source | smallint | NUMBER(38,0) | smallint | true | Value's source (0 own, 1 parent, 2 modified during runtime) |
EV_SortOrder | smallint | NUMBER(38,0) | smallint | true | Sort order |
EV_ERTUsage | smallint | NUMBER(38,0) | smallint | true | Defines how this value is used in ERT calculation (0=No ERT usage, 1=Nominal, 2=Numeric, 3=Timestamp, 4=Date, 5=Time) |
Name | Fields | Primary | Unique | Clustered | Nonclustered |
---|---|---|---|---|---|
PK_EV | EV_AH_Idnr, EV_VName | true | true | true | false |
Name | Local References | Foreign References |
---|
Return to the Index File