Database version 2

Back to Databases

The database had now got to change as it was no longer an emailing system, as I had exported all the records into Mailchimp. At this point I had to change the structure of the database because of it's complexities and preparing it to be a mailing database. I also redesign the site. To keep the history of the emailing system, I kept this, and introduced a new grouping system. Currently the live system holds 110,000 member records.

structure

Database tables

login

Login screen

mainscreen

Main screen

member

Member screen

memberupdate

Update members

group

Add/Edit/Delete Groups to member record

incident

Add/Edit/Delete incidents/contact responses to the member record

incidentupdate

Edit members incidents

giving

Add/Edit/Delete members giving record

givingupdate

Edit members giving record

Other features