Hi Friends,
I am practicing apex (im just a beginner) :)
I am making an attendace system.
Say I have a page with botton (in) and (out)
Each employee will be given a userid in apex and the sytem will capture the userid and sysdate and the
time in/out button.
My question is, how do I construct my table? to have a good data design.
Is it this one:
Emp_Attendance1
userid varchar2(30)
in date
out date
or this one:
Emp_Attendace2
userid varchar2(30)
login_type number(1) value 1 or 2 => as (in out)
timestamp date
Or is there a pre-created sample apps for employee attendance system available here?
Or can you share me your design too :D
Thanks a lot