Objects and Attributes

System has:

• Library (one or many)

Library has:

• location
• hours (may vary from month to month and day to day--closed Sundays in July and August, open 9 to 8 every day except Friday and Saturday)

• holidays, staff development days
• desks (positions) to be staffed
• staff members
• schedulers
• administrators
• rules about the number of people who can be out on vacation on a given day

Desk has:

• station ID
• level of qualification required to staff it
• number of people required
• hours (may be different from library hours?) (allow for the half hour)

• activity ID
• activity type (e.g., program, class, storytime)
• level of qualification required to staff it/contribute
• recurrent status (e.g., storytimes for 2 year olds may be twice a week for 3 months)
• number of staff required
• hours
• location (including internal or external to the library location)

Staff member has:

• user ID

• password
• first name
• last name
• nickname (appears on printed schedules)
• department
• phone number
• email address
• daily schedule
• weekly schedule which may differ from week-to-week depending on how Saturday rotation is handled, for example
• skills/qualifications (which desks they are qualified to staff)
• maximum number of hours per week that they may work
• maximum number of hours per day/week they can be assigned to a desk/position, versus working at their own desk. Could also be expressed as a percentage of their time, then hours derived from that.
• lunch hour, if scheduled to work more than X hours per day
• break time, if scheduled to work more than Y hours per day
• vacation days
• personal days
• off-site training days
• on-site training time (physical or virtual)
• meetings and other appointments
• mark as unavailable

Scheduler has:

• user ID
• password
• phone number
• email address
• First name

 Administrator has:

•  user ID

• password
• email address

Yearly Calendar:

• Holidays
• Vacation Slots
• Which Week in Rotation

Daily Desk Calendar:

• For each hour, who is assigned to it