pears.IQXNetBulletinDivision

Junction table that restricts a bulletin to specific divisions. If no rows exist for a bulletin it is shown across all divisions. Multiple rows can be inserted to target several divisions simultaneously.

• IQXNetBulletinDivisionID

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQXNetBulletinDivision"
-- Table comment: Junction table that restricts a bulletin to specific divisions. If no rows exist for a bulletin it is shown across all divisions. Multiple rows can be inserted to target several divisions simultaneously.
-- Statement count: 6
 
CREATE TABLE "pears"."IQXNetBulletinDivision" (
    "IQXNetBulletinDivisionID"       CHAR(20) NOT NULL
   ,"IQXNetBulletinID"               CHAR(20) NULL
   ,"DivisionID"                     CHAR(20) NULL
   ,PRIMARY KEY ("IQXNetBulletinDivisionID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetBulletinDivision"."IQXNetBulletinID" IS 
	'FK → IQXNetBulletin'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetBulletinDivision"."DivisionID" IS 
	'FK → Division — limits bulletin visibility to this division'
GO
 
 
COMMENT ON TABLE "pears"."IQXNetBulletinDivision" IS 
	'Junction table that restricts a bulletin to specific divisions. If no rows exist for a bulletin it is shown across all divisions. Multiple rows can be inserted to target several divisions simultaneously.'
GO
 
 
ALTER TABLE "pears"."IQXNetBulletinDivision"
    ADD FOREIGN KEY "IQXNetBulletin" ("IQXNetBulletinID" ASC)
    REFERENCES "pears"."IQXNetBulletin" ("IQXNetBulletinID")
    ON DELETE CASCADE
GO
 
 
ALTER TABLE "pears"."IQXNetBulletinDivision"
    ADD FOREIGN KEY "Division" ("DivisionID" ASC)
    REFERENCES "pears"."Division" ("divisionid")
    ON DELETE CASCADE
GO