Skip to content

Database

Jump to bottom
David Roodt edited this page May 24, 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

Version 2

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
  • Adress ID - ID of Address stored in Address table

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

Address table

  • AddressID - ID of Address for link to Organisation
  • Address - Address Line 1 of Address
  • Address2 - Address Line 2 of Address
  • City - City of Address
  • Province - Province of Address

Version 3

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
  • Adress ID - ID of Address stored in Address table

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

Address table

  • AddressID - ID of Address for link to Organisation
  • Address - Address Line 1 of Address
  • Address2 - Address Line 2 of Address
  • City - City of Address
  • Province - Province of Address

Item table

  • ItemName - Name of Item
  • OrgID - UserID of Org that has this item
  • Description - Short Description of Item
  • Quantity - Amount of Item currently in the Organisation's inventory
Clone this wiki locally