pears.IQXNetSwitch
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Description
Contains a list of switches for IQXWeb as well as the values
Columns
| Column | Type | Null | Default | Comment |
|---|---|---|---|---|
| IQXNetSwitchID | char(50) | NOT NULL | ||
| Description | char(100) | NOT NULL | ||
| Value | integer | NULL | 0 | |
| TextValue | char(250) | NULL |
Primary Key
- IQXNetSwitchID
Foreign Keys
- No outgoing foreign keys found.
Referenced By
- No incoming foreign keys found.
Indexes
- No indexes found.
Triggers
- No triggers found.
Original SQL
-- IQX database structure split by table -- Source: IQXDatabaseStructure - with comments.sql -- Table: "pears"."IQXNetSwitch" -- Table comment: Contains a list of switches for IQXWeb as well as the values -- Statement count: 2 CREATE TABLE "pears"."IQXNetSwitch" ( "IQXNetSwitchID" CHAR(50) NOT NULL ,"Description" CHAR(100) NOT NULL ,"Value" INTEGER NULL DEFAULT 0 ,"TextValue" CHAR(250) NULL ,PRIMARY KEY ("IQXNetSwitchID" ASC) ) GO COMMENT ON TABLE "pears"."IQXNetSwitch" IS 'Contains a list of switches for IQXWeb as well as the values' GO