DATA_MODEL.md

April 21, 2026 Β· View on GitHub

Hack23 Logo

πŸ“Š Citizen Intelligence Agency β€” Data Model

πŸ—ƒοΈ Comprehensive Data Architecture for Political Transparency
🎯 Entity Relationships, Political Data Structures, and Parliamentary Data Modeling

Owner Version Effective Date Review Cycle

πŸ“‹ Document Owner: CEO | πŸ“„ Version: 1.1 | πŸ“… Last Updated: 2026-04-20 (UTC)
πŸ”„ Review Cycle: Annual | ⏰ Next Review: 2027-04-20 🏷️ Classification: Public (Open Civic Transparency Platform)


🎯 Purpose

This document provides a comprehensive view of the data model that powers the Citizen Intelligence Agency platform. It outlines the key data structures, relationships, and organization that enable parliamentary monitoring, political analysis, and transparency.

DocumentFocusDescriptionDocumentation Link
ArchitectureπŸ›οΈ ArchitectureC4 model showing current system structureView Source
Future ArchitectureπŸ›οΈ ArchitectureC4 model showing future system structureView Source
Mindmaps🧠 ConceptCurrent system component relationshipsView Source
Future Mindmaps🧠 ConceptFuture capability evolutionView Source
SWOT AnalysisπŸ’Ό BusinessCurrent strategic assessmentView Source
Future SWOT AnalysisπŸ’Ό BusinessFuture strategic opportunitiesView Source
Data ModelπŸ“Š DataCurrent data structures and relationshipsView Source
Future Data ModelπŸ“Š DataEnhanced political data architectureView Source
FlowchartsπŸ”„ ProcessCurrent data processing workflowsView Source
Future FlowchartsπŸ”„ ProcessEnhanced AI-driven workflowsView Source
State DiagramsπŸ”„ BehaviorCurrent system state transitionsView Source
Future State DiagramsπŸ”„ BehaviorEnhanced adaptive state transitionsView Source
CI/CD WorkflowsπŸ”§ DevOpsCurrent automation processesView Source
Future WorkflowsπŸ”§ DevOpsEnhanced CI/CD with MLView Source
End-of-Life StrategyπŸ“… LifecycleMaintenance and EOL planningView Source
Financial Security PlanπŸ’° SecurityCost and security implementationView Source
CIA FeaturesπŸš€ FeaturesPlatform features overviewView on hack23.com
Threat ModelπŸ›‘οΈ SecurityData integrity & abuse threat mappingView Source
Security ArchitectureπŸ›‘οΈ SecurityDefense-in-depth security overviewView Source
CRA AssessmentπŸ›‘οΈ ComplianceEU Cyber Resilience Act conformityView Source
Business Continuity PlanπŸ“‹ ResilienceRTO/RPO targets and recovery proceduresView Source
Business Product DocumentπŸ’Ό BusinessData analytics and risk intelligence productsView Source

🧩 Core Data Model Overview

The Citizen Intelligence Agency platform is built on a robust data model that integrates political data from multiple sources into a unified analytical framework. The data model reflects three primary domains:

erDiagram
    ParliamentaryData {
        string id
        string documentType
        string status
        date createdDate
        string title
    }
    
    PoliticalEntities {
        string id
        string firstName
        string lastName
        string party
        int bornYear
        string gender
    }
    
    AnalyticalOutput {
        string metricType
        float scoreValue
        date analysisDate
        string description
    }
    
    ParliamentaryData ||--o{ PoliticalEntities : "references"
    PoliticalEntities ||--o{ AnalyticalOutput : "generates"
    ParliamentaryData ||--o{ AnalyticalOutput : "informs"

πŸ“Š Political Entities Data Model

πŸ‘€ Person Focus: Illustrates the structure of political persons (politicians) and their relationships to parties, committees, and other entities.

πŸ›οΈ Organization Focus: Shows how political organizations are modeled and their relationships within the system.

classDiagram
    class Person {
        +string id
        +string firstName
        +string lastName
        +string party
        +int bornYear
        +string gender
        +string status
        +string electionRegion
        +PersonAssignment[] assignments
        +PersonDetail[] details
    }
    
    class PersonAssignment {
        +string assignmentType
        +string detail
        +date fromDate
        +date toDate
        +string orgCode
        +string roleCode
        +string status
    }
    
    class PersonDetail {
        +string code
        +string detail
        +string detailType
    }
    
    class Party {
        +string id
        +string name
        +string shortCode
        +date registeredDate
        +string website
    }
    
    class Committee {
        +string orgCode
        +string detail
        +boolean active
        +date firstAssignmentDate
        +date lastAssignmentDate
    }
    
    class Ministry {
        +string nameId
        +long totalAssignments
        +date firstAssignmentDate
        +date lastAssignmentDate
    }

    Person "1" *-- "many" PersonAssignment
    Person "1" *-- "many" PersonDetail
    Person "many" -- "1" Party
    PersonAssignment "many" -- "many" Committee
    PersonAssignment "many" -- "many" Ministry

πŸ“‘ Parliamentary Document Data Model

πŸ“„ Document Focus: Illustrates the structure of parliamentary documents and their relationships.

πŸ”„ Process Focus: Shows how documents flow through the parliamentary process.

classDiagram
    class DocumentData {
        +string id
        +string documentType
        +string title
        +string subTitle
        +string status
        +date madePublicDate
        +string org
        +string rm
        +string label
    }
    
    class DocumentContent {
        +string id
        +string content
    }
    
    class DocumentStatus {
        +string documentCategory
        +string documentId
    }
    
    class DocumentDetail {
        +string code
        +string detailName
        +string text
    }
    
    class DocumentPersonReference {
        +int orderNumber
        +string personReferenceId
        +string referenceName
        +string roleDescription
        +string partyShortCode
    }
    
    class CommitteeDocument {
        +string id
        +string label
        +string title
        +string org
        +string status
        +date createdDate
        +date publicDate
    }
    
    class CommitteeProposal {
        +string header
        +string proposal
        +string decisionType
        +string committeeReport
        +string winner
    }

    DocumentData "1" -- "0..1" DocumentContent
    DocumentData "1" -- "1" DocumentStatus
    DocumentStatus "1" *-- "many" DocumentDetail
    DocumentStatus "1" *-- "many" DocumentPersonReference
    CommitteeDocument "1" -- "many" CommitteeProposal

πŸ—³οΈ Voting Data Model

πŸ—³οΈ Vote Focus: Illustrates the structure of voting data from parliamentary sessions.

πŸ“Š Analysis Focus: Shows how vote data is organized to enable analytical insights.

classDiagram
    class VoteData {
        +string ballotId
        +string concern
        +string intressentId
        +string issue
        +string ballotType
        +string vote
        +date voteDate
        +string party
        +string firstName
        +string lastName
        +int bornYear
        +string gender
    }
    
    class BallotSummary {
        +string ballotId
        +string concern
        +string issue
        +boolean approved
        +int yesVotes
        +int noVotes
        +int absentVotes
        +int abstainVotes
        +float avgBornYear
    }
    
    class PartyBallotSummary {
        +string ballotId
        +string concern
        +string issue
        +string party
        +boolean approved
        +int partyYesVotes
        +int partyNoVotes
        +int partyAbsentVotes
        +int partyAbstainVotes
        +float partyAvgBornYear
    }
    
    class PoliticianBallotSummary {
        +string ballotId
        +string concern
        +string intressentId
        +string issue
        +string vote
        +boolean won
        +boolean rebel
        +string party
    }

    VoteData "many" -- "1" BallotSummary
    BallotSummary "1" -- "many" PartyBallotSummary
    BallotSummary "1" -- "many" PoliticianBallotSummary

🌍 External Data Sources Model

🌐 Integration Focus: Illustrates the structure of data from external sources like World Bank.

πŸ”„ Standardization Focus: Shows how external data is standardized for platform integration.

classDiagram
    class WorldBankData {
        +string countryId
        +string countryValue
        +string indicatorId
        +string indicatorValue
        +string dataValue
        +int yearDate
    }
    
    class Indicator {
        +string id
        +string indicatorName
        +string sourceId
        +string sourceValue
        +string sourceNote
        +string sourceOrganization
    }
    
    class Country {
        +string id
        +string countryName
        +string regionId
        +string regionValue
        +string capitalCity
        +string latitude
        +string longitude
    }
    
    class Topic {
        +string id
        +string value
    }

    WorldBankData "many" -- "1" Country
    WorldBankData "many" -- "1" Indicator
    Indicator "many" -- "many" Topic

πŸ—„οΈ Electoral Data Model

πŸ—³οΈ Election Focus: Illustrates the structure of electoral data from the Swedish Election Authority.

πŸ›οΈ Geographic Focus: Shows how electoral regions are organized within the system.

classDiagram
    class ElectionRegion {
        +string regionName
        +string countyId
        +string municipalId
    }
    
    class PoliticalParty {
        +string partyId
        +string partyName
        +string shortCode
        +date registeredDate
        +string website
    }
    
    class CountyData {
        +int code
        +string countyName
    }
    
    class MunicipalityData {
        +int code
        +string municipalName
    }
    
    class CountyElectoralRegion {
        +int code
        +string countyName
        +int seats
    }
    
    class CountyElectoralArea {
        +int code
        +string electoralAreaName
        +int numberOfSeats
        +int numberOfVoters
    }
    
    class ParliamentElectoralRegion {
        +string electionRegionName
        +int numberOfSeats
        +int numberOfVoters
    }
    
    class MunicipalityElection {
        +int code
        +string electionRegionName
        +int numberOfSeats
        +int numberOfVoters
    }

    ElectionRegion "1" -- "many" PoliticalParty
    CountyData "1" -- "many" MunicipalityData
    CountyElectoralRegion "1" -- "many" CountyElectoralArea
    CountyData "1" -- "1" CountyElectoralRegion
    MunicipalityData "1" -- "many" MunicipalityElection
    ElectionRegion "1" -- "0..1" CountyData
    ElectionRegion "1" -- "0..1" MunicipalityData

πŸ‘€ User and System Data Model

πŸ‘€ User Focus: Illustrates the structure of user accounts and session data.

πŸ”§ System Focus: Shows how system configuration and operation data is organized.

classDiagram
    class UserAccount {
        +string userId
        +string username
        +string userPassword
        +string email
        +string userRole
        +string userType
        +date createdDate
        +int numberOfVisits
    }
    
    class ApplicationSession {
        +date createdDate
        +date destroyedDate
        +string ipInformation
        +string userAgentInformation
        +string sessionId
        +string userId
    }
    
    class ApplicationActionEvent {
        +string actionName
        +string applicationOperation
        +date createdDate
        +string page
        +string pageMode
        +string elementId
        +string sessionId
        +string userId
    }
    
    class ApplicationConfiguration {
        +string component
        +string componentTitle
        +string configurationGroup
        +string propertyId
        +string propertyValue
        +date createdDate
        +date updatedDate
    }
    
    class Portal {
        +string portalName
        +string description
        +string portalType
    }
    
    class DomainPortal {
        +string domainName
    }

    ApplicationSession "1" -- "many" ApplicationActionEvent
    UserAccount "1" -- "many" ApplicationSession
    Portal <|-- DomainPortal

πŸ” Analytical Views Data Model

πŸ“Š Analytics Focus: Illustrates the structure of analytical views for political metrics.

πŸ“Š Performance Focus: Shows how performance metrics are calculated and stored.

classDiagram
    class PoliticianView {
        +string personId
        +string firstName
        +string lastName
        +string party
        +boolean active
        +int totalDocuments
        +int documentsLastYear
        +date firstAssignmentDate
        +date lastAssignmentDate
    }
    
    class PartyView {
        +string party
        +string partyName
        +boolean active
        +int totalDocuments
        +int documentsLastYear
        +int totalAssignments
    }
    
    class CommitteeView {
        +string orgCode
        +string detail
        +boolean active
        +int currentMemberSize
        +int totalAssignments
        +int totalDaysServed
    }
    
    class MinistryView {
        +string nameId
        +boolean active
        +int totalAssignments
        +int totalDaysServed
    }
    
    class PoliticianBallotSummaryView {
        +string personId
        +string firstName
        +string lastName
        +string party
        +float absenceRate
        +float loyaltyRate
        +float rebelRate
        +float successRate
        +int totalVotes
    }
    
    class PoliticianExperienceSummary {
        +string personId
        +string firstName
        +string lastName
        +string experienceLevel
        +string careerPhase
        +string specializationLevel
        +long totalDays
        +long committeeDays
        +long partyDays
    }

    PoliticianView "1" -- "0..1" PoliticianBallotSummaryView
    PoliticianView "1" -- "0..1" PoliticianExperienceSummary

πŸ”„ Data Flow Diagram

This diagram illustrates how data flows through the system from various sources to the analytical outputs and user interfaces.

flowchart TD
    A[External Data Sources] --> B{Data Integration}
    
    B -->|Parliamentary Data| C1[Parliament Data Processing]
    B -->|Electoral Data| C2[Election Data Processing]
    B -->|Economic Data| C3[World Bank Data Processing]
    
    C1 --> D1[Document Entities]
    C1 --> D2[Politician Entities]
    C1 --> D3[Vote Data]
    C1 --> D4[Committee Data]
    
    C2 --> D5[Party Entities]
    C2 --> D6[Electoral Region Data]
    
    C3 --> D7[Indicator Data]
    C3 --> D8[Country Data]
    
    D1 & D2 & D3 & D4 & D5 & D6 & D7 & D8 --> E[Data Storage]
    
    E --> F1[Analytical Processing]
    F1 --> G1[Performance Metrics]
    F1 --> G2[Voting Analysis]
    F1 --> G3[Document Analysis]
    F1 --> G4[Political Network Analysis]
    
    G1 & G2 & G3 & G4 --> H[Materialized Views]
    
    H --> I[Web Application]
    I --> J[User Interface]
    
    classDef sources fill:#bbdefb,stroke:#333,stroke-width:1px,color:black
    classDef integration fill:#a0c8e0,stroke:#333,stroke-width:1px,color:black
    classDef processing fill:#c8e6c9,stroke:#333,stroke-width:1px,color:black
    classDef entities fill:#d1c4e9,stroke:#333,stroke-width:1px,color:black
    classDef storage fill:#f8cecc,stroke:#333,stroke-width:1px,color:black
    classDef analytics fill:#fff2cc,stroke:#333,stroke-width:1px,color:black
    classDef views fill:#ffe0b2,stroke:#333,stroke-width:1px,color:black
    classDef application fill:#dcedc8,stroke:#333,stroke-width:1px,color:black
    
    class A sources
    class B integration
    class C1,C2,C3 processing
    class D1,D2,D3,D4,D5,D6,D7,D8 entities
    class E storage
    class F1 analytics
    class G1,G2,G3,G4 analytics
    class H views
    class I,J application

🧩 Key Database Tables

CategoryTable NameDescriptionPrimary KeysKey Relationships
πŸ‘€ Person DataPERSON_DATAPolitical person entitiesIDPERSON_ASSIGNMENT_DATA, PERSON_DETAIL_DATA
πŸ‘€ Person DataASSIGNMENT_DATAPolitical assignmentsHJIDPERSON_DATA (many-to-one)
πŸ“‘ Document DataDOCUMENT_DATAParliamentary documentsIDDOCUMENT_STATUS_CONTAINER
πŸ“‘ Document DataDOCUMENT_CONTENT_DATADocument contentHJID, IDDOCUMENT_DATA (one-to-one)
🏒 Committee DataCOMMITTEE_DOCUMENT_DATACommittee documentsIDCOMMITTEE_PROPOSAL_DATA
πŸ—³οΈ Vote DataVOTE_DATAParliamentary votesComposite (BALLOT_ID, CONCERN, INTRESSENT_ID, ISSUE)-
🌍 World BankWORLD_BANK_DATAEconomic indicatorsHJIDDATA_ELEMENT
🌍 World BankCOUNTRY_ELEMENTCountry dataHJIDCOUNTRIES_ELEMENT
πŸ—„οΈ Electoral DataSWEDEN_ELECTION_REGIONElectoral regionsHJIDSWEDEN_POLITICAL_PARTY
πŸ—„οΈ Electoral DataSWEDEN_POLITICAL_PARTYPolitical partiesHJIDSWEDEN_ELECTION_REGION
πŸ‘€ User DataUSER_ACCOUNTUser accountsHJIDAPPLICATION_SESSION
πŸ‘€ User DataAPPLICATION_SESSIONUser sessionsHJIDAPPLICATION_ACTION_EVENT
πŸ”§ System DataAPPLICATION_CONFIGURATIONSystem configurationHJID-

πŸ“Š Materialized Views for Analytics

The CIA platform uses materialized views to provide efficient access to analytical data. These views transform raw data into meaningful insights about political entities and activities.

View NamePurposeKey MetricsBase Tables
VIEW_RIKSDAGEN_POLITICIANPolitician profile metricsActivity levels, document counts, assignment historyPERSON_DATA, ASSIGNMENT_DATA
VIEW_RIKSDAGEN_PARTYParty performance metricsMember counts, document counts, activity levelsSWEDEN_POLITICAL_PARTY, related person tables
VIEW_RIKSDAGEN_COMMITTEECommittee activity metricsMember counts, document counts, assignment dataCOMMITTEE_DOCUMENT_DATA, related assignment tables
VIEW_RIKSDAGEN_POLITICIAN_BALLOT_SUMMARYVoting performanceLoyalty rate, rebel rate, success rate, absence rateVOTE_DATA
View_Riksdagen_Vote_Data_Ballot_SummaryVote outcome analysisYes/no percentages, absence rates, approval statsVOTE_DATA
view_riksdagen_politician_experience_summaryExperience analysisCareer phase, knowledge areas, leadership profileASSIGNMENT_DATA, PERSON_DATA

πŸ”„ Database Relationships

This diagram illustrates key relationships between major tables in the database:

erDiagram
    PERSON_DATA ||--o{ ASSIGNMENT_DATA : has
    PERSON_DATA ||--o{ PERSON_DETAIL_DATA : has
    DOCUMENT_DATA ||--|| DOCUMENT_STATUS_CONTAINER : has
    DOCUMENT_STATUS_CONTAINER ||--o{ DOCUMENT_DETAIL_DATA : contains
    DOCUMENT_STATUS_CONTAINER ||--o{ DOCUMENT_PERSON_REFERENCE_DA_0 : references
    COMMITTEE_DOCUMENT_DATA ||--o{ COMMITTEE_PROPOSAL_DATA : has
    VOTE_DATA }o--|| PERSON_DATA : cast_by
    USER_ACCOUNT ||--o{ APPLICATION_SESSION : has
    APPLICATION_SESSION ||--o{ APPLICATION_ACTION_EVENT : generates
    SWEDEN_ELECTION_REGION ||--o{ SWEDEN_POLITICAL_PARTY : contains
    SWEDEN_COUNTY_DATA ||--o{ SWEDEN_MUNICIPALITY_DATA : contains
    WORLD_BANK_DATA }o--|| COUNTRY_ELEMENT : relates_to
    WORLD_BANK_DATA }o--|| INDICATOR_ELEMENT : measures

πŸ“ˆ Data Flow for Analytics

πŸ”„ Process Focus: Illustrates how raw data is transformed into analytical metrics.

πŸ“Š Metrics Focus: Shows the key transformations that generate political insights.

sequenceDiagram
    participant DataSource as External Data Sources
    participant ImportService as Import Services
    participant Database as PostgreSQL Database
    participant Analytics as Analytical Processes
    participant Views as Materialized Views
    participant UI as User Interface
    
    DataSource->>ImportService: Raw Political Data
    ImportService->>ImportService: Transform & Validate
    ImportService->>Database: Store Normalized Data
    
    Database->>Analytics: Raw Entity Data
    Analytics->>Analytics: Calculate Metrics
    Analytics->>Database: Store Derived Metrics
    
    Database->>Views: Create/Refresh Views
    Views->>UI: Provide Analytical Data
    UI->>UI: Visualize & Present

πŸ’Ύ PostgreSQL Implementation

The CIA platform uses a PostgreSQL 18 database with the following extensions and capabilities:

Extensions

  • pgaudit β€” Audit logging for database operations
  • pgcrypto β€” Cryptographic functions
  • pg_stat_statements β€” Query performance monitoring
  • pgvector β€” Vector similarity search (for future AI embeddings)

Schema Statistics

  • 60+ base tables for entity storage
  • 110 database views (materialized and standard) for analytical queries (see DATABASE_VIEW_INTELLIGENCE_CATALOG.md)
  • Complex relationships modeled through foreign keys
  • Composite primary keys for many-to-many relationships
  • Audit and tracking capabilities through timestamp fields (enhanced by Javers 7.11.0 entity change tracking)
  • Large text fields for document content (up to 10MB)
  • Enumerated types for categorization

ORM & Data Access

  • Hibernate 5.6.15.Final with JPA 2.x for object-relational mapping
  • Hibernate Search 6.2.4.Final with Lucene 8.11.4 for full-text search
  • Liquibase for schema version control (see LIQUIBASE_CHANGELOG_INTELLIGENCE_ANALYSIS.md)
  • Javers 7.11.0 for entity auditing and temporal queries

Schema Maintenance

Schema updates are managed via Liquibase changesets. The full_schema.sql file in service.data.impl/src/main/resources/ is regenerated from PostgreSQL 18 via pg_dump β€” never manually edited. See service.data.impl/README-SCHEMA-MAINTENANCE.md for procedures.

Schema Highlights

-- Political Person Entity
CREATE TABLE PERSON_DATA (
    ID varchar(255) NOT NULL,
    BORN_YEAR int4,
    ELECTION_REGION varchar(255),
    FIRST_NAME varchar(255),
    LAST_NAME varchar(255),
    GENDER varchar(255),
    PARTY varchar(255),
    STATUS varchar(255),
    PERSON_ASSIGNMENT_DATA_PERSO_0 int8,
    PERSON_DETAIL_DATA_PERSON_DA_0 int8,
    PRIMARY KEY (ID)
);

-- Parliamentary Vote Data
CREATE TABLE VOTE_DATA (
    EMBEDDED_ID_BALLOT_ID varchar(255) NOT NULL,
    EMBEDDED_ID_CONCERN varchar(255) NOT NULL,
    EMBEDDED_ID_INTRESSENT_ID varchar(255) NOT NULL,
    EMBEDDED_ID_ISSUE varchar(255) NOT NULL,
    BALLOT_TYPE varchar(255),
    VOTE varchar(255),
    VOTE_DATE date,
    PARTY varchar(255),
    FIRST_NAME varchar(255),
    LAST_NAME varchar(255),
    BORN_YEAR int4,
    GENDER varchar(255),
    PRIMARY KEY (EMBEDDED_ID_BALLOT_ID, EMBEDDED_ID_CONCERN, EMBEDDED_ID_INTRESSENT_ID, EMBEDDED_ID_ISSUE)
);

-- Political Performance View
CREATE TABLE VIEW_RIKSDAGEN_POLITICIAN_BALLOT_SUMMARY (
    PERSON_ID varchar(255) NOT NULL,
    ABSENCE_RATE float8,
    LOYALTY_RATE float8,
    REBEL_RATE float8,
    SUCCESS_RATE float8,
    TOTAL_VOTES int8,
    FIRST_NAME varchar(255),
    LAST_NAME varchar(255),
    PARTY varchar(255),
    PRIMARY KEY (PERSON_ID)
);

πŸ”„ Data Model Evolution

πŸš€ Future Focus: Shows how the current data model will evolve in line with the future architecture vision.

πŸ” Enhancement Focus: Illustrates the planned data model improvements.

timeline
    title Data Model Evolution Plan
    section Current Model
        Now : Core political entities
            : Comprehensive analytical views
            : Materialized view aggregations
            : Intelligence analysis views
    section Near Future (2026)
        2026 : AI analysis tables (ai_person_analysis, ai_document_analysis)
             : Vector embeddings via pgvector for semantic search
             : AI model audit trail
    section Mid-Term (2027–2028)
        2027-2028 : Knowledge graph entity relationships
                  : Cross-national parliament data schema
                  : Temporal event stream tables
    section Long-Term (2029+)
        2029+ : Policy impact simulation storage
             : Self-optimizing schema via AI
             : Federated political data exchange

🧩 Key Data Model Implementation Features

FeatureImplementationPurposeExamples
πŸ”‘ Entity TrackingUnique identifiersTrack entities across data sourcesPERSON_DATA.ID, DOCUMENT_DATA.ID
πŸ”„ Historical TrackingDate fieldsTrack changes over timeFROM_DATE, TO_DATE, CREATED_DATE
πŸ“Š Analytical AggregationMaterialized viewsPre-compute metrics for performanceVIEW_RIKSDAGEN_POLITICIAN, VIEW_RIKSDAGEN_PARTY
πŸ” Multi-dimensional AnalysisTime-based aggregation viewsEnable time-series analysis*_DAILY_SUMMARY, *_MONTHLY_SUMMARY, *_ANNUAL_SUMMARY views
🌐 External IntegrationStandardized entity mappingConnect with external data sourcesWorld Bank tables, riksdagen tables
πŸ‘€ User Behavior TrackingSession and event tablesTrack user interactionsAPPLICATION_SESSION, APPLICATION_ACTION_EVENT
πŸ”’ Security ImplementationUser account structuresManage authentication and authorizationUSER_ACCOUNT, EncryptedValue

This data model documentation provides a comprehensive view of the CIA platform's current data structures and relationships. It illustrates how political data is organized, analyzed, and presented to enable transparency and citizen engagement with political processes.

For more detailed information on specific entities, please refer to the Entity Model Documentation.


πŸ“‹ Document Control:
βœ… Approved by: James Pether SΓΆrling, CEO - Hack23 AB
πŸ“€ Distribution: Public
🏷️ Classification: Confidentiality: Public Integrity: High Availability: Moderate
πŸ“… Effective Date: 2026-04-20
⏰ Next Review: 2027-04-20
🎯 Framework Compliance: ISO 27001 NIST CSF 2.0 CIS Controls