Charts

MainTitle is an nvarchar field within the Chart table with a maximum length of 128 characters. The MainTitle field contains the name of the Chart as used in a variety of applications. It is used as the primary identifier for a Chart when retrieved from the database.

The SecondaryTitle field in the Chart table stores a supplemental title of a chart or graph, if applicable. It is of data type nvarchar and can hold up to 128 characters.

XLabel is an nvarchar data type field in the Chart table which is used to store the labels for the x-axis of the chart. These labels will be used to identify the x-axis values when a chart is generated. The length of XLabel should be long enough to support the name of the x-axis data points.

YLabel is a nvarchar field in the Chart table that stores text labels for the Y-Axis of a chart. This field will appear as the subtitle on the Y-Axis of a chart when it is displayed.

The field XUnitId is an nvarchar data type in the Chart table designed to store up to 450 characters that uniquely identify each data point within the Chart.

The YUnitId field in the Chart table contains the unique identifier (nvarchar data type with a maximum length of 450 characters) of the chart item. This field is used to help locate, identify, and manage chart items.

The Tooltip string field is part of the Chart table and is used to store a brief message associated with a chart item, allowing user to view additional information about the item when they hover the mouse over it. This field has a maximum length of 512 nvarchar characters.