Table of Contents



pears.AuditTrail

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Description

Contains audit records inserted by system and by audit triggers.

Columns

Column Type Null Default Comment
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

Foreign Keys

Referenced By

Indexes

Name Type Columns Detail
AuditTrailTypeDate Index AuditType, EventDateTime
AuditTrailTypeStaffDate Index AuditType, UserID, EventDateTime
AuditTrailTypeRecordID Index AuditType, RecordID
AuditTrailEventDateTime Index EventDateTime
AuditTrailUserIDDate Index UserID, EventDateTime

Triggers

Original SQL

-- 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