How email stored in DB for contact module?

💬 General Discussion
1

How email address are stores in the contact modules. We did not find them in the contacts or contacts_cstm tables?

Thank you!

2

Hello,

email addresses are a special sub-module.

In the DB the table is called:
email_addresses

image
image1990×798 231 KB

Background is: There shouldn’t be any email duplicates.

SELECT `email_address`, COUNT(*) AS `count` FROM `email_addresses` GROUP BY `email_address` HAVING `count` > 1 ORDER BY `email_address` ASC;

However, one email address could be related to a lead, a contact, an account, …

1 Like
3

I think even the below table is important to know the module(bean_module)

email_addr_bean_rel