I'm developing a Daily Time Record (timesheet) and I am trying to achieve this design:
My database structure is
id
user_id
log_date
log_type (e.g time-in,breakout,break-in,time-out)
log_time
I can generate the data but I can't seem to add the rows that have no entries.
Make all your columns
null
by default through migration or manually in DB except your primary key and foreign key.