pears.AutoMatchGlobalConfig

For use by Auto-matching procedures

• AutoMatchGlobalConfigID

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- 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