Table design for a Reminder/Scheduling program.

Hello Experts.  I already asked this question a  week ago but prematurely closed it.  In the attachment, are the proposed tables a good design for a scheduling program that offers the user several options for reminders?

Mike
Scheduler-Tables.pdf
missionarymikeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
chapmandewConnect With a Mentor Commented:
I think you're in good shape then...
0
 
chapmandewCommented:
How are you going to determine which groups you need to notify when things occur?
0
 
missionarymikeAuthor Commented:
I'm not sure what your asking.  Upon application startup, and if the user has selected the option, then the reminder screen will popup with the reminders in the next few days based on the preset parameters.  What groups are you asking about?
Mike
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
chapmandewCommented:
I guess Im just not familiar w/ what you're trying to do.  You have a SchedulerNotify table, which makes me think that you'll need to notify someone if something happens, but thereare no fields in your tables to capture who you'd need to notify, such as email addresses, phone numbers, etc.  You know what I mean?
0
 
missionarymikeAuthor Commented:
No specific user.  I had thought, based on a previous question, that a notify table would be used to create a list of current reminders and then once it is acknowledged/completed it is automatically removed from the notify table and a permanent entry is added on the log table.  This was somebody elses idea.  If you have a cleaner/ more efficient way, then I am all ears.
The program does not have users, just the main program user.
Mike
0
 
chapmandewCommented:
if you give me a decent description of how you want the system to work, I can give you some ideas
0
 
missionarymikeAuthor Commented:
I would like the user to be able to setup a reminder for:
1. A one-time event
2. Recurring events --> daily, weekly, bimonthly, monthly, quarterly, and yearly.
The user can set a parameter "SchedulerNumberOfDaysBefore" on each reminder that will be used to notify the user on startup.  I need the reminders to keep appearing on each startup untile the user clicks a checkbox/datagrid cell, and confirms the items are complete or acknowledged.
Mike
0
 
missionarymikeAuthor Commented:
Thanks.  Sorry for closing this so late.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.