Table of Contents



pears.BroadbeanHybridLocation

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

Description

Broadbean Locations - Standard Broadbean List

Columns

Column Type Null Default Comment
Value integer NOT NULL
Parent integer NULL
Type char(30) NOT NULL
Name char(100) NOT NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Name Type Columns Detail
BroadBeanParent Index Parent

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."BroadbeanHybridLocation"
-- Table comment: Broadbean Locations - Standard Broadbean List 
-- Statement count: 3
 
CREATE TABLE "pears"."BroadbeanHybridLocation" (
    "Value"                          INTEGER NOT NULL
   ,"Parent"                         INTEGER NULL
   ,"Type"                           CHAR(30) NOT NULL
   ,"Name"                           CHAR(100) NOT NULL
   ,PRIMARY KEY ("Value" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."BroadbeanHybridLocation" IS 
	'Broadbean Locations - Standard Broadbean List '
GO
 
 
CREATE INDEX "BroadBeanParent" ON "pears"."BroadbeanHybridLocation"
    ( "Parent" )
GO