Mr. Furxheir, R.M.W.
Group: admins
(1791 posts total)
(last post: November 24, 2007 - 15:07)
Citizen #20:
Martí- Paìr Furxhéir | Here are the DB tables for the voting system.
I haven't had time to document or comment it, but I thought you should know what the first draft looks like.
Like I said, I am trying to be as open and transparent as possible...
don't hesitate to ask question about what this means...
This is only for secret votes. Doesn't include PM election, SoS confirmation, Etc...
------ ELECTION TABLE -----------------------
ElectionNumber AUTOINDEX PRIMARY
Name text - For example : "Dean Election"
VoteType ENUM - Preferential / ClosedList / Referendum2Choices / Referendum3Choices
Office ForeignKey(OfficeType) Senate / Deputies / President / ProvincialLegislature / Governor /etc...
Province INT For provincial elections, such as Senator
StartDate Date - Scheduled start date
Duration int - ScheduledNumberofDays
Status : ENUM Pending/Running/Closed
Description text - Comment on the election, displayed on the vote form
SoS ForeignKey(Citizens) ID of the SoS running the election
-- CANDIDATES TABLE ---------
ElectionNumber INT ForeignKey(Election) - PK
CitizenNumber INT FK(Citizen) PK
CandidatePartyInitials tinytext FK(Registered Parties) - only for Deputy elections
BallotRank INT ( for deputy election. 0 for Senate / President / PM )
--- REGISTERED PARTIES TABLE -----
ElectionNumber INT ForeignKey(Election) - PK
PartyInitials TINYTEXT- PK
PartyName TEXT
PartyPlatform TEXT
PartyLogo TEXT - URL of the image
PartyRegistrant FK(citizens)
--- Vote ---- ( contains the actual vote )
ElectionNumber INT FK(Election) - PK
VoteKey text PK - SHA1 encoding of : PRIVATE_DB_KEY . CIT_NUMBER . VOTE . ELECTION_NUMBER . CIT_NON_ENCRYPTED_PASSWORD
Vote text / id of the citizen or of the party, or referendum value
Order by Vote
note : SHA1 : Non reversible encryption. Will be used for confirmation of a vote by the Cort should there be a
contestation. Can also be used by a citizen to confirm his vote was well entered.
To confirmt he vote, the citizen needs all the members of the Key execpt for the PRIVATE_DB_KEY,
which is automatically supplied.
That means that without the Citizen number, vote and non encrypted password, it is impossible to confirm the vote of a citizen.
It should provide adequate security.
-- VoteCensus -- ( contains WHO voted ).
ElectionNumber INT FK(Election) - PK
CitizenNumber PK
IPAddress text - IP address from which the citizen voted
UserAgent text - UserAgent of the computer from which the citizen voted ( type of OS, of Browser, etc... )
Order by CitizenNumber
Do you like my stupid hair?
Would you guess that I didn't know what to wear?
I'm just scared of what you think
You make me nervous so I really can't eat.
When you smile, I melt inside
I'm not worthy for a minute of your time
|
