CREATE TABLE emplyee ( id int NOT NULL, first_name varchar(45) NOT NULL, last_name varchar(45), country varchar(45), UNIQUE (id) ); We can also define UNIQUE constraint on multiple column, for this ...
ALTER TABLE `messages` ADD CONSTRAINT `user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`); ALTER TABLE `channel_details` ADD CONSTRAINT `user_id` FOREIGN KEY (`user_id`) REFERENCES ...