Make email field unique in Contact table

[marclindsay]

We want to make the email address in the Contact table unique. In trying to create this index, the email field was not listed as an available field. Is there a way to create a unique index on the email field? 

[AshishKM]

Does this email field is available in customer_contact table, if not you can create a new reference field and point to customer record, after that it will show on index page. 

[Ankur Bawiskar · Accepted solution]

@marclindsay 

customer_contact extends sys_user table

if the field is not available then you cannot index it

If my response helped please mark it correct and close the thread so that it benefits future readers.