====== 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 =====
* ID
===== Foreign Keys =====
* No outgoing foreign keys found.
===== Referenced By =====
* No incoming foreign keys found.
===== Indexes =====
^ Name ^ Type ^ Columns ^ Detail ^
| KMLEntered | Index | WhenEntered | |
===== Triggers =====
* No triggers found.
===== 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