pears.TempPriceList

Headers for available Price Lists.

• TempPriceListID

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."TempPriceList"
-- Table comment: Headers for available Price Lists.
-- Statement count: 5
 
CREATE TABLE "pears"."TempPriceList" (
    "TempPriceListID"                CHAR(20) NOT NULL
   ,"Description"                    CHAR(50) NOT NULL
   ,"PriceListCode"                  CHAR(20) NULL
   ,"DepartmentID"                   CHAR(2) NULL
   ,"SortOrder"                      SMALLINT NULL
   ,PRIMARY KEY ("TempPriceListID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."TempPriceList" IS 
	'Headers for available Price Lists.'
GO
 
 
ALTER TABLE "pears"."TempPriceList"
    ADD FOREIGN KEY "department" ("DepartmentID" ASC)
    REFERENCES "pears"."Department" ("departmentid")
    ON DELETE SET NULL
GO
 
 
CREATE INDEX "TempPriceList_Code" ON "pears"."TempPriceList"
    ( "PriceListCode","Description" )
GO
 
 
CREATE UNIQUE INDEX "TempPriceList_DeptCode" ON "pears"."TempPriceList"
    ( "DepartmentID","PriceListCode" )
GO