Attribute Table — Indicate fields that have a unique index

[Bud]

In the attribute table, fields that are used in a database index are indicated with an asterisk:

There are multiple indexes on that table:

• Unique index on UNIT_RATE_ID
• Composite index (unique) on:
  • ASSET_CLASS
  • STRATEGY
  • ACTIVITY
  • TYPE
  • UNIT_RATE_TYPE
  • UNIT_RATE_YEAR
• Non-unique indexes on other fields to improve query and join performance.

It's great that the indexed fields are shown with an asterisk. It would be even better if it showed if the field is used in a unique index or not. Knowing if a field is constrained by a unique index helps when editing data.

For example, those fields could be marked by a double asterisk. Or something like that.

Additionally, the hover text could also indicate if the field is used in a unique index: