Hello all,
I am using MySQL on Windows box for one of the project I am working on. My design for a Emplyee table is:
employee (id, first_name, last_name, hire_date, start_date, end_date, active_status....)
Active status = true if end_date is in future, else false
One of the functional requirement is that DB should automatically set active_status to false if end_date is in past AND set to true if end_date is in future.
Second is, archive all the records to a text file if they are 5 years old (derived from start_date).
I have no previous experience in doing this kinda stuff, I just know how to design a DB. How can I achieve these 2 functional requirements?
Thanks!