in the pm1_mailing_audience_members table, there is a column named UserOpenedMailing
when a user opens the mail in the email client, it sends a request for an image to the server, that image request triggers an update to the database to record that the user has opened the mailing in the client.