Hi everyone,

I just wanted to make sure that I am not making something more complicated then it has to be.

I am working on a time clock application to use at my company, and so far, I have a login table, and with a foreign key that links to the time table. The thinking being, that when someone logs in, they get assigned there employee number, and then it adds a new record for that employee ID.

All I will be doing with the info, is grabbing the total amount of time they were clocked in for each day, and then totaling for the week.

I'm planning on using timestamps to store the actual time, hopefully making the math part easier :)

Do I need the foreign key and the 2 tables? Or should I just add the column's into the database since it will be for a small company?

Ideas? Suggestions?

Thanks!


--

Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
11287 James St
Holland, MI 49424
www.raoset.com
[EMAIL PROTECTED]





--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to