====== 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 ^
| [[database:tables:pears_personstafflink|pears.PersonStaffLink]] | PersonStaffLinkType | PersonStaffLinkTypeID | PersonStaffLinkTypeID |
| [[database:tables:pears_personstafflinktypedivision|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