email_account Table (484)

• 1 minute to read
 • 1 minute to read

Email account information

Fields

Name Description Type Null
email_account_id Primary key PK
email_address The From-address String(255) ●
associate_id Associate who owns this email account FK associate ●
incoming_auth Incoming server (imap) authentication FK service_auth ●
outgoing_auth Outgoing server (smtp) authentication FK service_auth ●
registered Registered when UtcDateTime
registered_associate_id Registered by whom FK associate
updated Last updated when UtcDateTime
updated_associate_id Last updated by whom FK associate
updatedCount Number of updates made to this record UShort
default True if this account is the default account for the associate who owns it Bool ●
account_status The status of this email account Enum EmailAccountStatus ●
encryptedCheck Encrypted hash checksum String(254)
error_count How many failures since reset Int ●
error_reason Reason for last failure if available String(254)

email_account table relationship diagram

Indexes

Fields Types Description
email_account_id PK Clustered, Unique
email_address String(255) Unique
associate_id FK Index

Relationships

Table Description
associate Employees, resources and other users - except for External persons
email_folder Corresponds to an email folder on a mail server
email_item Email data
service_auth Authentication for a service (imap, smtp...)

Replication Flags

  • None

Security Flags

  • No access control via user's Role.