How to save table as a history in SQLITE

I want to build an application which will produce the shifts of the employees in a company.It's my first time, where I use a DB (SQLITE) and I have some worries how to organize my DB. Till now, in my DB I have 2 tables:

EMPLOYEES

surname | name | id

DAILY_SHIFT

id | shift

How can I save the DAILY_SHIFT for all the days? I thought to make a new table HISTORY_SHIFTS where I will have these 2 fields and an extra for date. But I think that the table after a month will have 1200 records... Is this a good solution or there is a better?