In the Database Help system, each table has properties. The properties options are:
Name of the table and a description of the table
Name of each field (column) in the table and Key Indicators (if applicable)
Data type and length allowed for each column
"NOT NULL" or "NULLS" in the Allow Nulls column, indicates if the field allows null values
Indexes for each field and key indicators
The primary key serves as a unique identifier to the table and is used when searching or retrieving data. Primary keys do not allow null values. Foreign keys form relationships between the table that contains them and the table for which they are the primary key. When viewing Infor CRMtables:
The Primary Key Column is indicated by (PK).
Foreign keys are indicated by (FK).
Data is stored in a predefined format called a data type. A data type is an attribute that specifies what type of information can be stored in a column, parameter, or value. System-supplied data types are provided by Microsoft SQL Server and have base data types.
User-defined data types can be used with Microsoft SQL Server databases when several tables must store the same type of data in a column. You must also ensure that these columns have the same data type, length, and nullability. User-defined data types are derived from base data types.
Indexes allow the database to find and sort records faster, which improves performance. In a clustered index, the physical order of the rows in the table is the same as the logical order of the index key values. A unique index ensures that the indexed column contains no duplicate values. Other indexes, known as secondary indexes, may also be used to locate data, and are listed with each table. When viewing tables:
The clustered index is indicated by (CA).
The unique indexes are indicated by (AK).
Secondary indexes are indicated by (IE).