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:

To list all meeting rooms on a site, enter a row containing its Facility database site.site_code and identifying the tab on which to list them. For this case the include column is ignored. Meeting rooms are specified using the RoomClassMeeting setting.
To include a specific room, enter a row containing its Facility database rm.loc_code, identifying the tab on which to list them, and check the include column, this can be unchecked to remove the room if it is unavailable for some reason.

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_archive`		The same as `book_index`* except:*
`ID`		Non-unique booking identifier.