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