| Name | Type MSSql | Type Oracle | Type DB2 | Type Postgresql | Nullable | Description |
|---|---|---|---|---|---|---|
| EV_AH_Idnr | int | NUMBER(38,0) | int | int | false | Reference to AH |
| EV_VName | varchar (32) | VARCHAR2 (32 CHAR) | varchar(32) | varchar (32) | false | Value Name |
| EV_Value | varchar(max) | CLOB | clob(20480 k) INLINE LENGTH 30000 COMPACT | text | true | Value |
| EV_Source | smallint | NUMBER(38,0) | smallint | smallint | true | Value's source (0 own, 1 parent, 2 modified during runtime) |
| EV_SortOrder | smallint | NUMBER(38,0) | smallint | smallint | true | Sort order |
| EV_ERTUsage | smallint | NUMBER(38,0) | smallint | 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