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