ChatDiagram
database schema · insurance · referral systems

Insurance Agent Multi-Level Referral Database Schema

유형 ERD표준 Chen 1976 / Everest 1976 (crow's foot)엔진 schematex-erd업데이트됨 2026. 8. 21.
Insurance Agent Multi-Level Referral Database Schema
Drawing preview
상황

A referral application for insurance agents needs to track multi-level agent recruitment, referred customers, issued policies, and commission splits per level.

이 도면에 담긴 내용

그 이면의 의사결정을 읽어 보세요.

01

Self-referential Agent parent_agent_id captures upline/downline hierarchy for multi-level referrals

02

CommissionRule and CommissionEntry model level-based bonus payouts without recalculating each time

03

Separate Customer and AgentReferral tables distinguish lead referrals from agent recruitment

Use this schema when building a multi-level marketing or referral tracking system where agents recruit other agents and earn commissions from downline sales.

모든 ERD 템플릿 보기 →