Data Model

The CData SSIS Components for Box models Box data as an easy-to-use SQL database. There are three parts to the data model: tables, views, and stored procedures.

Tables

The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your Box account.

Common tables include:


Table	Description
Bookmarks	Stores and manages bookmarks that reference web links saved within Box, allowing users to create, update, delete, and retrieve them.
Collaborations	Tracks collaboration settings on Box items such as files and folders, including user roles and permissions for shared access.
Collections	Displays collections of items that users have grouped together in Box for easier navigation and organization.
Comments	Contains user comments made on Box files and folders, supporting creation, retrieval, updates, and deletion.
FileMetadataInstances	Retrieves metadata applied to specific files, showing key-value fields associated with metadata templates.
FileVersions	Lists all available versions of a file stored in Box, enabling tracking of file history and access to prior revisions.
Folders	Represents folders in Box, including their structure, contents, and metadata, with full create, update, delete, and query capabilities.
Groups	Manages groups of users in Box for easier collaboration and permission assignment across files and folders.
LegalPolicies	Stores legal hold policies created by an enterprise to preserve content for compliance or litigation purposes.
Memberships	Defines user memberships in groups, linking users to groups and managing their access within Box.
MetadataTemplates	Contains reusable metadata templates that define structured fields which can be applied to files and folders.
RecentItems	Shows a list of items recently accessed by the user, such as files and folders opened in Box.
SharedItems	Retrieves items that have been shared, including their shared links and associated access permissions.
SignRequests	Lists electronic signature requests sent or received through Box Sign, including request status.
TaskAssignments	Represents assignments of tasks within Box, linking a task to the users responsible for completing it.
Tasks	Stores tasks created in Box for files and folders, supporting assignment, due dates, and completion tracking.
TrashedItems	Contains items moved to the trash, allowing users to view, query, or permanently delete trashed files and folders.
UserEvents	Provides a record of user activity events in Box, such as logins, file uploads, shares, and collaborations.
Users	Stores user account details in Box, supporting creation, management, and retrieval of users across the enterprise.

Stored Procedures

Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard create, read, update, delete (CRUD) operations, including downloading, uploading, and copying files.