Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
ACV_AH_Idnr int NUMBER(38,0) int int false Reference to AH
ACV_VName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) false Value name
ACV_Type smallint NUMBER(38,0) smallint smallint false Job Parameter
ACV_Encrypted smallint NUMBER(38,0) smallint smallint true Value Type (0=decrypted, 1=encrypted)
ACV_Connection smallint NUMBER(38,0) smallint smallint true 1 = Value represents the name of a Connection Object
ACV_Key varbinary(16) RAW(16) varchar(16) for bit data bytea true Key for encrypted Values
ACV_Value varchar(max) CLOB clob(20480 k) COMPACT text true Value
ACV_IsUtf8 smallint NUMBER(38,0) smallint smallint true Indicates if ACV_Value is stored in UTF-8 (1) or legacy encoding (0) if it is encrypted

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_ACV ACV_AH_Idnr, ACV_VName, ACV_Type true true true false

Foreign Keys:

Name Local References Foreign References
FK_ACV_AH ACV_AH_Idnr AH_Idnr

Return to the Index File