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.
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.