pears.IQXNetBulletin [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== pears.IQXNetBulletin ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Description =====
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.

===== Columns =====
^ Column ^ Type ^ Null ^ Default ^ Comment ^
| **IQXNetBulletinID** | char(20) | NOT NULL |  | PK |
| HTMLBody | long varchar | NULL |  | Body content of the bulletin (HTML) |
| WhenCreated | timestamp | NOT NULL | current timestamp |  |
| WhoCreated | char(20) | NOT NULL |  |  |
| SendToCandidate | tinyint | NULL |  | 1 = visible to candidates |
| SendToClient | tinyint | NULL |  | 1 = visible to clients |
| Expiry | date | NULL |  | Date after which the bulletin no longer shows. NULL = never expires |
| HTMLTitle | char(250) | NULL |  | Title of the bulletin (HTML) |
| Archived | timestamp | NULL |  | NULL = active; set to a value to archive/hide it |

===== Primary Key =====
  * IQXNetBulletinID

===== Foreign Keys =====
^ Constraint ^ Columns ^ References ^ Delete/update action ^
| Staff | WhoCreated | [[database:tables:pears_staff|pears.staff (staffid)]] | NOT NULL; ON DELETE CASCADE |

===== Referenced By =====
^ Table ^ Constraint ^ Columns ^ Referenced columns ^
| [[database:tables:pears_iqxnetbulletindivision|pears.IQXNetBulletinDivision]] | IQXNetBulletin | IQXNetBulletinID | IQXNetBulletinID |

===== Indexes =====
  * No indexes found.

===== Triggers =====
  * No triggers found.

===== Original SQL =====
<code sql>
-- 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
</code>