Map tables to save access history

0

I have an application, which I need to save at least once a day, the date and time that the user accessed the application / system. Because we charge at the end of the month for the number of days that the app / software used.

What is the best way to map this table?

    
asked by anonymous 30.07.2017 / 18:16

1 answer

0

I believe that for this you can create a very simple table with the columns:

  • User ID you are accessing
  • date and time.

In some applications that I create, I usually separate the date column into two columns, one with the date only and the other with hours and minutes, so it makes it easier for some queries.

There is no better way to map a table but rather a better way that will suit your application.

    
02.08.2017 / 14:31