At my company we have a set of things that need to be checked, run, sent out, etc., every morning. I'm currently trying to design a database to manage the log of these items but I'm not sure how to design it. Here's what I've currently setup that I'm doubting.
There are 3 tables: tbl_Log, tbl_LogItems and tblNotes.
tbl_LogItems consists of columns ID and LogItem and each entry is one of the items to check every day (34 in total so far)
tbl_Log's columns are EntryDate and then 34 columns where each is one of the items to check. Each entry is the status of each item for that day.
tbl_Notes's columns are ID, Note, EntryDate and LogItem. Where EntryDate has a 1 to many relationship with EntryDate from tbl_Log and LogItem has a 1 to many relationship LogItem from tbl_LogItems.
This design doesn't feel right to me, but the only problem I see is that I have to independently maintain the columns of tbl_Log and the rows of tbl_LogItems even though they're the same thing.
I hope that's not too confusing.
Thanks.