Table of Contents



pears.DashboardObject

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

Description

Objects which may appear on IQXWeb dashboard

Columns

Column Type Null Default Comment
DashboardObjectID char(20) NOT NULL
StaffID char(20) NULL
Type char(50) NOT NULL
Title char(250) NOT NULL
Descriptor long varchar NULL
Shared smallint NULL 0
AccessLevel smallint NULL 0
SortOrder smallint NULL 0

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
Staff StaffID pears.staff (staffid) ON DELETE CASCADE

Referenced By

Table Constraint Columns Referenced columns
pears.DashboardDisplayedObject DashboardObject DashboardObjectID DashboardObjectID

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."DashboardObject"
-- Table comment: Objects which may appear on IQXWeb dashboard
-- Statement count: 3
 
CREATE TABLE "pears"."DashboardObject" (
    "DashboardObjectID"              CHAR(20) NOT NULL
   ,"StaffID"                        CHAR(20) NULL
   ,"Type"                           CHAR(50) NOT NULL
   ,"Title"                          CHAR(250) NOT NULL
   ,"Descriptor"                     long VARCHAR NULL
   ,"Shared"                         SMALLINT NULL DEFAULT 0
   ,"AccessLevel"                    SMALLINT NULL DEFAULT 0
   ,"SortOrder"                      SMALLINT NULL DEFAULT 0
   ,PRIMARY KEY ("DashboardObjectID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."DashboardObject" IS 
	'Objects which may appear on IQXWeb dashboard'
GO
 
 
ALTER TABLE "pears"."DashboardObject"
    ADD FOREIGN KEY "Staff" ("StaffID" ASC)
    REFERENCES "pears"."staff" ("staffid")
    ON DELETE CASCADE
GO