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