Table of Contents



pears.PDFExtraDocument

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

Description

Additional Documents for scanned timesheets

Columns

Column Type Null Default Comment
PDFExtraDocumentID char(20) NOT NULL
TempTimesheetID char(20) NULL
FileNamePath char(250) NULL
FileType char(1) NOT NULL
WasUsed smallint NOT NULL 0
TempProvTimesheetID char(20) NULL
PDFImageBlobID char(20) NULL
FileHash char(40) NULL
DoNotAddtoInvoice smallint NULL 0
timesheetlineid char(20) NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
TempTimesheet TempTimesheetID pears.TempTimeSheet (TempTimeSheetID) ON DELETE CASCADE
TempProvTimesheet TempProvTimesheetID pears.TempProvTimeSheet (TempProvTimeSheetID) ON DELETE SET NULL

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."PDFExtraDocument"
-- Table comment: Additional Documents for scanned timesheets
-- Statement count: 4
 
CREATE TABLE "pears"."PDFExtraDocument" (
    "PDFExtraDocumentID"             CHAR(20) NOT NULL
   ,"TempTimesheetID"                CHAR(20) NULL
   ,"FileNamePath"                   CHAR(250) NULL
   ,"FileType"                       CHAR(1) NOT NULL
   ,"WasUsed"                        SMALLINT NOT NULL DEFAULT 0
   ,"TempProvTimesheetID"            CHAR(20) NULL
   ,"PDFImageBlobID"                 CHAR(20) NULL
   ,"FileHash"                       CHAR(40) NULL
   ,"DoNotAddtoInvoice"              SMALLINT NULL DEFAULT 0
   ,"timesheetlineid"                CHAR(20) NULL
   ,PRIMARY KEY ("PDFExtraDocumentID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."PDFExtraDocument" IS 
	'Additional Documents for scanned timesheets'
GO
 
 
ALTER TABLE "pears"."PDFExtraDocument"
    ADD FOREIGN KEY "TempTimesheet" ("TempTimesheetID" ASC)
    REFERENCES "pears"."TempTimeSheet" ("TempTimeSheetID")
    ON DELETE CASCADE
GO
 
 
ALTER TABLE "pears"."PDFExtraDocument"
    ADD FOREIGN KEY "TempProvTimesheet" ("TempProvTimesheetID" ASC)
    REFERENCES "pears"."TempProvTimeSheet" ("TempProvTimeSheetID")
    ON DELETE SET NULL
GO