pears.BatchTransfers

Records of transfer jobs etc. Maintained by the individual processes.

• BatchType, BatchNumber

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."BatchTransfers"
-- Table comment: Records of transfer jobs etc. Maintained by the individual processes.
-- Statement count: 4
 
CREATE TABLE "pears"."BatchTransfers" (
    "BatchType"                      CHAR(12) NOT NULL
   ,"BatchNumber"                    INTEGER NOT NULL
   ,"TransferTime"                   TIMESTAMP NOT NULL
   ,"Note"                           long VARCHAR NULL
   ,PRIMARY KEY ("BatchType" ASC,"BatchNumber" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."BatchTransfers"."BatchType" IS 
	'Include T if timesheets might be in batch'
GO
 
 
COMMENT ON TABLE "pears"."BatchTransfers" IS 
	'Records of transfer jobs etc. Maintained by the individual processes.'
GO
 
 
CREATE INDEX "BatchTransfers_Number" ON "pears"."BatchTransfers"
    ( "BatchNumber" )
GO