MAILEXPRESS - Index

MAILEXPRESS

Group: Configuration Tables

Type: Tables

Table	Fields	Indexes	Check Constraints	Internal Foreign Keys	External Foreign Keys	Triggers
medatabase.AbstractSingleton	identifier createdDate modifiedDate version crux kind	PK__Abstract__D112ED4954D74D5E UQ__Abstract__ED32B96157B3BA09	none	none	FK19A00FE32C87F94 FK3CA0D2AC32C87F94 FK459A15832C87F94 FK48FE93532C87F94 FK6A394DE932C87F94 FK70F86B6232C87F94 FKA155673232C87F94 FKA8B4265C32C87F94 FKB73C5A2A32C87F94 FKC378407F32C87F94 FKC69F33FE32C87F94 FKCB2114F532C87F94 FKF1E3B59432C87F94	none
medatabase.Actor	identifier createdDate modifiedDate version accountInviteCapable activeToken crux deleted displayName dropoffCapable emailAddress enabled expirable forcePasswordChange kind locale passwordHash replyInviteCapable uploadCapable username	PK__Actor__D112ED496601D960 UQ__Actor__EC3F9A4E68DE460B	none	none	FK_AccountBid_account FK_AuditEvent_actor FK_Auditor_actor FK_Client_actor FK_Email_actor FK_Package_actor FK_ResetPasswordBid_account	none
medatabase.DatabasePurgeConfig	auditLogHistThreshTimeNumber auditLogHistThreshTimeUnit enableAuditLogPurge enableFullStorageNotification sizeNotifPeriodTimeNumber sizeNotifPeriodTimeUnit fullStorageThreshold storageQuota identifier	PK__Database__D112ED490E0FCABA	none	FKA155673232C87F94	none	none
medatabase.DMZGatewayConfig	DMZGatewayClientPort DMZGatewayHost DMZGatewayServerPort serviceEnabled identifier	PK__DMZGatew__D112ED49066EA8F2	none	FK48FE93532C87F94	none	none
medatabase.DropoffConfig	accountExpirationTimeNumber accountExpirationTimeUnit accountExpirationEnabled accountExpirationType enableCaptcha internalUsersAreVerified limitExtensions limitMaxSize limitNumberOfRecipients linkExpirationTimeNumber linkExpirationTimeUnit linkExpirationEnabled maxNumberOfRecipients maxSize requireVerifiedUser restrictRecipientDomains serviceEnabled identifier	PK__DropoffC__D112ED492D887613	none	FK70F86B6232C87F94	FK710E0A2EB60D31A FKED48278AB60D31A	none
medatabase.DropoffConfig_extnsnsExcldd	DropoffConfig_identifier element	none	none	FKED48278AB60D31A	none	none
medatabase.DropoffConfig_rcpntDmnsAllwd		none	none	none	none	none
medatabase.EftConfig	autoSyncEnabled encPassword eventAgeTimeNumber eventAgeTimeUnit serverHost serverPort serviceEnabled site username identifier	PK__EftConfi__D112ED493EB30215	none	FKCB2114F532C87F94	FK_EftConfig_syncConfig	none
medatabase.EftConfig_syncConfig	EftConfig_identifier synchronize configItem	PK__EftConfi__CD96AE08465423DD	none	FK_EftConfig_syncConfig	none	none
medatabase.FileConfig	enableFullStorageNotification enablePurge extPurgeDelayTimeNumber extPurgeDelayTimeUnit fullStorNotifyDelayTimeNumber fullStorNotifyDelayTimeUnit fullStorageThreshold intPurgeDelayTimeNumber intPurgeDelayTimeUnit storageQuota identifier	PK__FileConf__D112ED495E2BAD6E	none	FKC69F33FE32C87F94	none	none
medatabase.GeneralConfig	appletDefault appletEnabled certInstallDate defaultLandingPage eftComPermitted fileSystemRoot hostName authenticationEnabled proxyAddress proxyPort proxyType address city company country email postalCode registrationUser state systemNotifyEmail identifier	PK__GeneralC__D112ED4965CCCF36	none	FKB73C5A2A32C87F94	FK2B64AC25BE09461A	none
medatabase.GeneralConfig_bndngStrngs	GeneralConfig_identifier bindingStrings	PK__GeneralC__440EA5636D6DF0FE	none	FK2B64AC25BE09461A	none	none
medatabase.InternalConfig	accountInviteEnabled addinEnabled attachmentCount attachmentCountEnabled disconnectBehavior embeddedEnabled enforceRtfConversion fileExtensionEnabled fileSizeEnabled fileSizeThreshold integrityCheckEnabled internalUsrAcctInviteEnabled linkExpirationTimeNumber linkExpirationTimeUnit linkExpirationEnabled messageSizeEnabled messageSizeThreshold pluginUsageRequired replyInviteBehavior replyInviteUsrChoiceDefault serviceEnabled identifier	PK__Internal__D112ED49750F12C6	none	FKC378407F32C87F94	FK6262E70FFA326956	none
medatabase.InternalConfig_fileExtensions		none	none	none	none	none
medatabase.LdapConfig	CACertificateBytes SSLEnabled authenticationMode encPreauthUserPassword ldapHost ldapPort preauthUserDN searchBase searchFilter serviceEnabled identifier	PK__LdapConf__D112ED490174E9AB	none	FK6A394DE932C87F94	none	none
medatabase.License	identifier createdDate modifiedDate version additionalAttribute crux systemGUID licenseModuleType licenseState licenseType productCode registrationKey serialNumber systemSerial trialExpirationKey	PK__License__D112ED4909160B73	none	none	none	none
medatabase.LocaleConfig	defaultLocale identifier	PK__LocaleCo__D112ED490CE69C57	none	FKA8B4265C32C87F94	FKFEC216031293C8B6	none
medatabase.LocaleConfig_activeLocale	LocaleConfig_identifier locale	none	none	FKFEC216031293C8B6	none	none
medatabase.PickupConfig	requireEmailVerification requireVerifiedUser serviceEnabled identifier	PK__PickupCo__D112ED4936DCD623	none	FK19A00FE32C87F94	none	none
medatabase.ReplyConfig	enableCaptcha limitExtensions limitMaxSize linkExpirationTimeNumber linkExpirationTimeUnit linkExpirationEnabled maxSize restrictRecipientDomains serviceEnabled identifier	PK__ReplyCon__D112ED49509CA826	none	FK3CA0D2AC32C87F94	FK741D055427C8155A FK788135CE27C8155A	none
medatabase.ReplyConfig_extnsnsExcldd	ReplyConfig_identifier element	none	none	FK741D055427C8155A	none	none
medatabase.ReplyConfig_rcpntDmnsAllwd	ReplyConfig_identifier element	none	none	FK788135CE27C8155A	none	none
medatabase.SmtpConfig	CACertificateBytes encSmtpPassword fromAddress implicitTrust mailboxPort mailboxType replyToAddress smtpHost smtpPort smtpUsername useAuthentication useEncryption useMailbox identifier	PK__SmtpConf__D112ED49687431B7	none	FK459A15832C87F94	none	none
medatabase.WebServicesConfig	basicAuthRealm domainName encKdcPreauthUserPassword kdcHost kdcPort kdcPreauthUsername kerberosEnabled kerberosRealm identifier	PK__WebServi__D112ED497015537F	none	FKF1E3B59432C87F94	none	none

Group: Activity Tables

Type: Tables

Table	Fields	Indexes	Check Constraints	Internal Foreign Keys	External Foreign Keys	Triggers
medatabase.AccountBid	identifier createdDate modifiedDate version alias account_identifier recipient_identifier	PK__AccountB__D112ED495F54DBD1 UQ__AccountB__8C585C046231487C	none	FK_AccountBid_account FK_AccountBid_recipient	FK_EmailVerifyBid_accountBid FK_Manifest_AccountBid_b	none
medatabase.Dispatch	identifier createdDate modifiedDate version sentNotification localAddress localPort remoteAddress remotePort throughDmz userAgent	PK__Dispatch__D112ED4915B0EC82	none	none	FK_Docket_Dispatch_b FK_EftMessage_dispatch	none
medatabase.Docket	identifier createdDate modifiedDate version alias document_identifier recipient_identifier	PK__Docket__D112ED4919817D66 UQ__Docket__8C585C041C5DEA11	none	FK_Docket_document FK_Docket_recipient	FK_Docket_Dispatch_a FK_EftMessage_docket FK_EmailVerifyBid_docket FK_Manifest_Docket_b	none
medatabase.Docket_Dispatch	Docket_identifier dispatches_identifier	PK__Docket_D__3AE92269202E7AF5 UQ__Docket_D__8F6E6FCC230AE7A0	none	FK_Docket_Dispatch_a FK_Docket_Dispatch_b	none	none
medatabase.Document	identifier createdDate modifiedDate version alias purged digest fileChunks fileSize path title validated	PK__Document__D112ED4926DB7884 UQ__Document__8C585C0429B7E52F	none	none	FK_Docket_document FK_EftMessage_document FK_Package_Document_b	none
medatabase.EftMessage	messageType identifier createdDate modifiedDate version retries transferSize zipFile guid package_identifier dispatch_identifier docket_identifier document_identifier	PK__EftMessa__D112ED494DF545A5	none	FK_EftMessage_dispatch FK_EftMessage_docket FK_EftMessage_document FK_EftMessage_package	none	none
medatabase.Email	identifier createdDate modifiedDate version content problem retries subject sender_identifier	PK__Email__D112ED4951C5D689	none	FK_Email_actor	FKC565428D270ED0AA FKE2A1061D270ED0AA	none
medatabase.Email_from	Email_identifier element	none	none	FKC565428D270ED0AA	none	none
medatabase.Email_recipients	Email_identifier element	none	none	FKE2A1061D270ED0AA	none	none
medatabase.EmailVerificationBid	identifier createdDate modifiedDate version alias expiration crux displayName emailAddress passwordHash invite_identifier pickup_identifier locale	PK__EmailVer__D112ED495596676D UQ__EmailVer__8C585C045872D418	none	FK_EmailVerifyBid_accountBid FK_EmailVerifyBid_docket	none	none
medatabase.Manifest	identifier createdDate modifiedDate version crux locale notifyOnAccess origin passwordHash requirePickupAuth senderAddress senderPersonal localAddress localPort remoteAddress remotePort subject throughDmz	PK__Manifest__D112ED49194C733C	none	none	FK_Manifest_AccountBid_a FK_Manifest_Docket_a FK_Manifest_Recipient_a FK_Manifest_ReplyBid_a FK_Package_manifest	none
medatabase.Manifest_AccountBid	Manifest_identifier accountBids_identifier	UQ__Manifest__399A21181D1D0420	none	FK_Manifest_AccountBid_a FK_Manifest_AccountBid_b	none	none
medatabase.Manifest_Docket	Manifest_identifier dockets_identifier	UQ__Manifest__A706D5C120ED9504	none	FK_Manifest_Docket_a FK_Manifest_Docket_b	none	none
medatabase.Manifest_Recipient	Manifest_identifier recipients_identifier	UQ__Manifest__22AD223F24BE25E8	none	FK_Manifest_Recipient_a FK_Manifest_Recipient_b	none	none
medatabase.Manifest_ReplyBid	Manifest_identifier replyBids_identifier	UQ__Manifest__F118BC48288EB6CC	none	FK_Manifest_ReplyBid_a FK_Manifest_ReplyBid_b	none	none
medatabase.Package	identifier createdDate modifiedDate version alias purged accountInvite chunkSize documentCount expiration expiryNumber expiryTimeUnit replyInvite upload actor_identifier client_identifier manifest_identifier	PK__Package__D112ED492C5F47B0 UQ__Package__8C585C042F3BB45B	none	FK_Package_actor FK_Package_client FK_Package_manifest	FK_EftMessage_package FK_Package_Document_a FK_ReplyBid_Package_b	none
medatabase.Package_Document	Package_identifier documents_identifier	UQ__Package___45EFD17A330C453F	none	FK_Package_Document_a FK_Package_Document_b	none	none
medatabase.Recipient	identifier createdDate modifiedDate version address personal	PK__Recipien__D112ED493E7DF7EB	none	none	FK_AccountBid_recipient FK_Docket_recipient FK_Manifest_Recipient_b FK_Recipient_types FK_ReplyBid_recipient	none
medatabase.Recipient_types	Recipient_identifier element	PK__Recipien__C7D9BC66424E88CF	none	FK_Recipient_types	none	none
medatabase.ReplyBid	identifier createdDate modifiedDate version alias forAll recipient_identifier	PK__ReplyBid__D112ED49461F19B3 UQ__ReplyBid__8C585C0448FB865E	none	FK_ReplyBid_recipient	FK_Manifest_ReplyBid_b FK_ReplyBid_Package_a	none
medatabase.ReplyBid_Package	ReplyBid_identifier uploads_identifier	UQ__ReplyBid__A28C51F84CCC1742	none	FK_ReplyBid_Package_a FK_ReplyBid_Package_b	none	none
medatabase.ResetPasswordBid	identifier createdDate modifiedDate version alias expiration account_identifier	PK__ResetPas__D112ED4961C73428 UQ__ResetPas__8C585C0464A3A0D3	none	FK_ResetPasswordBid_account	none	none

Group: Auditing Tables

Type: Tables

Table	Fields	Indexes	Check Constraints	Internal Foreign Keys	External Foreign Keys	Triggers
medatabase.AbstractSingletonLog	identifier logNumber logOperation crux kind	PK__Abstract__B55535B75B844AED	none	FKFEA1089B95EB91ED	FK3A5FEACCD247948F FK3A5FEACCD247948F FK3C3D1748D247948F FK3C3D1748D247948F FK5841A8BAD247948F FK5841A8BAD247948F FK5EC6F60FD247948F FK5EC6F60FD247948F FK5F2548F8D247948F FK5F2548F8D247948F FK609AA166D247948F FK609AA166D247948F FK6292A89BD247948F FK6292A89BD247948F FK6DAA645D247948F FK6DAA645D247948F FK7CD96C82D247948F FK7CD96C82D247948F FK91751EB2D247948F FK91751EB2D247948F FKD8A48E66D247948F FKD8A48E66D247948F FKE714B9CFD247948F FKE714B9CFD247948F FKF1C89D10D247948F FKF1C89D10D247948F	none
medatabase.ActorLog	identifier logNumber logOperation accountInviteCapable activeToken crux deleted displayName dropoffCapable emailAddress enabled expirable forcePasswordChange kind locale passwordHash replyInviteCapable uploadCapable username	PK__ActorLog__B55535B76CAED6EF	none	FKA178A52F95EB91ED	none	none
medatabase.AuditEvent	identifier createdDate modifiedDate version ipAddress kind severity actor_identifier	PK__AuditEve__D112ED49707F67D3	none	FK_AuditEvent_actor	FK_AuditEvent_nmrcPrprts FK_AuditEvent_strngPrprts	none
medatabase.AuditEvent_nmrcPrprts	AuditEvent_identifier property field	PK__AuditEve__C588588E744FF8B7	none	FK_AuditEvent_nmrcPrprts	none	none
medatabase.AuditEvent_strngPrprts	AuditEvent_identifier property field	PK__AuditEve__C588588E7820899B	none	FK_AuditEvent_strngPrprts	none	none
medatabase.Auditor	identifier createdDate ipAddress actor_identifier	PK__Auditor__D112ED497BF11A7F	none	FK_Auditor_actor	FK3D30355095EB91ED FK44557A9695EB91ED FK50D3CA3695EB91ED FK5367B5B595EB91ED FK7C00B24195EB91ED FKA178A52F95EB91ED FKB3F6227D95EB91ED FKB85DD0DF95EB91ED FKBFB25F5A95EB91ED FKFEA1089B95EB91ED	none
medatabase.DatabasePurgeConfigLog	identifier logNumber auditLogHistThreshTimeNumber auditLogHistThreshTimeUnit enableAuditLogPurge enableFullStorageNotification sizeNotifPeriodTimeNumber sizeNotifPeriodTimeUnit fullStorageThreshold storageQuota	PK__Database__B55535B711E05B9E	none	FK91751EB2D247948F FK91751EB2D247948F	none	none
medatabase.DMZGatewayConfigLog	identifier logNumber DMZGatewayClientPort DMZGatewayHost DMZGatewayServerPort serviceEnabled	PK__DMZGatew__B55535B70A3F39D6	none	FKE714B9CFD247948F FKE714B9CFD247948F	none	none
medatabase.DropoffConfig_extnsnsExclddLog	logNumber DropoffConfig_identifier element logOperation	PK__DropoffC__CF6DCDFC361DBC14	none	FKBFB25F5A95EB91ED	none	none
medatabase.DropoffConfig_rcpntDmnsAllwdLog		none	none	none	none	none
medatabase.DropoffConfigLog	identifier logNumber accountExpirationTimeNumber accountExpirationTimeUnit accountExpirationEnabled accountExpirationType enableCaptcha internalUsersAreVerified limitExtensions limitMaxSize limitNumberOfRecipients linkExpirationTimeNumber linkExpirationTimeUnit linkExpirationEnabled maxNumberOfRecipients maxSize requireVerifiedUser restrictRecipientDomains serviceEnabled	PK__DropoffC__B55535B7315906F7	none	FK7CD96C82D247948F FK7CD96C82D247948F	none	none
medatabase.EftConfig_syncConfigLog	logNumber EftConfig_identifier synchronize configItem logOperation	PK__EftConfi__8FBA3DE94A24B4C1	none	FKB3F6227D95EB91ED	none	none
medatabase.EftConfigLog	identifier logNumber autoSyncEnabled encPassword eventAgeTimeNumber eventAgeTimeUnit serverHost serverPort serviceEnabled site username	PK__EftConfi__B55535B7428392F9	none	FK5EC6F60FD247948F FK5EC6F60FD247948F	none	none
medatabase.FileConfigLog	identifier logNumber enableFullStorageNotification enablePurge extPurgeDelayTimeNumber extPurgeDelayTimeUnit fullStorNotifyDelayTimeNumber fullStorNotifyDelayTimeUnit fullStorageThreshold intPurgeDelayTimeNumber intPurgeDelayTimeUnit storageQuota	PK__FileConf__B55535B761FC3E52	none	FKD8A48E66D247948F FKD8A48E66D247948F	none	none
medatabase.GeneralConfig_bndngStrngsLog	logNumber GeneralConfig_identifier bindingStrings logOperation	PK__GeneralC__603D65B1713E81E2	none	FKB85DD0DF95EB91ED	none	none
medatabase.GeneralConfigLog	identifier logNumber appletDefault appletEnabled certInstallDate defaultLandingPage eftComPermitted fileSystemRoot hostName authenticationEnabled proxyAddress proxyPort proxyType address city company country email postalCode registrationUser state systemNotifyEmail	PK__GeneralC__B55535B7699D601A	none	FK5841A8BAD247948F FK5841A8BAD247948F	none	none
medatabase.InternalConfig_fileExtensionsLog		none	none	none	none	none
medatabase.InternalConfigLog	identifier logNumber accountInviteEnabled addinEnabled attachmentCount attachmentCountEnabled disconnectBehavior embeddedEnabled enforceRtfConversion fileExtensionEnabled fileSizeEnabled fileSizeThreshold integrityCheckEnabled internalUsrAcctInviteEnabled linkExpirationTimeNumber linkExpirationTimeUnit linkExpirationEnabled messageSizeEnabled messageSizeThreshold pluginUsageRequired replyInviteBehavior replyInviteUsrChoiceDefault serviceEnabled	PK__Internal__B55535B778DFA3AA	none	FK6DAA645D247948F FK6DAA645D247948F	none	none
medatabase.LdapConfigLog	identifier logNumber CACertificateBytes SSLEnabled authenticationMode encPreauthUserPassword ldapHost ldapPort preauthUserDN searchBase searchFilter serviceEnabled	PK__LdapConf__B55535B705457A8F	none	FK6292A89BD247948F FK6292A89BD247948F	none	none
medatabase.LocaleConfig_activeLocaleLog	logNumber LocaleConfig_identifier locale logOperation	PK__LocaleCo__E98B9B8C157BE258	none	FK7C00B24195EB91ED	none	none
medatabase.LocaleConfigLog	identifier logNumber defaultLocale	PK__LocaleCo__B55535B710B72D3B	none	FK3C3D1748D247948F FK3C3D1748D247948F	none	none
medatabase.PickupConfigLog	identifier logNumber requireEmailVerification requireVerifiedUser serviceEnabled	PK__PickupCo__B55535B73AAD6707	none	FK609AA166D247948F FK609AA166D247948F	none	none
medatabase.ReplyConfig_extnsnsExclddLog	logNumber ReplyConfig_identifier element logOperation	PK__ReplyCon__B69E1E215931EE27	none	FK3D30355095EB91ED	none	none
medatabase.ReplyConfig_rcpntDmnsAllwdLog	logNumber ReplyConfig_identifier element logOperation	PK__ReplyCon__B69E1E215DF6A344	none	FK44557A9695EB91ED	none	none
medatabase.ReplyConfigLog	identifier logNumber enableCaptcha limitExtensions limitMaxSize linkExpirationTimeNumber linkExpirationTimeUnit linkExpirationEnabled maxSize restrictRecipientDomains serviceEnabled	PK__ReplyCon__B55535B7546D390A	none	FK5F2548F8D247948F FK5F2548F8D247948F	none	none
medatabase.SmtpConfigLog	identifier logNumber CACertificateBytes encSmtpPassword fromAddress implicitTrust mailboxPort mailboxType replyToAddress smtpHost smtpPort smtpUsername useAuthentication useEncryption useMailbox	PK__SmtpConf__B55535B76C44C29B	none	FK3A5FEACCD247948F FK3A5FEACCD247948F	none	none
medatabase.WebServicesConfigLog	identifier logNumber basicAuthRealm domainName encKdcPreauthUserPassword kdcHost kdcPort kdcPreauthUsername kerberosEnabled kerberosRealm	PK__WebServi__B55535B773E5E463	none	FKF1C89D10D247948F FKF1C89D10D247948F	none	none

Group: Miscellaneous Tables

Type: Tables

Table	Fields	Indexes	Check Constraints	Internal Foreign Keys	External Foreign Keys	Triggers
medatabase.Client	identifier createdDate modifiedDate version ipAddress leaseExpiration logonDate actor_identifier	PK__Client__D112ED497FC1AB63 UQ__Client__1A733BF9029E180E	none	FK_Client_actor	FK_Package_client	none
medatabase.ME_DATABASE_VERSION	DATABASE_VERSION	none	none	none	none	none

For more information, review the topics in the Contents to the left. If the Contents pane is hidden, click <--Show.

You can also search the Knowledgebase for help, or pose your question in the Globalscape User Forum. Visit the Mail Express Support Center for the most up-to-date information, to view version history, updates, and activation instructions, or to download a PDF of this user guide. For information about Globalscape, visit www.globalscape.com or follow us on Twitter.

Last modified: 07 October 2013 at 9:14:19