Sample Source Code
Scheduler: Logical Data Model

About the Program

Sharecare is an online application for behavioral healthcare programs and providers. It includes access, clinical, fiscal, and reporting subsystems.

The Scheduler component keeps track of todo items, availability, scheduled events, and clinical appointments. Its functionality is similar to the Outlook calendar, but with extended availability and overlap definitions, more complex recurrence patterns, and both clinical and fiscal validations.

About the Code

These are images from the logical model of the database. They were originally created in Visio, but were exported as images for inclusion here. The text did not export well, but is readable.

The Data Model

logical erd: the schedule

logical erd: clinical entries

logical erd: schedule owners

logical erd: historical entries, and availability at facilities

logical erd: recurrences