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
- ConfigLogID
Foreign Keys
- No outgoing foreign keys found.
Referenced By
- No incoming foreign keys found.
Indexes
- No indexes found.
Triggers
- No triggers found.
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