Table of Contents



pears.phonetype

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

Description

Type & capability definitions for telephone - fax - email etc

Columns

Column Type Null Default Comment
sortorder smallint NULL
company smallint NULL
contact smallint NULL
applicant smallint NULL
phonetypeid char(20) NOT NULL
name char(25) NOT NULL
Capabilities char(20) NULL <E>mail <F>ax <D>ial <S>MS <U>RL Social <M>edia
AuditFlag smallint NULL
displaygroup smallint NULL 0
displayname char(25) NULL
SocialMediaType char(25) NULL Only applies if Capabilities include Social <M>edia

Primary Key

Foreign Keys

Referenced By

Table Constraint Columns Referenced columns
pears.phone phonetype phonetypeid phonetypeid

Indexes

Name Type Columns Detail
phonetype_sortorder Index sortorder
phonetype_name Index name

Triggers

Name Timing Event
WPKPhoneTypeChange after insert,delete,update

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."phonetype"
-- Table comment: Type & capability definitions for telephone - fax - email etc
-- Statement count: 7
 
CREATE TABLE "pears"."phonetype" (
    "sortorder"                      SMALLINT NULL
   ,"company"                        SMALLINT NULL
   ,"contact"                        SMALLINT NULL
   ,"applicant"                      SMALLINT NULL
   ,"phonetypeid"                    CHAR(20) NOT NULL
   ,"name"                           CHAR(25) NOT NULL
   ,"Capabilities"                   CHAR(20) NULL
   ,"AuditFlag"                      SMALLINT NULL
   ,"displaygroup"                   SMALLINT NULL DEFAULT 0
   ,"displayname"                    CHAR(25) NULL
   ,"SocialMediaType"                CHAR(25) NULL
   ,PRIMARY KEY ("phonetypeid" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."phonetype"."Capabilities" IS 
	'<E>mail <F>ax <D>ial <S>MS <U>RL Social <M>edia'
GO
 
 
COMMENT ON COLUMN "pears"."phonetype"."SocialMediaType" IS 
	'Only applies if Capabilities include Social <M>edia'
GO
 
 
COMMENT ON TABLE "pears"."phonetype" IS 
	'Type & capability definitions for telephone - fax - email etc'
GO
 
 
CREATE INDEX "phonetype_sortorder" ON "pears"."phonetype"
    ( "sortorder" )
GO
 
 
CREATE INDEX "phonetype_name" ON "pears"."phonetype"
    ( "name" )
GO
 
 
CREATE TRIGGER "WPKPhoneTypeChange" after INSERT,DELETE,UPDATE ON
"pears"."PhoneType"
FOR each statement
BEGIN
  CALL "WPKTrackChange"('T','*')
END
GO