Table of Contents



pears.AutoMatchNewTempWeightingConfig

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
AutoMatchNewTempWeightingConfigID char(20) NOT NULL
Criteria char(250) NOT NULL Text for maintenance
CriteriaName char(100) NOT NULL Fixed underlying name used to calculate
Weighting integer NOT NULL percentage - must total 100

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."AutoMatchNewTempWeightingConfig"
-- Table comment: For use by Auto-matching procedures
-- Statement count: 5
 
CREATE TABLE "pears"."AutoMatchNewTempWeightingConfig" (
    "AutoMatchNewTempWeightingConfigID" CHAR(20) NOT NULL
   ,"Criteria"                       CHAR(250) NOT NULL
   ,"CriteriaName"                   CHAR(100) NOT NULL
   ,"Weighting"                      INTEGER NOT NULL
   ,PRIMARY KEY ("AutoMatchNewTempWeightingConfigID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchNewTempWeightingConfig"."Criteria" IS 
	'Text for maintenance'
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchNewTempWeightingConfig"."CriteriaName" IS 
	'Fixed underlying name used to calculate'
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchNewTempWeightingConfig"."Weighting" IS 
	'percentage - must total 100'
GO
 
 
COMMENT ON TABLE "pears"."AutoMatchNewTempWeightingConfig" IS 
	'For use by Auto-matching procedures'
GO