evmini draft of e-r diagram

evmini.uml

@startuml

title 
EVmini E-R diagram
Using CakePHP naming conventions.
endtitle

object candidacies {
    
    id INT
    user_id INT
    election_id INT
    office_id INT

}

object votes {

    id INT
    user_id INT
    candidate_id INT
    stance TINYINT
    comment_id INT
    
}

object users {

    id INT
    facebook_id INT
    name TEXT
    image TEXT

}

object constituencies {

    id INT
    name TEXT
    description TEXT
    
    parent_id INT
    lft INT
    rght INT

} 

object elections {

    id INT
    constituency_id INT
    name TEXT
    description TEXT
    startdate DATETIME
    enddate DATETIME
    
}

object constituents {

    id INT
    user_id INT
    constituency_id INT

}

object offices {

    id INT
    constituency_id INT
    name TEXT
    description TEXT
    term_start DATETIME
    term_end DATETIME
    
}

object comments {

    id INT
    user_id INT
    body TEXT
    date DATETIME

}


candidacies "1..*" -- "1" offices
candidacies "1..*" -- "1" users
candidacies "1..*" -- "1" elections

offices "1..*" -- "1" constituencies

constituents "1..*" -- "1" users
constituents "1..*" -- "1" constituencies

elections "1..*" -- "1" constituencies

votes "1..*" -- "1" candidacies
votes "1..*" -- "0..1" comments

comments "0..*" -- "1" users


@enduml