ChatDiagram
Database Schema · ERD · Referral Marketing

Customer Referral Program Schema

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

A referral application needs to track customer referrals, reward coupons, and order conversions for a coupon-based incentive program.

이 도면에 담긴 내용

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

01

Modeled referral programs separately to support multiple active campaigns with different reward rules.

02

Linked coupons to both referral and customer to record which party received the reward.

03

Attributed orders to referrals to measure conversion and reward eligibility.

Use this schema as a starting point for referral or loyalty features in e-commerce, SaaS, or marketplace platforms that issue coupon rewards for successful referrals.

모든 ERD 템플릿 보기 →