constrant unique to field in odoo

ODOO

sql constraint work on the database and called when we want to create new record in database table 

we can make field unique as bellow 

 

_sql_constraints = [
        ('unique_code', 'unique(code)', 'Employee code must be unique !')

    ]

here we make constraint unique for employee code