Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
AFC_AH_Idnr int NUMBER(38,0) int int false Reference to the archive header (AH)
AFC_APPF_Lnr smallint NUMBER(38,0) smallint smallint false Number of the filter in APPF
AFC_Lnr smallint NUMBER(38,0) smallint smallint false Ascending number of the filter
AFC_SrcType char (1) CHAR (1 CHAR) char(1) char (1) true R=Report, F=File
AFC_Condition char (1) CHAR (1 CHAR) char(1) char (1) true C=contains, N=does not contain
AFC_SrcName varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true Reporttype or Filename
AFC_FilterText varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true FilterText

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_AFC AFC_AH_Idnr, AFC_APPF_Lnr, AFC_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_AFC_APPF AFC_AH_Idnr, AFC_APPF_Lnr APPF_AH_Idnr, APPF_Lnr

Return to the Index File