IQX Quick Menu

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

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

AutoMatchPersonConfigID

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

No incoming foreign keys found.

No indexes found.

No triggers found.

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

pears.AutoMatchPersonConfig

Description

Columns

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

Original SQL

iqx