database:tables:pears_withholdreason



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

  • ReasonID

Foreign Keys

  • No outgoing foreign keys found.

Referenced By

Table Constraint Columns Referenced columns
pears.WithHolds WithHoldReason ReasonID ReasonID

Indexes

  • No indexes found.

Triggers

  • No triggers found.

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
  • database/tables/pears_withholdreason.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1