What sort of schema can I use to accommodate manual date based data entries?
Posted
by meder
on Stack Overflow
See other posts from Stack Overflow
or by meder
Published on 2010-06-09T16:24:31Z
Indexed on
2010/06/09
18:32 UTC
Read the original article
Hit count: 158
I have an admin where users from multiple properties can enter in monthly statistics for twitter/facebook followers. We do not have access to the real data/db so this is why a manual entry. The form looks like this:
Type ( radio, select **one** only ):
- Twitter
- Facebook
Followers/Fans ( textfield ):
Property (dropdown): Hotel A, Hotel B
Date Start: mm/dd/yyyy (textfield)
Date End: mm/dd/yyyy (textfield)
Question 1.1: Since I am only keeping track of month per month, the date start/end fields which I have already created might be too specific. Would it be a better idea just to have a start month/year and and month/year if that's the only thing I care about?
Question 1.2: What schema could I use for month to month statistics if I were to change the date start and end textfields to start month/year and end month/year dropdowns?
© Stack Overflow or respective owner