Room Bookings Database

The SISfm Room Bookings database has the following structure:

Boolean fields can be of Boolean data type (in Microsoft Access), or of integer data type with value -1 representing True.

The book_group, book_user and book_tab tables must be populated manually, based on the supplied example database.

The book_rm_include table controls which rooms are listed under each tab on the Booking List page, and must be populated manually as follows:

The book_index and book_archive tables are maintained by the Room Bookings module and should not normally be otherwise updated.

The following describes each table:

 
book_user
group_id User group ID.
identifier User email address for a booking approver group, otherwise a match is made with the email address, with the ADS login name or with the access security groups for the logged in user.
 
book_group
group_id User group ID.
group_name A rm.loc_code or site.site_code to identify approval scope, if this is a booking approver group.
group_type Use the value dist to identify a booking approver group.
 
book_tab
tab_id Tab identifier for tabs on the Booking List page.
group_id Tab user group ID.
tab_name Tab name.
sequence_number Tab sequence number, defines order of tabs.
 
book_rm_include
tab_id Tab identifier for tabs on the Booking List page.
loc_code A rm.loc_code or site.site_code.
include Boolean indicating whether a room is currently available for bookings.
 
book_index
ID Unique booking identifier. Must be the autonumber data type if BookAutoNumber is TRUE.
groupID Booking group identifier, identifies a set of recurring bookings.
meetingTitle User defined booking title.
loc_code Location code of the room booked.
dateBooked Date on which the booking was made.
bookingDate Date of the booking.
timeIntervalStart Start time of the booking, in 15 minute units.
timeIntervalEnd End time of the booking, in 15 minute units.
weekDay Day of the week, where 1 is Monday, etc.
approval Boolean indicating whether the booking has been approved.
valid Boolean indicating whether the booking is free of clashes.
adsName Booking person's ADS login name.
firstname Booking person's first name.
lastname Booking person's last name.
phone Booking person's telephone extension.
email Booking person's email address.
 
book_archiveThe same as book_index except:
ID Non-unique booking identifier.