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.
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...