database:tables:pears_personstafflinktype



pears.PersonStaffLinkType

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

Primary Key

  • PersonStaffLinkTypeID

Foreign Keys

  • No outgoing foreign keys found.

Referenced By

Table Constraint Columns Referenced columns
pears.PersonStaffLink PersonStaffLinkType PersonStaffLinkTypeID PersonStaffLinkTypeID
pears.PersonStaffLinkTypeDivision PersonStaffLinkType PersonStaffLinkTypeID PersonStaffLinkTypeID

Indexes

  • No indexes found.

Triggers

  • No triggers found.

Original SQL

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