Skip to content

Database

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

Version 4

Schema

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
  • Identity - Stores whether a user is a, Client, Org or Admin

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
  • Profile Picture - Picture for Org. Stored as Base64
  • DateCreated - When the Org signed up for the site

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

DonoItem table

  • ItemName - Name of Item
  • OrgID - UserID of Org that has this item
  • Quantity - Amount of Item currently in the Organisation's inventory
  • Description - Short Description of Item
  • Quality - The quality of Item (New, Used)
  • Type - The Type of Item (Food, Clothes)
  • DonoDate - Date of Donation
  • DonoLoc - Location of Donation

Delivery table

  • DeliveryID - Unique ID for delivery
  • ItemID - ItemID of Item that has this item
  • OrgID - UserID of Org that has this item
  • Quantity - Amount of Item currently in the Organisation's inventory
  • Description - Short Description of Item
  • Quality - The quality of Item (New, Used)
  • Type - The Type of Item (Food, Clothes)
  • DonoDate - Date of Donation
  • DonoLoc - Location of Donation
Clone this wiki locally