pears.BroadbeanHybridLocation

Broadbean Locations - Standard Broadbean List

• Value

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No triggers found.

-- 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