title: Structure Database employee leave (vacation) customizable per day of a whole year
body: <p>For a project I need to build a vacation management system where Business and Employee can ask/give/accept vacation day + see how many days there are left etc.</p>
  
  <p>The problem that I have, people work irregular. So sometimes saturday, etc. So I want to make basic schedule profiles and also let businesses be able to customize each day of the whole year.</p>
  
  <p>How do I structure the Database Tables?</p>
  
  <p>Do I add all the days from each year? O do I make a colum with the data?</p>
  
  <p>Could somebody help me with this issue? </p>