Primary And Foreign Keys
The columns in the list panel may display key information as well as the column name:
• A yellow key indicates that the column is a primary key for the table.
• A light blue key indicates that the column is a foreign key to another table. If you hover the cursor over the icon, the tool tip indicates the foreign table.
• A dark blue key indicates that the column is a conditional foreign key. A conditional foreign key represents rare relationships between tables where a single field (or set of fields) may reference multiple primary key constraints of other tables within the application as a foreign key.
• A red key indicates that the column is a logical key field. A logical key represents an alternate unique identifier of a record based on a different set of fields than the primary key.
If you hover your cursor over an icon, the tool tip indicates the key type.