pears.IQXNetBulletin

Bulletin/announcement messages shown to candidates or clients in iqxWEB. Bulletins can be time-limited via an expiry date, targeted to candidates, clients, or both, and scoped to specific divisions via “IQXNetBulletinDivision”. If no division rows exist for a bulletin it is shown to all divisions. Archived bulletins are hidden without being deleted.

• IQXNetBulletinID

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQXNetBulletin"
-- Table comment: Bulletin/announcement messages shown to candidates or clients in iqxWEB. Bulletins can be time-limited via an expiry date, targeted to candidates, clients, or both, and scoped to specific divisions via "IQXNetBulletinDivision". If no division rows exist for a bulletin it is shown to all divisions. Archived bulletins are hidden without being deleted.
-- Statement count: 10
 
CREATE TABLE "pears"."IQXNetBulletin" (
    "IQXNetBulletinID"               CHAR(20) NOT NULL
   ,"HTMLBody"                       long VARCHAR NULL
   ,"WhenCreated"                    TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP
   ,"WhoCreated"                     CHAR(20) NOT NULL
   ,"SendToCandidate"                tinyint NULL
   ,"SendToClient"                   tinyint NULL
   ,"Expiry"                         DATE NULL
   ,"HTMLTitle"                      CHAR(250) NULL
   ,"Archived"                       TIMESTAMP NULL
   ,PRIMARY KEY ("IQXNetBulletinID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetBulletin"."IQXNetBulletinID" IS 
	'PK'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetBulletin"."HTMLBody" IS 
	'Body content of the bulletin (HTML)'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetBulletin"."SendToCandidate" IS 
	'1 = visible to candidates'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetBulletin"."SendToClient" IS 
	'1 = visible to clients'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetBulletin"."Expiry" IS 
	'Date after which the bulletin no longer shows. NULL = never expires'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetBulletin"."HTMLTitle" IS 
	'Title of the bulletin (HTML)'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetBulletin"."Archived" IS 
	'NULL = active; set to a value to archive/hide it'
GO
 
 
COMMENT ON TABLE "pears"."IQXNetBulletin" IS 
	'Bulletin/announcement messages shown to candidates or clients in iqxWEB. Bulletins can be time-limited via an expiry date, targeted to candidates, clients, or both, and scoped to specific divisions via "IQXNetBulletinDivision". If no division rows exist for a bulletin it is shown to all divisions. Archived bulletins are hidden without being deleted.'
GO
 
 
ALTER TABLE "pears"."IQXNetBulletin"
    ADD NOT NULL FOREIGN KEY "Staff" ("WhoCreated" ASC)
    REFERENCES "pears"."staff" ("staffid")
    ON DELETE CASCADE
GO