Forum Discussion

WilliamWallace's avatar
WilliamWallace
Qrew Member
4 years ago

How should I structure my tables?

Hi All,
I'm going to start my very FIRST! app. It will be an Employee tracking app, but my problem I am trying to figure out is, I have hundreds of employees in 6 different geo locations and several job types on different shifts. 

Should I create a tables for Employees in each location? (i.e. LA, Boston, Etc.) or 1 Employee table with Name, Job, Location, Etc.?

Thanks in advance for your guidance!

------------------------------
William Wallace
------------------------------
  • One table of employees!  ..  with a multiple choice field to indicate the location.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
  • One table of employees!  ..  with a multiple choice field to indicate the location.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • WilliamWallace's avatar
      WilliamWallace
      Qrew Member
      Thanks for the insight Mark!

      ------------------------------
      William Wallace
      ------------------------------