Database

Back to databases

I created a bespoke database for the organisation to store subscribers details and have the ability to email them from the same database

login

Login security

home

Main screen

member

List members

userscreen

Add/Edit user screen

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


maingroup

Add/update/delete group

supergroup

Add/Update/view/delete supergroup. Supergroups are a group that contain groups. There are many group, and a supergroup was for the benefit of emailing, so we just pick the supergroup rather than lots of groups


supergroupedit

Add/update groups to the supergroup

email

Emailing screen. You can choose a template for the top of the email which is blurred. And who it is from. From this screen you can send, send a test, save and preview. When send is clicked each email is sent and checked to see if it is sent successfully. If not then it can be resent from a different screen. Everything is logged in a MySQL table. Also a logged is created to who opens the email


failed

Failed deliveries

saved

Saved email. Click on edit takes you to the email send screen

Other features