Templates / erDiagram

Customer churn prediction data model

Usage events feeding a computed churn probability score per customer.

Open in studio

Preview

Mermaid 11 renderer

Rendering preview...

Mermaid source

erDiagram

erDiagram
    CUSTOMER ||--o{ USAGE_EVENT : generates
    CUSTOMER ||--|| CHURN_SCORE : "scored by"
    CUSTOMER {
        int id PK
        string plan
        date signup_date
    }
    USAGE_EVENT {
        int id PK
        int customer_id FK
        string event_type
        datetime occurred_at
    }
    CHURN_SCORE {
        int customer_id PK
        float probability
        datetime computed_at
    }

More templates