MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.GeneralConfig
Description: General configuration settings.
Primary Keys: identifier
Field Type Defaults Nulls? Comments
appletDefault tinyint None No Whether we display the java applet first by default.
appletEnabled tinyint None No Whether file transfers through java applet are enabled or not.
certInstallDate datetime None Yes The installation data/time of the current SSL certificate.
defaultLandingPage nvarchar (255) None No The default landing page for MailExpress. One of InternalPortal, DropoffPortal or UserChoice (User is prompted and then re-directed to the portal of their choice if accessible.).
eftComPermitted tinyint None No Whether or not the EFT functionality is permitted.
fileSystemRoot nvarchar (4000) None Yes The path to the location where attachments will be stored.
fipsCompliant tinyint None No Whether configured to be FIPS compliant.
hostName nvarchar (256) None Yes The hostname to use for package pickup links.
authenticationEnabled tinyint None No Whether or not authentication is used with the proxy.
proxyAddress nvarchar (256) None Yes The ip address for the proxy.
proxyPort int None Yes The port used for the proxy.
proxyType nvarchar (255) None No Specifies connection settings (system proxy, no proxy, or explicitly defined).
address nvarchar (80) None Yes The street address of the contact that preformed registration.
city nvarchar (80) None Yes The city of the contact that preformed registration.
company nvarchar (80) None Yes The company of the contact that preformed registration.
country nvarchar (80) None Yes The country of the contact that preformed registration.
email nvarchar (80) None Yes The email of the contact that preformed registration.
postalCode nvarchar (80) None Yes The postal code of the contact that preformed registration.
registrationUser nvarchar (80) None Yes The name of the contact that preformed registration.
state nvarchar (80) None Yes The state or province of the contact that preformed registration.
systemNotifyEmail nvarchar (256) None Yes The list of email addresses to which system notifications should be sent.
identifier numeric (19) None No Unique ID for an entry.
requestAccountEnabled tinyint None No Whether users are allowed to request an account on the portal login pages.

Index Clustered? Unique? Fields
PK__GeneralC__D112ED4930BAB3D0 Yes Yes

No check constraints
Internal Foreign Key Constraint Affected Field Source Table
FKB73C5A2A32C87F94 identifier AbstractSingleton

Primary Key as Foreign Key Constraint Affected Table Affected Field
FK2B64AC25BE09461A GeneralConfig_bndngStrngs GeneralConfig_identifier

No triggers