King Klown Logo
King Klown& KOA

Konsultations

Konsultations (Public Consultations & Feedback) — sub‑module under ethiKos.
Implements five core services with stable code‑names, backed by consultation/suggestion/vote/result/impact models and frozen routing/analytics invariants.


1) Functional Services (and expected files)

Code‑names map 1:1 to Django service modules; file names follow the services/<code_name>.py convention.

Display nameCode name / servicePurpose / behaviorLikely file or module
Public Consultationspublic_consultationCreate and run time‑boxed civic consultations (setup, schedule, close).services/public_consultation.py
Citizen Suggestionscitizen_suggestionIntake pipeline for user‑proposed ideas/amendments feeding into consultations.services/citizen_suggestion.py
Weighted Voting (EkoH)weighted_consultation_voteCast ballots with optional EkoH‑based weighting; aggregates to results.services/weighted_consultation_vote.py
Results Visualizationconsultation_result_visualizationCompute/serve KPIs and breakdowns for dashboards.services/consultation_result_visualization.py
Impact Trackingimpact_trackingLog follow‑up actions and implementation status for adopted proposals.services/impact_tracking.py

2) Backend functionalities


3) Database models (OLTP)

Actual tables implemented for Konsultations.

Table / ModelPurposeKey fields
ConsultationA consultation instance (time‑boxed).id, title, open_date, close_date, status (ENUM)
CitizenSuggestionUser‑submitted ideas tied to a consultation.id, consultation (FK), author (FK), content
ConsultationVoteBallots with raw and EkoH‑weighted values.id, user (FK), consultation (FK), raw_value, weighted_value
ConsultationResultAggregated outcomes (snapshot).id, consultation (FK), results_data (JSONB)
ImpactTrackPost‑consultation action log.id, consultation (FK), action, status, date

4) Supporting configuration (frozen)


5) Routes & ownership


6) Integration points


7) Realtime & ops


Summary
Konsultations provides time‑boxed consultations, suggestion intake, EkoH‑weighted ballots, and transparent result snapshots through five services (public_consultation, citizen_suggestion, weighted_consultation_vote, consultation_result_visualization, impact_tracking). Data persists in Consultation, CitizenSuggestion, ConsultationVote, ConsultationResult, and ImpactTrack; routing is fixed at /consult, and analytics integrate with the platform’s Smart‑Vote ETL and dashboards.