Table of Contents



pears.vacancyclass

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Description

Erroneous table name. Should be Source. Superceded by origin

Columns

Column Type Null Default Comment
classcode char(1) NOT NULL
descrip char(40) NOT NULL
sortorder smallint NULL

Primary Key

Foreign Keys

Referenced By

Table Constraint Columns Referenced columns
pears.Company vacancyclass source classcode
pears.Person vacancyclass source classcode
pears.vacancy vacancyclass classcode classcode

Indexes

Name Type Columns Detail
vacancyclass_sortorder Index sortorder

Triggers

Name Timing Event
WPK_vacancyclass_SOURCE after insert,delete,update order 1

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."vacancyclass"
-- Table comment: Erroneous table name. Should be Source.  Superceded by origin
-- Statement count: 5
 
CREATE TABLE "pears"."vacancyclass" (
    "classcode"                      CHAR(1) NOT NULL
   ,"descrip"                        CHAR(40) NOT NULL
   ,"sortorder"                      SMALLINT NULL
   ,PRIMARY KEY ("classcode" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."vacancyclass" IS 
	'Erroneous table name. Should be Source.  Superceded by origin'
GO
 
 
CREATE INDEX "vacancyclass_sortorder" ON "pears"."vacancyclass"
    ( "sortorder" )
GO
 
 
CREATE TRIGGER "WPK_vacancyclass_SOURCE" after INSERT,DELETE,UPDATE ORDER 1 ON
"pears"."vacancyclass"
FOR each statement
BEGIN
  CALL "WPKTrackChange"('P','SOURCE')
END
GO
 
 
COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."vacancyclass"."WPK_vacancyclass_SOURCE" IS 
{CREATE TRIGGER WPK_vacancyclass_SOURCE 
 after INSERT,DELETE,UPDATE ORDER 1 ON
vacancyclass
FOR each statement
BEGIN
  CALL WPKTrackChange('P','SOURCE')
END
}
GO