pears.vacancyclass

Erroneous table name. Should be Source. Superceded by origin

• classcode

• No outgoing foreign keys found.

-- 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