The SISfm Asset 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 following describes each table:
| eq_book_index | ||
| ID | Unique booking identifier. Must be the autonumber data type if AssetBookAutoNumber is TRUE. | |
| groupID | Booking group identifier, identifies a set of recurring bookings. | |
| title | User defined booking title. | |
| eq_id | The ID of the asset 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. | |
| meeting | Boolean indicating whether the booking is a meeting or of another type. | |
| 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. | ||
| eq_book_archive | The same as eq_book_index except: | |
| ID | Non-unique booking identifier. |