Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
RT_AH_Idnr int NUMBER(38,0) int int false reference to RH/AH
RT_Type varchar (4) VARCHAR2 (4 CHAR) varchar(4) varchar (4) false report type (reference to type UC_RTYP)
RT_Lnr int NUMBER(38,0) int int false ascending number of the report text
RT_TimeStamp datetime DATE timestamp timestamp true timestamp
RT_MsgNr int NUMBER(38,0) int int false MSGNR if this is a logging record
RT_Content varchar(8000) CLOB varchar(8000) varchar(8000) true memostype text if MSGNR is not present
RT_MsgInsert varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true MSG_Insert if this is a logging record

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_RT RT_AH_Idnr, RT_Type, RT_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_RT_RH RT_AH_Idnr, RT_Type RH_AH_Idnr, RH_Type

Return to the Index File