Table of Contents



pears.mailerselection

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

Description

Mailchimp 'LISTS'

Columns

Column Type Null Default Comment
MailerSelectionID char(20) NOT NULL
Type char(1) NULL
Description char(100) NULL
StaffID char(20) NULL
ListID char(60) NULL
Subject char(60) NULL
FromName char(60) NULL
ReplyEmail char(60) NULL
MailerAction char(1) NULL
DateCreated date NULL
DateChanged date NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
staff StaffID pears.staff (staffid) ON DELETE CASCADE

Referenced By

Table Constraint Columns Referenced columns
pears.mailerselectionmember mailerselection MailerSelectionID MailerSelectionID

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."mailerselection"
-- Table comment: Mailchimp 'LISTS'
-- Statement count: 3
 
CREATE TABLE "pears"."mailerselection" (
    "MailerSelectionID"              CHAR(20) NOT NULL
   ,"Type"                           CHAR(1) NULL
   ,"Description"                    CHAR(100) NULL
   ,"StaffID"                        CHAR(20) NULL
   ,"ListID"                         CHAR(60) NULL
   ,"Subject"                        CHAR(60) NULL
   ,"FromName"                       CHAR(60) NULL
   ,"ReplyEmail"                     CHAR(60) NULL
   ,"MailerAction"                   CHAR(1) NULL
   ,"DateCreated"                    DATE NULL
   ,"DateChanged"                    DATE NULL
   ,PRIMARY KEY ("MailerSelectionID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."mailerselection" IS 
	'Mailchimp ''LISTS'''
GO
 
 
ALTER TABLE "pears"."mailerselection"
    ADD FOREIGN KEY "staff" ("StaffID" ASC)
    REFERENCES "pears"."staff" ("staffid")
    ON DELETE CASCADE
GO