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