Search code examples
mysqlnaming-conventions

Semantics of naming a MYSQL timestamp column

I need a MySQL table that represents this data:

  • Feb 12, 5:00pm - Verdasco VS Monfils
  • Feb 12, 9:25pm - Sampras VS Hewitt
  • Feb 13, 8:15am - Nishikori VS Del Potro

I wanted to name the time column time, timestamp, or date, but as you know, those are all reserved keywords. What is the best way to name a time column without purposely sounding cheesy to get around the naming limitations?

Solution

  • What is Verdasco VS Monfils? Are they events? Then I would go with EventDate or something similar. Try to name it of how you would describe it.