user_date table???

Discussion for TimeTrex open source community developers.
Locked
jreade
Posts: 27
Joined: Wed Dec 17, 2008 1:42 pm

user_date table???

Post by jreade »

What is the user_date table for? I don't think I understand how it relates exactly to the other tables.

Thank you for enlightening me!
mikeb
Posts: 709
Joined: Thu Jul 27, 2006 11:58 am

Post by mikeb »

The user_date table is used by several other tables to relate rows to dates, users, and pay periods.

Rather then have user, date, pay_period columns in many tables, we normalized those out to the user_date table and relate them by the user_date_id column.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
Locked