Adding Tables

 

Now, we are ready to add tables to our database. We need to add four tables: members, pending_terminations, rooms and bookings.

 

members

 

The members table has five columns:

 

id

This column stores the id of each member. The id is alphanumeric (VARCHAR(255) will be a good choice) and uniquely identifies each member (in other words, it is a primary key).

 

password

This column stores the password of each member. It is alphanumeric and cannot be null.

 

email

This column stores the email of each member. It is also alphanumeric and cannot be null.

 

member_since

This column stores the timestamp (consisting of the date and time) that a particular member is added to the table. It cannot be null and uses the NOW() function to get the current date and time as the DEFAULT value.

 

payment_due

This column stores the amount of balance that a member has to pay. The amount is in dollars and cents (e.g. 12.50). The column...