pears.TSImage

Used in the processing of Timesheet Images

• TSImageID

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

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