Next / Previous / TCC analysis homepage / Site map / NM Tech homepage

TCC analysis web: SingleMeeting

Tech Computer Center logo
Model SingleMeeting ( idNo, buildingName, roomNo, startTimestamp, endTimestamp, eventId, recurringId )
Description Represents a reservation of a single compact block of time in a specific room.
Additional id's An alternate key is (buildingName, roomNo, startTimestamp, endTimestamp). This key allows us to find all the bookings for a given room in chronological order.
idNo A unique identifier for this meeting. Domain: positive integers.
buildingName Name of the building containing this room. Domain: same as Building.name.
roomNo The room ``number'', which may contain non-numeric characters (e.g., room 101A). Domain: same as Room.roomNumber.
startTimestamp Start date and time of the reserved interval. Domain: timestamp.
endTimestamp Ending date and time of the reserved interval. Domain: timestamp. Note that this should be 50 minutes after the start time for a ``one-hour'' lecture, to give people a change to change over to the following class.
eventId Identifies for what event this booking has been made. Domain: same as Event.eventId; link to Event.
recurringId If this meeting is one of a set of recurring meetings, this field links to a RecurringMeeting. Domain: same as RecurringMeeting.recurringID, may be null.

See also: Room reservation system analysis
Previous: SemesterBreak
Site map
Help: New Mexico Tech Computer Center: analysis homepage
TCC homepage: New Mexico Tech Computer Center
NMT homepage: New Mexico Tech

John Shipman, tcc-doc@nmt.edu

Last updated: 2001/02/03 21:12:24
URL: http://www.nmt.edu/tcc/sa/rcal/single_meeting.html