Table of Contents



pears.AutoMatchGlobalConfig

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
AutoMatchGlobalConfigID char(20) NOT 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

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."AutoMatchGlobalConfig"
-- Table comment: For use by Auto-matching procedures
-- Statement count: 7
 
CREATE TABLE "pears"."AutoMatchGlobalConfig" (
    "AutoMatchGlobalConfigID"        CHAR(20) NOT 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
   ,PRIMARY KEY ("AutoMatchGlobalConfigID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchGlobalConfig"."ContactStart" IS 
	'Start Sending'
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchGlobalConfig"."ContactEnd" IS 
	'Stop Sending'
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchGlobalConfig"."MinDelayBetweenEmails" IS 
	'in mins'
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchGlobalConfig"."MinDelayBetweenSMS" IS 
	'in mins'
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchGlobalConfig"."MinDelayBetweenPush" IS 
	'in mins'
GO
 
 
COMMENT ON TABLE "pears"."AutoMatchGlobalConfig" IS 
	'For use by Auto-matching procedures'
GO