Skip to content

telecom

sqllocks_spindle.domains.telecom

Telecom domain — subscribers, service lines, usage, and billing.

Classes

TelecomDomain

Bases: Domain

Telecom domain — subscribers, service lines, usage, billing, and churn.

Available schema modes
  • 3nf: Normalized schema with proper 3NF relationships

Tables (3NF mode): - plan: Service plans - device_model: Phone/device models - subscriber: Customers - service_line: Phone lines - usage_record: CDR/usage - billing: Monthly bills - payment: Bill payments - network_event: Network events - churn_indicator: Churn predictions

Methods:
star_schema_map()

Return the star schema mapping for the Telecom domain.

Produces
  • dim_subscriber (from subscriber)
  • dim_plan (from plan)
  • dim_device_model (from device_model)
  • dim_service_line (from service_line)
  • dim_date (generated from record_date / billing_period_start / event_timestamp)
  • fact_usage (from usage_record)
  • fact_billing (from billing)
  • fact_network (from network_event)
cdm_map()

Return the CDM entity map for the Telecom domain.