Table of Contents



pears.MailServer

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

Description

Mail Server configuration

Columns

Column Type Null Default Comment
MailServerID char(20) NOT NULL
ServerType char(1) NOT NULL S=SMTP I=IMAP
Address char(200) NOT NULL
Port integer NULL
Timeout integer NULL
SSL smallint NULL

Primary Key

Foreign Keys

Referenced By

Table Constraint Columns Referenced columns
pears.agencydetails IMAPServer IMAPServer MailServerID
pears.agencydetails SMTPServer SMTPServer MailServerID

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."MailServer"
-- Table comment: Mail Server configuration
-- Statement count: 3
 
CREATE TABLE "pears"."MailServer" (
    "MailServerID"                   CHAR(20) NOT NULL
   ,"ServerType"                     CHAR(1) NOT NULL
   ,"Address"                        CHAR(200) NOT NULL
   ,"Port"                           INTEGER NULL
   ,"Timeout"                        INTEGER NULL
   ,"SSL"                            SMALLINT NULL
   ,PRIMARY KEY ("MailServerID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."MailServer"."ServerType" IS 
	'S=SMTP I=IMAP'
GO
 
 
COMMENT ON TABLE "pears"."MailServer" IS 
	'Mail Server configuration'
GO