DataBase Confusion

[artisticre]

I am trying to create a timesheet for my personal use for lunches. It has an employee table with employee name and number. I want to track when employees sign in and out for lunch as well as the the day. It needs a table for Monday - Friday and Time In, Lunch Out, Lunch In, Time Out. I can't figure out how to relate these tables so when the employee ID is pulled up there is a table to enter their time each day. Can someone help me with this?

thanks so much

[devinemke]

i suggest 2 tables

employees
employee_id (INT) PK
name (VARCHAR)

times
time_id (INT) PK
employee_id (INT) relates to employees table
shift_in (DATETIME)
shift_out (DATETIME)
lunch_in (DATETIME)
lunch_out (DATETIME)

[artisticre]

Thank you for the help. What I am looking for is for the employee to be able to pull up the time card based on the day of the week. Do I need another table for days of the week ie monday, tuesday....

thanks again

[devinemke]

Originally posted by artisticre
Do I need another table for days of the week ie monday, tuesday....

no. the DATETIME type stores a complete YYYY-MM-DD HH:MM:SS date.