Table of Contents



pears.ReferenceMaster

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

Description

Template for online referencing.

Columns

Column Type Null Default Comment
ReferenceMasterID char(20) NOT NULL
DepartmentID char(2) NOT NULL
ReferenceMasterName char(100) NOT NULL
sortorder smallint NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
department DepartmentID pears.Department (departmentid) NOT NULL;

Referenced By

Table Constraint Columns Referenced columns
pears.DeletedReferenceMasterQuestion ReferenceMaster ReferenceMasterID ReferenceMasterID
pears.ReferenceMasterQuestion ReferenceMaster ReferenceMasterID ReferenceMasterID
pears.ReferenceRequest ReferenceMaster ReferenceMasterID ReferenceMasterID

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."ReferenceMaster"
-- Table comment: Template for online referencing.
-- Statement count: 3
 
CREATE TABLE "pears"."ReferenceMaster" (
    "ReferenceMasterID"              CHAR(20) NOT NULL
   ,"DepartmentID"                   CHAR(2) NOT NULL
   ,"ReferenceMasterName"            CHAR(100) NOT NULL
   ,"sortorder"                      SMALLINT NULL
   ,PRIMARY KEY ("ReferenceMasterID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."ReferenceMaster" IS 
	'Template for online referencing.'
GO
 
 
ALTER TABLE "pears"."ReferenceMaster"
    ADD NOT NULL FOREIGN KEY "department" ("DepartmentID" ASC)
    REFERENCES "pears"."Department" ("departmentid")
GO