Political Party Churn

Tables (5)

Activity (PartyActivity)

  • MemberID (ActivityID) — int — Primary key — NOT NULL
  • MembershipDuration — int
  • MembershipType — string
  • PoliticalActivity — int
  • PartyLoyalty — int
  • PartyParticipation — int
  • FinancialContribution — int

Churn

  • MemberID (ChurnID) — int — Primary key — NOT NULL
  • Churn — int

ID (MemberID)

  • MemberID — int — Primary key — NOT NULL
  • MemberID (ActivityID) — int — Foreign key → Activity.MemberID — NOT NULL
  • MemberID (OpinionID) — int — Foreign key → Opinion.MemberID — NOT NULL
  • MemberID (ChurnID) — int — Foreign key → Churn.MemberID — NOT NULL
  • MemberID (MediaID) — int — Foreign key → Media.MemberID — NOT NULL
  • Age — int
  • Gender — string
  • Region — string
  • Education — string
  • Occupation — string
  • Income_Decile — int
  • Income — string
  • Primary_Support — string

Media (MediaConsumption)

  • MemberID (MediaID) — int — Primary key — NOT NULL
  • MediaConsumption — string

Opinion

  • MemberID (OpinionID) — int — Primary key — NOT NULL
  • PresidentApproval — int
  • PolicySatisfaction — int
  • EventImpact — int