Core Data Fields — CRM Schema

Database entities and fields to model in your BPM system

Lead / Contact Record
lead_id · full_name · nationality · language_preference
phone_primary · phone_whatsapp · email
lead_source · campaign_id · assigned_agent_id
lead_status · lead_score (0–100) · temperature
budget_min · budget_max · payment_type (Cash/Mortgage)
property_type_interest · bedroom_count · preferred_areas[]
purpose (Buy/Rent/Invest) · timeline
first_contact_date · last_contact_date · next_followup
total_interactions · notes[] · tags[]
Activity / Interaction Log
activity_id · lead_id · agent_id
activity_type (Call/WhatsApp/Email/Visit/Proposal)
datetime · outcome · duration_seconds
notes · recording_url · next_action
Dubai Compliance Fields
rera_form_type (Form A / B / F / I / U)
ejari_number · oqood_registration_number
title_deed_number · noc_issued · noc_expiry
dld_transfer_fee_paid · dld_receipt_url
Property / Listing
property_id · developer · project_name · unit_number
community · area_sqft · bedrooms · bathrooms
status (Off-Plan/Ready/Secondary) · price_aed
payment_plan[] · handover_date
rera_permit_number · rera_permit_expiry
floor_plan_url · brochure_url · matched_leads_count
Deal / Opportunity
deal_id · lead_id · property_id · agent_id
stage · deal_value_aed · commission_aed · commission_pct
booking_date · spa_date · transfer_date
oqood_number · form_f_signed · noc_status
loss_reason · co_broker_id · form_i_signed