OSEV Database
Entity Relationship Diagram
v0.6.1 2020-04-15
OSEV Check
Address
AddressLine1:String
OSEVApplicant
AddressLine2:String
City:String
OSEV Web Application
  IdentityProviderSubject:String
State:String
  VoterToken:String
Country:String
DateRegistered:DateTime
Postcode:Int
Firstname:String
Lastname:String
DateOfBirth:Date
CountryWhereVoting:String
No data persisted
Approval
Address:Address
Electorate:String
Email: String
ApplicantId:Long
IsApproved:Bool
IsDenied:Bool
Reason:String
ElectoralRollMatch
DateActioned:DateTime
  dateImported:DateTime
  VoterToken:String
Firstname:String
BallotPaper
Lastname:String
DateOfBirth:Date
  Electorate:String
Address:Address
RobsonRotationNumber:String
Electorate:String
BallotPaper:String
DateAdded:DateTime
OSEV Verify
OSEVApplicant
OSEV Vote Storage
  RegToken:String
VoteDownload
  VoterToken:String
Vote
  BallotPaper:String
DateDownloaded:DateTime
  VotedUsingOsev:Boolean
  DateSaved:DateTime
DownloadedBy:String
  RegToken:String
  EncryptedVote:String/Binary
  VoteFoundInvalid: DateTime
  VoteFoundDenied: DateTime
VoteSignature:String

---