pears.AuditTrail

Contains audit records inserted by system and by audit triggers.

• AuditTrailID

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."AuditTrail"
-- Table comment: Contains audit records inserted by system and by audit triggers.
-- Statement count: 7
 
CREATE TABLE "pears"."AuditTrail" (
    "AuditTrailID"                   CHAR(20) NOT NULL
   ,"EventDateTime"                  TIMESTAMP NOT NULL
   ,"UserID"                         CHAR(25) NOT NULL
   ,"AuditType"                      CHAR(10) NOT NULL
   ,"RecordID"                       CHAR(20) NULL
   ,"Description"                    long VARCHAR NULL
   ,"OldValues"                      long VARCHAR NULL
   ,"NewValues"                      long VARCHAR NULL
   ,"ConnectionNumber"               INTEGER NULL
   ,PRIMARY KEY ("AuditTrailID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."AuditTrail" IS 
	'Contains audit records inserted by system and by audit triggers.'
GO
 
 
CREATE INDEX "AuditTrailTypeDate" ON "pears"."AuditTrail"
    ( "AuditType","EventDateTime" DESC )
GO
 
 
CREATE INDEX "AuditTrailTypeStaffDate" ON "pears"."AuditTrail"
    ( "AuditType","UserID","EventDateTime" DESC )
GO
 
 
CREATE INDEX "AuditTrailTypeRecordID" ON "pears"."AuditTrail"
    ( "AuditType","RecordID" )
GO
 
 
CREATE INDEX "AuditTrailEventDateTime" ON "pears"."AuditTrail"
    ( "EventDateTime" DESC )
GO
 
 
CREATE INDEX "AuditTrailUserIDDate" ON "pears"."AuditTrail"
    ( "UserID","EventDateTime" DESC )
GO