The structure of the database for the time sheet, how to store records of hours of work?

Question

PHP

Tell me how to correctly organize the database structure (SQLite) to store records of the number of hours worked by an employee on a particular day, including vacation, sick leave, business trip, etc.
Now there is only 1 sign with all the employees.
id,name,lastname,department
Понятно что нужна 1 таблица где будут храниться эти записи, то что 1 строка = 1 сотрудник. Но насколько правильно хранить в одной записи весь месяц сотрудника (json), или верным будет хранить:
Year,month,day,id_worker,hour,status
И так 1 запить = месяц, день, сотрудник, часов работы, статус.
Помогите дельным советом :)

Answer 1

year,month,day,id_worker,hour,status

Better this way
id_worker, date, cnt_hours, status
Any such non-standard solutions such as json in one field, mongo, etc. for VERY large amounts of data.
For an average project, it is much more important that 1-2 sql queries can pull out the necessary data.

Answer 2

everything is here https://tech.yandex.ru/maps/

Answer 3

You can even not write it yourself, but install the plugin using the same link https://tech.yandex.ru/maps/jsapi/#plugins