Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
AWS_AH_Idnr int NUMBER(38,0) int int false reference to the archive header (AH)
AWS_Lnr int NUMBER(38,0) int int false Ascending Number
AWS_State int NUMBER(38,0) int int true Waiting_State
AWS_StartTime datetime DATE timestamp timestamp true When did Task get Waiting-State
AWS_EndTime datetime DATE timestamp timestamp true When did Task exit Waiting-State
AWS_CauseClient smallint NUMBER(38,0) smallint smallint true Client of CauseObject
AWS_CauseName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of CauseObject
AWS_MsgNr int NUMBER(38,0) int int true Info Message Number
AWS_MsgInsert varchar(1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar(1024) true Info Message Inserts

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_AWS AWS_AH_Idnr, AWS_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_AWS_AH AWS_AH_Idnr AH_Idnr

Return to the Index File