Table of Contents



pears.ConfigLog

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

Description

Manually recorded changes to configuration.

Columns

Column Type Null Default Comment
ConfigLogID char(20) NOT NULL
Userid char(25) NULL
Description long varchar NULL
WhenEntered timestamp NULL current timestamp

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."ConfigLog"
-- Table comment: Manually recorded changes to configuration.
-- Statement count: 2
 
CREATE TABLE "pears"."ConfigLog" (
    "ConfigLogID"                    CHAR(20) NOT NULL
   ,"Userid"                         CHAR(25) NULL
   ,"Description"                    long VARCHAR NULL
   ,"WhenEntered"                    TIMESTAMP NULL DEFAULT CURRENT TIMESTAMP
   ,PRIMARY KEY ("ConfigLogID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."ConfigLog" IS 
	'Manually recorded changes to configuration.'
GO