pears.PDFExtraDocument

Additional Documents for scanned timesheets

• PDFExtraDocumentID

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

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