db schema

schema.rs

table! {
    elections(id) {
        id -> Integer,
        title -> Text,
        draft -> Bool,
        created_at -> Timestamp,
        started_at -> Timestamp,
        finished_at -> Timestamp,
    }
}

table! {
    ballots(ballot_id) {
        ballot_id -> Integer,
        created_at -> Timestamp,
        user_id -> Integer,
        election_id -> Integer,
        preference -> Interger,
        candidate_id -> Interger,
    }
}

table! {
    users(id)  {
        id -> Integer,
        user_name -> Text,
    }
}

table! {
    candidates(id) {
        id -> Integer,
        name -> Text,
        password -> Text,
    }
}

joinable!(users -> ballots(id));
joinable!(elections -> ballots(id));
joinable!(candidates -> ballots(id));

allow_tables_to_appear_in_same_query!(elections, ballots, candidates, users);