booking
bookingID INT(11)
arrival_date DATETIME
departure_date DATETIME
people INT(11)
facilityName VARCHAR(45)
customer_customerID INT(11)
room_roomNum INT(11)
Indexes
customer
customerID INT(11)
membership TINYINT(4)
firstname VARCHAR(45)
lastName VARCHAR(45)
dob VARCHAR(45)
street VARCHAR(45)
apt VARCHAR(45)
city VARCHAR(45)
state VARCHAR(2)
zip VARCHAR(5)
email VARCHAR(45)
tel INT(11)
memberPass VARCHAR(45)
Indexes
room
roomNum INT(11)
type VARCHAR(45)
rate DOUBLE
availability TINYINT(1)
Indexes
staff
employeeID INT(11)
lastName VARCHAR(45)
firstname VARCHAR(45)
position VARCHAR(45)
username VARCHAR(45)
possword VARCHAR(45)
Indexes