Data model requirements

A data model can only be saved when it adheres to the following requirements:

The data model includes no more than 40 tables.
All tables are connected to the overall data model.
There are no circular relations in the data model.
A maximum of four direction changes are allowed in one relation path.

Tip:

A direction change is a one-to-many relation followed by a many-to-one relation, or vice versa.

Important:

If you require a larger data model than the "Max four direction changes" limitation allows, contact UiPath® Customer Support to turn off the limitation for your organization.

Note that turning this limitation off might have a performance implication for your dashboards.

Required output tables

A data model must have a Cases, Event_log, Tags, and Due_dates table.

Note:

Depending on the app template, the Cases table has a process-specific name, for example, Purchase_order_items, or Incidents.

The Cases, Event_log, Tags, and Due_dates table must have the following output fields.

Note:

All the fields are required. However, some fields are allowed to contain only NULL values.

Table	Required output field
`Cases`	`Case_ID`*
`Event_log`	`Case_ID`*
	`Event_start`
	`Event_end`
	`Activity`
	`Activity_order`
	`Automated`
	`Event_cost`
	`Event_processing_time`
`Tags`	`Tag_ID`
	`Case_ID`*
	`Tag`
	`Tag_type`
`Due_dates`	`Case_ID`*
	`Due_date`
	`Due_date_type`
	`Actual_date`
	`Expected_date`
	`On_time`
	`Cost`
	`Difference`