How To Wiki

How to make a personal performance tracker

1,795pages on
this wiki
Add New Page
Add New Page Talk0



1. Use MySQL or other DBMS to create a table named performances with fields: id, hour process_id, unit_id, qty In this table, the id is the autoincrement; the hour is for unix hour, i.e., unix seconds / 3600, so every unique hour with some activity in your life can be tracked. The process_id is the id of the process to be tracked, and shown as a text. The unit_id is the id for the units used, and also shown as a text.

In order to show the records of these two fields as a text, we need 2 tables: processes and units, however, in order to know the units defined for each process, we need a mapping process_unit table, which allowed us to map process names with their units.

2. Create tables: processes, units, and process_unit.



Also on Fandom

Random Wiki