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: 130

Filed under:
|
|

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

Related posts about sql

Related posts about mysql