I want to make the employee id number to be unique but I don't know where to start. I have a column called idnumber for employee's identifier in different tables in my database.
example admin input 1500960 as idnumber of specific employee and 1500960 should not use it again