Table of Contents



pears.AutoMatchPersonConfig

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

Description

For use by Auto-matching procedures

Columns

Column Type Null Default Comment
AutoMatchPersonConfigID char(20) NOT NULL
PersonID char(20) NULL
ContactStart time NULL Start Sending
ContactEnd time NULL Stop Sending
MaxEmails integer NULL 100
MaxSMS integer NULL 100
MaxPush integer NULL 100
MinDelayBetweenEmails integer NULL 30 in mins
MinDelayBetweenSMS integer NULL 30 in mins
MinDelayBetweenPush integer NULL 30 in mins
StopFromDate timestamp NULL Holiday etc. may not be needed
StopUntilDate timestamp NULL Holiday etc. may not be needed

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
person PersonID pears.Person (personid) ON DELETE CASCADE

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."AutoMatchPersonConfig"
-- Table comment: For use by Auto-matching procedures
-- Statement count: 10
 
CREATE TABLE "pears"."AutoMatchPersonConfig" (
    "AutoMatchPersonConfigID"        CHAR(20) NOT NULL
   ,"PersonID"                       CHAR(20) NULL
   ,"ContactStart"                   TIME NULL
   ,"ContactEnd"                     TIME NULL
   ,"MaxEmails"                      INTEGER NULL DEFAULT 100
   ,"MaxSMS"                         INTEGER NULL DEFAULT 100
   ,"MaxPush"                        INTEGER NULL DEFAULT 100
   ,"MinDelayBetweenEmails"          INTEGER NULL DEFAULT 30
   ,"MinDelayBetweenSMS"             INTEGER NULL DEFAULT 30
   ,"MinDelayBetweenPush"            INTEGER NULL DEFAULT 30
   ,"StopFromDate"                   TIMESTAMP NULL
   ,"StopUntilDate"                  TIMESTAMP NULL
   ,PRIMARY KEY ("AutoMatchPersonConfigID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchPersonConfig"."ContactStart" IS 
	'Start Sending'
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchPersonConfig"."ContactEnd" IS 
	'Stop Sending'
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchPersonConfig"."MinDelayBetweenEmails" IS 
	'in mins'
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchPersonConfig"."MinDelayBetweenSMS" IS 
	'in mins'
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchPersonConfig"."MinDelayBetweenPush" IS 
	'in mins'
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchPersonConfig"."StopFromDate" IS 
	'Holiday etc. may not be needed'
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchPersonConfig"."StopUntilDate" IS 
	'Holiday etc. may not be needed'
GO
 
 
COMMENT ON TABLE "pears"."AutoMatchPersonConfig" IS 
	'For use by Auto-matching procedures'
GO
 
 
ALTER TABLE "pears"."AutoMatchPersonConfig"
    ADD FOREIGN KEY "person" ("PersonID" ASC)
    REFERENCES "pears"."Person" ("personid")
    ON DELETE CASCADE
GO