pears.EmailStaffNotificationAddress

Used for more than a single instance of the above.

• ID

• No incoming foreign keys found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."EmailStaffNotificationAddress"
-- Table comment: Used for more than a single instance of the above.
-- Statement count: 5
 
CREATE TABLE "pears"."EmailStaffNotificationAddress" (
    "ID"                             CHAR(20) NOT NULL
   ,"Topic"                          CHAR(50) NOT NULL
   ,"EmailAddress"                   CHAR(250) NOT NULL
   ,"DepartmentID"                   CHAR(2) NULL
   ,"DivisionID"                     CHAR(20) NULL
   ,"Body"                           long VARCHAR NULL
   ,PRIMARY KEY ("ID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."EmailStaffNotificationAddress" IS 
	'Used for more than a single instance of the above.'
GO
 
 
ALTER TABLE "pears"."EmailStaffNotificationAddress"
    ADD FOREIGN KEY "department" ("DepartmentID" ASC)
    REFERENCES "pears"."Department" ("departmentid")
    ON DELETE SET NULL
GO
 
 
ALTER TABLE "pears"."EmailStaffNotificationAddress"
    ADD FOREIGN KEY "division" ("DivisionID" ASC)
    REFERENCES "pears"."Division" ("divisionid")
    ON DELETE SET NULL
GO
 
 
CREATE INDEX "EmailStaffNotifRecipTopic" ON "pears"."EmailStaffNotificationAddress"
    ( "Topic","DepartmentID","DivisionID","EmailAddress" )
GO