Electronic mail authentication and tracking in database system

A method, comprising:

• processing a first electronic mail message received via a network from a first client device, the first electronic mail message having a header including a message identifier;
• obtaining the message identifier from the header;
• parsing the message identifier such that an encrypted portion and one or more unencrypted portions are obtained, a first unencrypted portion of the unencrypted portions including an entity identifier associated with a first database record of a database;
• obtaining a secret key associated with the first electronic mail message;
• authenticating the first electronic mail message using the secret key, the encrypted portion of the message identifier, and at least one unencrypted portion of the unencrypted portions of the message identifier;
• and
• storing the first electronic mail message in association with the first database record according to a result of authenticating the first electronic mail message.

A non-transitory machine-readable storage medium having computer program instructions stored therein, the computer program instructions configured such that, when executed by one or more processors, the computer program instructions cause the one or more processors to:

• process a first electronic mail message received via a network from a first client device, the first electronic mail message having a header including a message identifier;
• obtain the message identifier from the header;
• parse the message identifier such that an encrypted portion and one or more unencrypted portions are obtained, a first unencrypted portion of the unencrypted portions including an entity identifier associated with a first database record of a database;
• obtain a secret key associated with the first electronic mail message;
• authenticate the first electronic mail message using the secret key, the encrypted portion of the message identifier, and at least one unencrypted portion of the unencrypted portions of the message identifier;
• and
• store the first electronic mail message in association with the first database record according to a result of authenticating the first electronic mail message.