database:tables:pears_mailserver



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

  • MailServerID

Foreign Keys

  • No outgoing foreign keys found.

Referenced By

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

Indexes

  • No indexes found.

Triggers

  • No triggers found.

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
  • database/tables/pears_mailserver.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1