help building tables

[youngboy84]

hi all this is my first post so hello.

I am tring to learn php and build a project that i will use. so this is my project.

basically i am building a work rota that has a sign up/sign in page and a members area.

so after you register and sign in you will go to a members area which will display your personal rota for the year.

i am still in the planing stage so go easy on me. What i need help with is how best to make tables for my project.

 

so far i have created a database called rota and a table called users with

1. id int

2. username varchar

3. password varchar

4. shift enum '1','2','3','4' (not sure if enum will work to choose shift????)

 

so for example i am shift 3 so my members area shiuld display a calender with red squares for day shift and blue for night for every month.

 

Mabey this is too hard for a beginner but i will try my best. ANY HELP AND criticisms WELCOME