Fandom

How To Wiki

How to make a personal performance tracker

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

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.

IntroductionEdit

StepsEdit

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.

3.

TipsEdit

Also on Fandom

Random Wiki