pears.IQXNetEmailDetails

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

This is the Maintaince > IQXWeb Settings > Email Details information

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
  • IQXNetEmailDetailsID
  • No outgoing foreign keys found.
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
  • No indexes found.
  • No triggers found.
-- 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
  • database/tables/pears_iqxnetemaildetails.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1