A flat record represents a structure that contains columns, unique keys, and primary keys. The structure of a flat record is similar to a database table that contains columns and keys.

Name of the native metadata object
Type of native metadata object
Related records for the flat record
Primary key for the flat record
Unique keys for the flat record
Indexes for the flat record
Any additional record attributes specific to the data source

A field is a data structure for a single unit of data in a data source.

Name of the field
Default value of the field
Precision of the field
Scale of the field
Boolean value that indicates whether the field can contain a null value
Any additional field attributes specific to the data source

Constraints represent the primary key and unique keys for a flat record.

Name of the key
Native name of the key defined in the native metadata
List of fields that form the key

Index represents a native index that orders the flat records or uniquely identifies a row in the flat record.

Name of the index
Native name of the index
Boolean value that indicates whether the index is unique
List of index fields
Index order to retrieve the data