⚡
Schema change v2: Contacts — Full_Name replaced by First_Name + Last_Name. Email templates in Make use First_Name for salutation, concatenate both for full name.
⚡
Schema change v3 (23 Mar 2026): Added Contact_Stage to Contacts (Waitlist/Onboarding/Active/Inactive). Added Organiser_Portal_Email, Postcode_Raw, Max_Quotes_Allowed, Quotes_Sent_Count to Events. Added Introduction_Date and Protection_End_Date to Referrals (supports 4-year repeat-event commission tracking).
PK Primary key
FK Foreign key
Core entities
Suppliers
string Supplier_ID PK
string Business_Name
select Supplier_Category
select Coverage_Type
int Max_Range_Miles
multi Coverage_Counties
multi Event_Types_Served
multi Event_Types_Excluded
select Subscription_Status
select Std_Payment_Structure
int Late_Threshold_Days
phone WhatsApp_Number
select Comms_Preference
formula Supplier_Score
formula Quality_Flag
link Outcode FK
Contacts
string Contact_ID PK
string First_Name ★
string Last_Name ★
email Email
phone Phone
select Role
select Portal_Role
bool Primary_Contact
bool Portal_Enabled
link Supplier_ID FK
select Contact_Stage ★
Events
string Event_ID PK
string Organiser_Company
string Organiser_Name
email Organiser_Email
select Event_Type
select Structure_Category
date Event_Date
date Event_End_Date
int Guest_Count
select Status
select Quote_Tier
formula Duplicate_Check_Key
bool Duplicate_Flag
link Outcode FK
link Referred_By_Supplier FK
string Postcode_Raw ★
email Organiser_Portal_Email ★
formula Max_Quotes_Allowed ★
int Quotes_Sent_Count ★
[Ref] Outcodes
string Outcode PK
decimal Latitude
decimal Longitude
string Town
string Region
string Country
Transactional
Quotes
string Quote_ID PK
link Event_ID FK
link Supplier_ID FK
formula CC_Reference_Code
formula Is_Late_Request
currency Quote_Amount
formula Commission_Total (10%)
formula PPN_Overhead (2%)
formula Referral_Supplier_Share (4%)
formula PPN_Net
select Applied_Structure
select Status
select Honesty_Loop_Stage
select Did_It_Happen
currency Final_Agreed_Price
Payment_Schedules
string Payment_ID PK
link Quote_ID FK
lookup Supplier_ID FK
select Payment_Type
date Due_Date
currency Payment_Amount
formula Commission_Due
formula Referral_Share
formula PPN_Net
select Status
bool Commission_Paid
Referrals
string Referral_ID PK
link Referring_Supplier FK
link Referred_Event FK
link Resulting_Quote FK
select Status
lookup Commission_Split (4%)
bool Applied_To_Subscription
date Introduction_Date ★
date Protection_End_Date ★
Subscriptions
string Billing_ID PK
link Supplier_ID FK
date Period_Start
date Period_End
currency Gross_Fee
currency Referral_Credits
formula Net_Amount_Due
select Payment_Status
Supporting
Reviews
string Review_ID PK
link Event_ID FK
link Supplier_ID FK
int Overall_Rating (1–5)
bool Would_Recommend
text Review_Text
bool Consent_To_Publish
select Internal_Flag
Activity_Log
string Log_ID PK
link Supplier_ID FK
link Event_ID FK
link Quote_ID FK
select Type
string Message
bool Read
datetime Created_At
Relationships
From Cardinality To Via field
Suppliers 1 → many Contacts Supplier_ID Suppliers 1 → many Quotes Supplier_ID Events 1 → many Quotes Event_ID Quotes 1 → many Payment_Schedules Quote_ID Suppliers 1 → many Referrals Referring_Supplier Events 0–1 → many Referrals Referred_Event Events 1 → many Reviews Event_ID Suppliers 1 → many Reviews Supplier_ID Suppliers 1 → many Activity_Log Supplier_ID Suppliers 1 → many Subscriptions Supplier_ID Suppliers many → 1 [Ref] Outcodes Outcode Events many → 1 [Ref] Outcodes Outcode Events 0–1 → 1 Suppliers (self) Referred_By_Supplier
PrePitched Network (PPN) · ERD v2 · Schema change: First_Name + Last_Name
Designed by Seamless · March 2026