Table of Contents



pears.Origin

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

Description

Sources of different object types - Candidate - Client - Vacancy

Columns

Column Type Null Default Comment
OriginID char(20) NOT NULL
descrip char(40) NOT NULL
type char(1) NOT NULL V=vacancy,P=person,C=company only allowed
sortorder smallint NULL
Defunct tinyint NULL 0
PublishToWeb tinyint NULL 0

Primary Key

Foreign Keys

Referenced By

Table Constraint Columns Referenced columns
pears.Company origin OriginID OriginID
pears.OriginDivision origin OriginID OriginID
pears.Person origin OriginID OriginID
pears.vacancy origin OriginID OriginID

Indexes

Name Type Columns Detail
Origin_sortorder Index sortorder

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."Origin"
-- Table comment: Sources of different object types - Candidate - Client - Vacancy
-- Statement count: 4
 
CREATE TABLE "pears"."Origin" (
    "OriginID"                       CHAR(20) NOT NULL
   ,"descrip"                        CHAR(40) NOT NULL
   ,"type"                           CHAR(1) NOT NULL
   ,"sortorder"                      SMALLINT NULL
   ,"Defunct"                        tinyint NULL DEFAULT 0
   ,"PublishToWeb"                   tinyint NULL DEFAULT 0
   ,PRIMARY KEY ("OriginID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."Origin"."type" IS 
	'V=vacancy,P=person,C=company only allowed'
GO
 
 
COMMENT ON TABLE "pears"."Origin" IS 
	'Sources of different object types - Candidate - Client - Vacancy'
GO
 
 
CREATE INDEX "Origin_sortorder" ON "pears"."Origin"
    ( "sortorder" )
GO