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. | |
Booking person's email address. | ||
book_archive | The same as book_index except: | |
ID | Non-unique booking identifier. |