user_date table???
Posted: Fri Jan 30, 2009 12:03 pm
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!
Thank you for enlightening me!
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.