Lead - Campaign - Database

Can I use the database to find out which contact is currently in which campaign?

I’m asking because Table “campaign_leads” lists all campaigns that have been through a contact. If a contact is removed from a campaign, that table is still listed all campaigns, and the campaign itself has the contact removed