Table of Contents



pears.WithHoldReason

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
ReasonID char(20) NOT NULL
Description char(200) NULL
SortOrder smallint NULL
Type char(1) NULL C - Client, A - Agency, T - Candidate

Primary Key

Foreign Keys

Referenced By

Table Constraint Columns Referenced columns
pears.WithHolds WithHoldReason ReasonID ReasonID

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."WithHoldReason"
-- Table comment: 
-- Statement count: 2
 
CREATE TABLE "pears"."WithHoldReason" (
    "ReasonID"                       CHAR(20) NOT NULL
   ,"Description"                    CHAR(200) NULL
   ,"SortOrder"                      SMALLINT NULL
   ,"Type"                           CHAR(1) NULL
   ,PRIMARY KEY ("ReasonID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."WithHoldReason"."Type" IS 
	'C - Client, A - Agency, T - Candidate'
GO