pears.phonetype

Type & capability definitions for telephone - fax - email etc

• phonetypeid

• No outgoing foreign keys found.

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