We have been working on the database structure of your components and added 2 key features.
Wizard - Unique Group:
You have now to possibility to limit unicity of values between a group of fields. You can also define multiple different unique groups on the same table. Unlimited as always. Amazing, no ?
Unique Group is a wizard.
Index Key :
When a field is defined as INDEX, it become much faster to do a research on it. Choose the fields such as ’name’, or ‘product_code’ for instance.
So you are sure to optimize to the maximum the speed of your queries.
When a field is defined as an index, it becomes UNIQUE by obligation by SQL engine.
Index key is located in the field's properties.