database:tables:pears_placementextensionreason



pears.PlacementExtensionReason

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
PlacementExtensionReasonID char(20) NOT NULL
Description char(50) NOT NULL
SortOrder smallint NULL

Primary Key

  • PlacementExtensionReasonID

Foreign Keys

  • No outgoing foreign keys found.

Referenced By

Table Constraint Columns Referenced columns
pears.PlacementExtension PlacementExtensionReason PlacementExtensionReasonID PlacementExtensionReasonID

Indexes

  • No indexes found.

Triggers

  • No triggers found.

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."PlacementExtensionReason"
-- Table comment: 
-- Statement count: 1
 
CREATE TABLE "pears"."PlacementExtensionReason" (
    "PlacementExtensionReasonID"     CHAR(20) NOT NULL
   ,"Description"                    CHAR(50) NOT NULL
   ,"SortOrder"                      SMALLINT NULL
   ,PRIMARY KEY ("PlacementExtensionReasonID" ASC) 
)
GO
  • database/tables/pears_placementextensionreason.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1