<code SQL>

CREATETABLE “pears”.“ReferenceRequest” (

              "ReferenceRequestID" CHAR(20) NOT NULL,
              "PersonID" CHAR(20) NOT NULL,
              "DepartmentID" CHAR(2) NOT NULL,
              "RefereeAddressName" CHAR(60) NOT NULL,
              "RefereeSalutation" CHAR(60) NOT NULL,
              "RefereePosition" CHAR(40) NOT NULL,
              "CompanyName" CHAR(60) NULL,
              "Keyname" CHAR(60) NOT NULL,
              "Addr1" CHAR(40) NULL,
              "Addr2" CHAR(40) NULL,
              "Addr3" CHAR(40) NULL,
              "Town" CHAR(30) NULL,
              "County" CHAR(30) NULL,
              "Country" CHAR(30) NULL,
              "PostCode" CHAR(20) NULL,
              "HomePhone" CHAR(100) NULL,
              "WorkPhone" CHAR(100) NULL,
              "MobilePhone" CHAR(100) NULL,
              "Fax" CHAR(100) NULL,
              "Email" CHAR(250) NOT NULL,
              "Position" CHAR(100) NOT NULL,
              "PositionNotes" LONG VARCHAR NULL,
              "URLRequestCode" CHAR(250) NULL,
              "Processed" SMALLINT NULL DEFAULT 0,
              "StaffID" CHAR(20) NULL,
              "WhenCreated" TIMESTAMP NULL DEFAULT CURRENT TIMESTAMP,
              "WhenCompleted" TIMESTAMP NULL,
              "WhenProcessed" TIMESTAMP NULL,
              "WhenSent" TIMESTAMP NULL,
              "WhoProcessed" CHAR(20) NULL,
              "employmentid" CHAR(20) NULL,
              "RefType" SMALLINT NULL,
              "whenreturned" TIMESTAMP NULL,
	"StartDate" TIMESTAMP NULL,
	"EndDate" TIMESTAMP NULL,
              PRIMARY KEY ( "ReferenceRequestID" ASC )) IN "system";

1 personal, 2 professional, 3 define their own.

ALTER TABLE “pears”.“ReferenceRequest” ADD CONSTRAINT “person” FOREIGN KEY ( “personid” ASC ) REFERENCES “pears”.“person” ( “personid” ); ALTER TABLE “pears”.“tag” ADD “LongDescription” LONG VARCHAR NULL;

CREATE INDEX “ReferenceRequest_URLRequestCode” ON “pears”.“ReferenceRequest” ( “URLRequestCode” ASC ) IN “SYSTEM”; <code>