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
- ReferenceMasterID
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
- No indexes found.
Triggers
- No triggers found.
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
127.0.0.1