Table Structures

After publishing to a SQL Server, the tables available to you depend on the templates being used in your Model on the AF Server, as well as the Attributes you are using in each of them.

The standard structure of the tables can be described in the following way:

Standard Table Structure

Columns
CASE ID
ELEMENT ID
For Elements:
ELEMENT NAMEELEMENT DESCRIPTION
For Transfers:
TRANSFER NAMETRANSFER DESCRIPTIONSOURCEDESTINATIONSTART TIMEEND TIME
Optional Columns:
Columns you select through the configuration.

Composition Tracking, Quality Tracking, and Component Balance tables are created only when the corresponding analysis is configured in Sigmafine.