Table of Contents



pears.AutoMatchDivisionConfig

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
AutoMatchDivisionConfigID char(20) NOT NULL
DivisionID char(20) NULL
LeadTime integer NOT NULL in hours
EscalationDelay integer NOT NULL in mins
Email tinyint NULL ContactMethod
SMS tinyint NULL ContactMethod
Push tinyint NULL ContactMethod
QtyWorkers integer NULL
PercentNew integer NOT NULL 0 - 100
Urgency smallint NULL null means all

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
division DivisionID pears.Division (divisionid) ON DELETE CASCADE

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."AutoMatchDivisionConfig"
-- Table comment: For use by Auto-matching procedures
-- Statement count: 10
 
CREATE TABLE "pears"."AutoMatchDivisionConfig" (
    "AutoMatchDivisionConfigID"      CHAR(20) NOT NULL
   ,"DivisionID"                     CHAR(20) NULL
   ,"LeadTime"                       INTEGER NOT NULL
   ,"EscalationDelay"                INTEGER NOT NULL
   ,"Email"                          tinyint NULL
   ,"SMS"                            tinyint NULL
   ,"Push"                           tinyint NULL
   ,"QtyWorkers"                     INTEGER NULL
   ,"PercentNew"                     INTEGER NOT NULL
   ,"Urgency"                        SMALLINT NULL
   ,PRIMARY KEY ("AutoMatchDivisionConfigID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchDivisionConfig"."LeadTime" IS 
	'in hours'
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchDivisionConfig"."EscalationDelay" IS 
	'in mins'
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchDivisionConfig"."Email" IS 
	'ContactMethod'
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchDivisionConfig"."SMS" IS 
	'ContactMethod'
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchDivisionConfig"."Push" IS 
	'ContactMethod'
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchDivisionConfig"."PercentNew" IS 
	'0 - 100'
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchDivisionConfig"."Urgency" IS 
	'null means all'
GO
 
 
COMMENT ON TABLE "pears"."AutoMatchDivisionConfig" IS 
	'For use by Auto-matching procedures'
GO
 
 
ALTER TABLE "pears"."AutoMatchDivisionConfig"
    ADD FOREIGN KEY "division" ("DivisionID" ASC)
    REFERENCES "pears"."Division" ("divisionid")
    ON DELETE CASCADE
GO