Table of Contents



pears.TimesheetCancelReason

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

Description

Lookup of user defined reasons why Timesheet cancelled

Columns

Column Type Null Default Comment
TimesheetCancelReasonID char(20) NOT NULL
Name char(100) NOT NULL
SortOrder smallint NULL
Defunct tinyint NULL 0

Primary Key

Foreign Keys

Referenced By

Table Constraint Columns Referenced columns
pears.TempTimeSheet TimesheetCancelReason TimesheetCancelReasonID TimesheetCancelReasonID
pears.TempTimeSheetCancellation TimesheetCancelReason TimesheetCancelReasonID TimesheetCancelReasonID

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."TimesheetCancelReason"
-- Table comment: Lookup of user defined reasons why Timesheet cancelled
-- Statement count: 2
 
CREATE TABLE "pears"."TimesheetCancelReason" (
    "TimesheetCancelReasonID"        CHAR(20) NOT NULL
   ,"Name"                           CHAR(100) NOT NULL
   ,"SortOrder"                      SMALLINT NULL
   ,"Defunct"                        tinyint NULL DEFAULT 0
   ,PRIMARY KEY ("TimesheetCancelReasonID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."TimesheetCancelReason" IS 
	'Lookup of user defined reasons why Timesheet cancelled'
GO