pears.TSImage [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== pears.TSImage ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== 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 =====
  * TSImageID

===== Foreign Keys =====
^ Constraint ^ Columns ^ References ^ Delete/update action ^
| TSQueryLog | TSQueryLogID | [[database:tables:pears_tsquerylog|pears.TSQueryLog (TSQueryLogID)]] | ON DELETE SET NULL |
| division | DivisionID | [[database:tables:pears_division|pears.Division (divisionid)]] | ON DELETE SET NULL |
| person | PersonID | [[database:tables:pears_person|pears.Person (personid)]] | ON DELETE SET NULL |

===== Referenced By =====
  * No incoming foreign keys found.

===== Indexes =====
  * No indexes found.

===== Triggers =====
  * No triggers found.

===== Original SQL =====
<code 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
</code>