Tables
The provider models the data in Microsoft Teams as a list of tables in a relational database that can be queried using standard SQL statements.
CData ADO.NET Provider for Microsoft Teams Tables
| Name | Description |
| Apps | Contains metadata for third-party and internal apps integrated into Microsoft Teams, including installation details, permissions, and usage metrics. |
| Channels | Tracks Microsoft Teams channel instances, capturing names, privacy settings, types (standard, private), and team associations. |
| GroupMembers | Represents the relationship between Microsoft 365 Groups and their members, including user identifiers and membership roles. |
| GroupOwners | Identifies users assigned as owners of Microsoft 365 Groups that support Teams functionality, enabling management actions. |
| Groups | Holds core metadata about Microsoft 365 Groups, including properties required for provisioning and maintaining Teams. |
| OpenShifts | Stores reusable shift templates created by managers in the Teams Shifts app, used to build individual shift schedules. |
| Schedules | Defines the overarching containers used in Teams Shifts for organizing shifts, time-off requests, and schedule groups. |
| SchedulingGroups | Segments users into groups within a Teams schedule to streamline shift assignments and reporting. |
| Shifts | Captures detailed shift assignments, including assigned user, start and end times, and optional shift notes. |
| Teams | Maintains records of Microsoft Teams instances, including team names, visibility settings, and associated group metadata. |
| TeamsInstalledApps | Tracks which apps are installed in each Microsoft Team, detailing installation context such as user, group, or channel level. |
| TeamTabs | Documents tabs added to Teams channels, including tab type (Planner, Website, custom app) and configuration data. |
| TimeOffReasons | Contains predefined labels for time-off requests in Teams Shifts, such as vacation, sick leave, or training. |
| TimesOff | Logs time-off entries requested by users through the Microsoft Teams Shifts interface, with reason codes and date ranges. |