Anytime I am unsure what the value will be, I go with varchar.
Varchar can be up to 255 characters.
I use Datetime because it gives a more precise measure.
The rest I will leave for someone more experienced with MySQL as I am not sure of the answers.
|