Table of Contents



pears.WPKGlobalSwitchGroup

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

Description

Groups of Woodpecker Switches.

Columns

Column Type Null Default Comment
WPKGlobalSwitchGroupID char(20) NOT NULL
Name char(50) NOT NULL
Notes long varchar NULL
SortOrder smallint NULL

Primary Key

Foreign Keys

Referenced By

Table Constraint Columns Referenced columns
pears.WPKGlobalSwitch WPKGlobalSwitchGroup WPKGlobalSwitchGroupID WPKGlobalSwitchGroupID

Indexes

Name Type Columns Detail
SwitchGroupMaint Index SortOrder, Name

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."WPKGlobalSwitchGroup"
-- Table comment: Groups of Woodpecker Switches.
-- Statement count: 3
 
CREATE TABLE "pears"."WPKGlobalSwitchGroup" (
    "WPKGlobalSwitchGroupID"         CHAR(20) NOT NULL
   ,"Name"                           CHAR(50) NOT NULL
   ,"Notes"                          long VARCHAR NULL
   ,"SortOrder"                      SMALLINT NULL
   ,PRIMARY KEY ("WPKGlobalSwitchGroupID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."WPKGlobalSwitchGroup" IS 
	'Groups of Woodpecker Switches.'
GO
 
 
CREATE INDEX "SwitchGroupMaint" ON "pears"."WPKGlobalSwitchGroup"
    ( "SortOrder","Name" )
GO