> ## Documentation Index
> Fetch the complete documentation index at: https://memberpulseptyltd.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Entities Overview

> Data model overview for MemberPulse V3

Data model overview for MemberPulse V3

## Overview

Complete data model reference for MemberPulse V3, defining all database entities, their fields, and relationships.

## Entity Categories

<CardGroup cols={2}>
  <Card title="Core Entities" icon="cube">
    18 entities for members, events, courses, and content
  </Card>

  <Card title="Integration Entities" icon="plug">
    6 entities for payments, CRM sync, and external systems
  </Card>

  <Card title="System Entities" icon="gear">
    1 entity for audit logging
  </Card>

  <Card title="Lookup Entities" icon="list">
    25 lookup/config tables referenced by relationships
  </Card>
</CardGroup>

## Core Entities

| Entity                                                        | Description                          |
| ------------------------------------------------------------- | ------------------------------------ |
| [User/Member](/entities/core/user-member)                     | Member accounts and authentication   |
| [Membership Plan](/entities/core/membership-plan)             | Subscription plans and pricing       |
| [Group Membership](/entities/core/group-corporate-membership) | Corporate/group accounts             |
| [Event](/entities/core/event)                                 | Event details and configuration      |
| [Event Ticket](/entities/core/event-ticket)                   | Ticket purchases                     |
| [Course](/entities/core/course)                               | LMS course structure                 |
| [Course Enrollment](/entities/core/course-enrollment)         | Member course progress               |
| [CPD Record](/entities/core/cpd-record)                       | CPD point records                    |
| [CPD Category](/entities/core/cpd-category)                   | CPD categories and requirements      |
| [Resource](/entities/core/resource)                           | Resource library items               |
| [Interest Category](/entities/core/interest-category)         | Content targeting categories         |
| [Generated Content](/entities/core/generated-content)         | AI-generated community content       |
| [Content Comment](/entities/core/content-comment)             | Member comments on generated content |
| [Job Posting](/entities/core/job-posting)                     | Career listings                      |
| [Company Profile](/entities/core/company-profile)             | Directory listings                   |
| [Support Ticket](/entities/core/support-ticket)               | Support requests                     |
| [Sponsorship](/entities/core/sponsorship)                     | Sponsor campaigns                    |
| [Notification Template](/entities/core/notification-template) | Email/SMS templates                  |

## Integration Entities

| Entity                                                             | Description                  |
| ------------------------------------------------------------------ | ---------------------------- |
| [Payment Transaction](/entities/integration/payment-transaction)   | Payment records              |
| [CRM Sync Record](/entities/integration/crm-sync-record)           | CRM synchronization          |
| [CRM Tag](/entities/integration/crm-tag)                           | Predefined tags for CRM sync |
| [Unearned Revenue](/entities/integration/unearned-revenue)         | Revenue recognition          |
| [Stripe Webhook Event](/entities/integration/stripe-webhook-event) | Payment webhooks             |
| [Integration Settings](/entities/integration/integration-settings) | Integration config           |

## System Entities

| Entity                                  | Description        |
| --------------------------------------- | ------------------ |
| [Audit Log](/entities/system/audit-log) | Action audit trail |

## Lookup Entities

* [Content Reaction](/entities/core/content-reaction)
* [Comment Reaction](/entities/core/comment-reaction)
* [Content Nomination](/entities/core/content-nomination)
* [Event Category](/entities/core/event-category)
* [Event Series](/entities/core/event-series)
* [Event Branch](/entities/core/event-branch)
* [Event Status](/entities/core/event-status)
* [Event Type](/entities/core/event-type)
* [Course Category](/entities/core/course-category)
* [Course Status](/entities/core/course-status)
* [Course Type](/entities/core/course-type)
* [Course Series](/entities/core/course-series)
* [Course Branch](/entities/core/course-branch)
* [Resource Category](/entities/core/resource-category)
* [Resource Status](/entities/core/resource-status)
* [Resource Type](/entities/core/resource-type)
* [Resource Series](/entities/core/resource-series)
* [Resource Branch](/entities/core/resource-branch)
* [Membership Pricing](/entities/core/membership-pricing)
* [Corporate Subscription Pricing](/entities/core/corporate-subscription-pricing)
* [Order Type](/entities/core/order-type)
* [Order Payment Status](/entities/core/order-payment-status)
* [User Membership](/entities/core/user-membership)
* [Client Profile](/entities/core/client-profile)
* [Member Profile](/entities/core/member-profile)

```
Member ─────┬──────── Membership Plan
            ├──────── Group Membership
            ├──────── Event Ticket ──── Event
            ├──────── Course Enrollment ── Course
            ├──────── CPD Record ──── CPD Category
            ├──────── Support Ticket
            └──────── Payment Transaction

Company Profile ──── Sponsorship
                └─── Job Posting
```

## Acceptance Criteria

### Frontend

* [ ] Admin/client UI can view and manage `Entities Overview` records where applicable.

### Backend / API

* [ ] CRUD operations exist for `Entities Overview` (create, read, update, delete/archive).

### Permissions

* [ ] Access is restricted to appropriate roles (tenant-scoped).

### Business Rules

* [ ] Fields and relationships documented on this page are enforced for `Entities Overview`.

### Error Handling

* [ ] Invalid payloads return field-level validation errors.