Table of Contents



pears.TSImage

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

Description

Used in the processing of Timesheet Images

Columns

Column Type Null Default Comment
TSImageID char(20) NOT NULL
CurrentLocation char(254) NULL = path and filename
TSInboxID char(20) NULL
TSQueryLogID char(20) NULL set on query creation, cleared on query resolution
DivisionID char(20) NULL
PersonID char(20) NULL
PayrollNumber char(15) NULL if filled and personid null ask before showing
AppNumber char(12) NULL if filled and personid null ask before showing
OrphanReason char(254) NULL
Locked bigint NULL = connectionid
SenderEmail char(254) NULL
EmailSubject char(254) NULL
Processed smallint NULL
WhenReceived timestamp NULL
WhenImported timestamp NULL current timestamp
Orientation smallint NULL
deleted smallint NULL
whentscompleted timestamp NULL
temptimesheetid char(20) NULL
ImageBlobID char(20) NULL
TempTimeDheetID char(20) NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
TSQueryLog TSQueryLogID pears.TSQueryLog (TSQueryLogID) ON DELETE SET NULL
division DivisionID pears.Division (divisionid) ON DELETE SET NULL
person PersonID pears.Person (personid) ON DELETE SET NULL

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."TSImage"
-- Table comment: Used in the processing of Timesheet Images
-- Statement count: 10
 
CREATE TABLE "pears"."TSImage" (
    "TSImageID"                      CHAR(20) NOT NULL
   ,"CurrentLocation"                CHAR(254) NULL
   ,"TSInboxID"                      CHAR(20) NULL
   ,"TSQueryLogID"                   CHAR(20) NULL
   ,"DivisionID"                     CHAR(20) NULL
   ,"PersonID"                       CHAR(20) NULL
   ,"PayrollNumber"                  CHAR(15) NULL
   ,"AppNumber"                      CHAR(12) NULL
   ,"OrphanReason"                   CHAR(254) NULL
   ,"Locked"                         BIGINT NULL
   ,"SenderEmail"                    CHAR(254) NULL
   ,"EmailSubject"                   CHAR(254) NULL
   ,"Processed"                      SMALLINT NULL
   ,"WhenReceived"                   TIMESTAMP NULL
   ,"WhenImported"                   TIMESTAMP NULL DEFAULT CURRENT TIMESTAMP
   ,"Orientation"                    SMALLINT NULL
   ,"deleted"                        SMALLINT NULL
   ,"whentscompleted"                TIMESTAMP NULL
   ,"temptimesheetid"                CHAR(20) NULL
   ,"ImageBlobID"                    CHAR(20) NULL
   ,"TempTimeDheetID"                CHAR(20) NULL
   ,PRIMARY KEY ("TSImageID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."TSImage"."CurrentLocation" IS 
	'= path and filename'
GO
 
 
COMMENT ON COLUMN "pears"."TSImage"."TSQueryLogID" IS 
	'set on query creation, cleared on query resolution'
GO
 
 
COMMENT ON COLUMN "pears"."TSImage"."PayrollNumber" IS 
	'if filled and personid null ask before showing'
GO
 
 
COMMENT ON COLUMN "pears"."TSImage"."AppNumber" IS 
	'if filled and personid null ask before showing'
GO
 
 
COMMENT ON COLUMN "pears"."TSImage"."Locked" IS 
	'= connectionid'
GO
 
 
COMMENT ON TABLE "pears"."TSImage" IS 
	'Used in the processing of Timesheet Images'
GO
 
 
ALTER TABLE "pears"."TSImage"
    ADD FOREIGN KEY "TSQueryLog" ("TSQueryLogID" ASC)
    REFERENCES "pears"."TSQueryLog" ("TSQueryLogID")
    ON DELETE SET NULL
GO
 
 
ALTER TABLE "pears"."TSImage"
    ADD FOREIGN KEY "division" ("DivisionID" ASC)
    REFERENCES "pears"."Division" ("divisionid")
    ON DELETE SET NULL
GO
 
 
ALTER TABLE "pears"."TSImage"
    ADD FOREIGN KEY "person" ("PersonID" ASC)
    REFERENCES "pears"."Person" ("personid")
    ON DELETE SET NULL
GO