bigdata
Tables (9)
billing_snapshot
- customer_id — TEXT — Foreign key → customer.customer_id — NOT NULL
- payment_method_id — TEXT — Foreign key → payment_method.payment_method_id — NOT NULL
- receipt_issued — INTEGER — NOT NULL
- data_charge — NUMERIC — NOT NULL
- roaming_charge — NUMERIC — NOT NULL
- monthly_avg_charge — NUMERIC — NOT NULL
- recent_charge — NUMERIC — NOT NULL
- cumulative_charge — NUMERIC — NOT NULL
- billing_period — INTEGER — NOT NULL
- arpu — NUMERIC — NOT NULL
churn_event
- customer_id — TEXT — Foreign key → customer.customer_id — NOT NULL
- end_date — TEXT — NOT NULL
- churn_type_id — TEXT — Foreign key → churn_type.churn_type_id — NOT NULL
- churn_reason_id — TEXT — Foreign key → churn_reason.churn_reason_id — NOT NULL
churn_reason
- churn_reason_id — TEXT — Primary key — NOT NULL
- churn_reason_text — TEXT — NOT NULL
churn_type
- churn_type_id — TEXT — Primary key — NOT NULL
- churn_type_name — TEXT — NOT NULL
customer
- customer_id — TEXT — Primary key — NOT NULL
- gender — TEXT — NOT NULL
- age — INTEGER — NOT NULL
- is_married — INTEGER — NOT NULL
- dependent_count — INTEGER — NOT NULL
- has_dependents — INTEGER — NOT NULL
- referral_count — INTEGER — NOT NULL
- created_at — TEXT — NOT NULL
- updated_at — TEXT — NOT NULL
- deleted_at — TEXT
customer_metric
- customer_id — TEXT — Foreign key → customer.customer_id — NOT NULL
- churn_score — INTEGER — NOT NULL
- ltv — INTEGER — NOT NULL
- satisfaction — INTEGER — NOT NULL
payment_method
- payment_method_id — TEXT — Primary key — NOT NULL
- payment_method_name — TEXT — NOT NULL
service_usage
- customer_id — TEXT — Foreign key → customer.customer_id — NOT NULL
- security_service — INTEGER — NOT NULL
- backup_service — INTEGER — NOT NULL
- tech_support_service — INTEGER — NOT NULL
- unlimited_data — INTEGER — NOT NULL
- data_usage — INTEGER — NOT NULL
- roaming_count — INTEGER — NOT NULL
subscription
- customer_id — TEXT — Foreign key → customer.customer_id — NOT NULL
- start_date — TEXT — NOT NULL
- is_churned — INTEGER — NOT NULL