Contacts, participants, activities, memberships! It's a lot. Understanding how these things relate to each other in Powerbase can help when trying to understand how to create custom fields or build a search. Below is a simplified diagram to help you wrap your head around it all. If you want more, CiviCRM has published more detailed entity relationship diagrams.
File attachments:
Category:
Learning Powerbase
PowerBase - General