Skip to content

Database

Jump to bottom
David Roodt edited this page May 10, 2022 · 14 revisions

Version 1

image

User table

  • UserID - auto generated unique ID for all users
  • email - Email user used to sign up with
  • Password - Encrypted Password stored in DB
  • PasswordSalt - Salt used to encrypt Password

Organisation table

  • UserID - ID used to link Organisation info to User info
  • OrgName - Name of the Organisation
  • NGONum - NGO number for certified NGO's
  • Description - Description of Organisation

Rating table

  • OrgID - UserID of Org that is receiving a rating
  • ClientID - UserID of Client giving the rating
  • Rating - Numeric rating
  • Comment - Comment left by Client about Organisation in review
Clone this wiki locally