Table of Contents



pears.KMLBuffer

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

Columns

Column Type Null Default Comment
ID char(20) NOT NULL
WhenEntered timestamp NULL current timestamp
KML long varchar NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Name Type Columns Detail
KMLEntered Index WhenEntered

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."KMLBuffer"
-- Table comment: 
-- Statement count: 2
 
CREATE TABLE "pears"."KMLBuffer" (
    "ID"                             CHAR(20) NOT NULL
   ,"WhenEntered"                    TIMESTAMP NULL DEFAULT CURRENT TIMESTAMP
   ,"KML"                            long VARCHAR NULL
   ,PRIMARY KEY ("ID" ASC) 
)
GO
 
 
CREATE INDEX "KMLEntered" ON "pears"."KMLBuffer"
    ( "WhenEntered" )
GO