wiki:KLPWWWDonateVolunteer

KLP WWW Donate / Volunteer Flow

  1. Donate / Volunteer User Registration
    • Login / Logout
    • Reset Password
    • Validate Email Address
    • Settings
  1. Donate / Volunteer Search
    • Search Schools
    • Search Things / Activities
  1. Donate / Volunteer Notifications
  1. Donation attributes
    • School
    • Things
    • Partner
  1. Volunteer Attributes
    • School
    • Partner
    • Activity
    • Time
    • Date
    • Duration
  1. Donation Admin States
    • Donation Required
    • Donation Pending (Donor Responded)
    • Donation In-Progress (Donation collected from Donor)
    • Donation Complete (Donation has been received)
    • Donation Failed (No Reponse)
  1. Volunteer Admin States
    • Volunteer Required
    • Volunteer Signup (Volunteer Responded)
    • Volunteer Completed
    • Volunteer Failed (Volunteer signed up but did not turn up)
  1. Other Miscellaneous things
    • Handle Anonymous
    • Show Donations on School Page
    • Show counts on some other pages
  1. Types of Category
    • Skills based
    • Activity based
    • Teaching based

Database schema

User

User Id Username Password Validated Settings
Auto-incremented number email sha1 hash Boolean TBD

Partner

Partner Id Partner Name Partner address
Autoincremented number Text Text

Category

Category Id Category Name
Autoincremented number Text

School

School ID School name School Address Other attributes
KLP ID Text Text TBD

Donation

School ID Partner ID Donation State Anonymous
Foreign Key Foreign Key See Above No.6 (Foreign Key) Boolean

Volunteer

School ID Partner ID Activity Time Duration Date Start Category Volunteer State Volunteer ID
Foreign Key Foreign Key Text Number (hrs) Number (days) Date Foreign Key See Above No. 7 Foreign Key
Last modified 4 years ago Last modified on 06/06/14 11:54:55