Table of Contents



pears.BatchTransfers

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Description

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

Columns

Column Type Null Default Comment
BatchType char(12) NOT NULL Include T if timesheets might be in batch
BatchNumber integer NOT NULL
TransferTime timestamp NOT NULL
Note long varchar NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Name Type Columns Detail
BatchTransfers_Number Index BatchNumber

Triggers

Original SQL

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