When I manually add an email address to a list, I am wondering where the list and xDB contact are associated. Looking at the code, it looks like it would be a contact facet. But when I pull the facets for my contact, nothing sticks out. Any idea where the list is assigned to the contact or the the contact is assigned to the list. I was the understanding it all happens on the xDB contact.
It looks like the connection is in the contact facets as a facet named
ListSubscriptions. But I have not been able to tie one back to a known contact yet.
SELECT TOP (1000) [ContactId] ,[FacetKey] ,[LastModified] ,[ConcurrencyToken] ,[FacetData] FROM [sitecore_Xdb.Collection.Shard0].[xdb_collection].[ContactFacets] WHERE FacetKey = 'ListSubscriptions'