Table of Contents



pears.IQXNetEmailDetails

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

Description

This is the Maintaince > IQXWeb Settings > Email Details information

Columns

Column Type Null Default Comment
IQXNetEmailDetailsID char(20) NOT NULL
WebAddress char(100) NULL
AgencyName char(100) NULL
EmailRoot char(100) NULL
SMTPHost char(100) NULL
SMTPUserID char(50) NULL
SMTPPassword char(200) NULL
SMTPSenderAddress char(50) NULL
SMTPPort integer NULL
SMTPTLS tinyint NULL
DefaultUserPassword char(50) NULL
WebSiteFolder char(100) NULL

Primary Key

Foreign Keys

Referenced By

Table Constraint Columns Referenced columns
pears.agencydetails IQXNetEmailDetails IQXNetEmailDetailsID IQXNetEmailDetailsID
pears.Department IQXNetEmailDetails IQXNetEmailDetailsID IQXNetEmailDetailsID
pears.Division IQXNetEmailDetails IQXNetEmailDetailsID IQXNetEmailDetailsID
pears.NotificationTemplate IQXNetEmailDetails IQXNetEmailDetailsID IQXNetEmailDetailsID
pears.staff IQXNetEmailDetails IQXNetEmailDetailsID IQXNetEmailDetailsID
pears.tempdesk IQXNetEmailDetails IQXNetEmailDetailsID IQXNetEmailDetailsID

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQXNetEmailDetails"
-- Table comment: This is the Maintaince > IQXWeb Settings > Email Details information
-- Statement count: 2
 
CREATE TABLE "pears"."IQXNetEmailDetails" (
    "IQXNetEmailDetailsID"           CHAR(20) NOT NULL
   ,"WebAddress"                     CHAR(100) NULL
   ,"AgencyName"                     CHAR(100) NULL
   ,"EmailRoot"                      CHAR(100) NULL
   ,"SMTPHost"                       CHAR(100) NULL
   ,"SMTPUserID"                     CHAR(50) NULL
   ,"SMTPPassword"                   CHAR(200) NULL
   ,"SMTPSenderAddress"              CHAR(50) NULL
   ,"SMTPPort"                       INTEGER NULL
   ,"SMTPTLS"                        tinyint NULL
   ,"DefaultUserPassword"            CHAR(50) NULL
   ,"WebSiteFolder"                  CHAR(100) NULL
   ,PRIMARY KEY ("IQXNetEmailDetailsID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."IQXNetEmailDetails" IS 
	'This is the Maintaince > IQXWeb Settings > Email Details information'
GO