Database schema design

Facility

• id - integer, primary_key
• type - string (meeting_room, lecture_theatre)
• name - string (variable-length)

Availability

• facility_id - reference_key
• day - enum (7 days)
• start_time - time
• end_time - time

Booking

• id - integer, primary_key
• facility_id - reference
• start_time - datetime
• end_time - datetime

Monitor

• facility_id - reference_key
• address - string
• port - integer
• start_time - datetime
• end_time - datetime