Table of Contents



pears.TimesheetApprovalLink

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

Columns

Column Type Null Default Comment
TimesheetApprovalLinkID char(20) NOT NULL
tempprovtimesheetid char(20) NULL
URLRequestCode char(255) NOT NULL
EmailAddress long varchar NULL
WhenCreated timestamp NOT NULL current timestamp
WhenSent timestamp NULL
WhenCompleted timestamp NULL
SignOnDevice tinyint NOT NULL 0
EmailRequested tinyint NOT NULL 0
EmailSent timestamp NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
TempProvTimeSheet tempprovtimesheetid pears.TempProvTimeSheet (TempProvTimeSheetID) ON DELETE SET NULL

Referenced By

Table Constraint Columns Referenced columns
pears.TimesheetSignature TimesheetApprovalLink TimesheetApprovalLinkID TimesheetApprovalLinkID

Indexes

Name Type Columns Detail
URLRequestCodeProvID Index tempprovtimesheetid, URLRequestCode

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."TimesheetApprovalLink"
-- Table comment: 
-- Statement count: 3
 
CREATE TABLE "pears"."TimesheetApprovalLink" (
    "TimesheetApprovalLinkID"        CHAR(20) NOT NULL
   ,"tempprovtimesheetid"            CHAR(20) NULL
   ,"URLRequestCode"                 CHAR(255) NOT NULL
   ,"EmailAddress"                   long VARCHAR NULL
   ,"WhenCreated"                    TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP
   ,"WhenSent"                       TIMESTAMP NULL
   ,"WhenCompleted"                  TIMESTAMP NULL
   ,"SignOnDevice"                   tinyint NOT NULL DEFAULT 0
   ,"EmailRequested"                 tinyint NOT NULL DEFAULT 0
   ,"EmailSent"                      TIMESTAMP NULL
   ,PRIMARY KEY ("TimesheetApprovalLinkID" ASC) 
)
GO
 
 
ALTER TABLE "pears"."TimesheetApprovalLink"
    ADD FOREIGN KEY "TempProvTimeSheet" ("tempprovtimesheetid" ASC)
    REFERENCES "pears"."TempProvTimeSheet" ("TempProvTimeSheetID")
    ON DELETE SET NULL
GO
 
 
CREATE INDEX "URLRequestCodeProvID" ON "pears"."TimesheetApprovalLink"
    ( "tempprovtimesheetid","URLRequestCode" )
GO