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

Core Entities

18 entities for members, events, courses, and content

Integration Entities

6 entities for payments, CRM sync, and external systems

System Entities

1 entity for audit logging

Lookup Entities

25 lookup/config tables referenced by relationships

Core Entities

Entity	Description
User/Member	Member accounts and authentication
Membership Plan	Subscription plans and pricing
Group Membership	Corporate/group accounts
Event	Event details and configuration
Event Ticket	Ticket purchases
Course	LMS course structure
Course Enrollment	Member course progress
CPD Record	CPD point records
CPD Category	CPD categories and requirements
Resource	Resource library items
Interest Category	Content targeting categories
Generated Content	AI-generated community content
Content Comment	Member comments on generated content
Job Posting	Career listings
Company Profile	Directory listings
Support Ticket	Support requests
Sponsorship	Sponsor campaigns
Notification Template	Email/SMS templates

Integration Entities

Entity	Description
Payment Transaction	Payment records
CRM Sync Record	CRM synchronization
CRM Tag	Predefined tags for CRM sync
Unearned Revenue	Revenue recognition
Stripe Webhook Event	Payment webhooks
Integration Settings	Integration config

System Entities

Entity	Description
Audit Log	Action audit trail

Lookup Entities

• Content Reaction
• Comment Reaction
• Content Nomination
• Event Category
• Event Series
• Event Branch
• Event Status
• Event Type
• Course Category
• Course Status
• Course Type
• Course Series
• Course Branch
• Resource Category
• Resource Status
• Resource Type
• Resource Series
• Resource Branch
• Membership Pricing
• Corporate Subscription Pricing
• Order Type
• Order Payment Status
• User Membership
• Client Profile
• 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.