Table of Contents



pears.deptmaintenance

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

Description

Records which staff members have manintenace rights in which department.

Columns

Column Type Null Default Comment
departmentid char(2) NOT NULL
staffid char(20) NOT NULL

Primary Key

Foreign Keys

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

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."deptmaintenance"
-- Table comment: Records which staff members have manintenace rights in which department.
-- Statement count: 4
 
CREATE TABLE "pears"."deptmaintenance" (
    "departmentid"                   CHAR(2) NOT NULL
   ,"staffid"                        CHAR(20) NOT NULL
   ,PRIMARY KEY ("departmentid" ASC,"staffid" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."deptmaintenance" IS 
	'Records which staff members have manintenace rights in which department.'
GO
 
 
ALTER TABLE "pears"."deptmaintenance"
    ADD NOT NULL FOREIGN KEY "department" ("departmentid" ASC)
    REFERENCES "pears"."Department" ("departmentid")
GO
 
 
ALTER TABLE "pears"."deptmaintenance"
    ADD NOT NULL FOREIGN KEY "staff" ("staffid" ASC)
    REFERENCES "pears"."staff" ("staffid")
GO