CREATE TABLE `employee` (
  `emp_id` BIGINT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(20),
  `designation` VARCHAR(20),
  `email` VARCHAR(30),
  PRIMARY KEY  (`emp_id`)
);

CREATE TABLE `adress` (
  `addr_id` BIGINT NOT NULL AUTO_INCREMENT,
  `emp_id` BIGINT,
  `detail` TEXT,
  PRIMARY KEY  (`addr_id`)
);

CREATE TABLE `contact_number` (
  `ct_num_id` BIGINT NOT NULL AUTO_INCREMENT,
  `emp_id` BIGINT,
  `number` VARCHAR(20),
  PRIMARY KEY  (`ct_num_id`)
);


ALTER TABLE `adress` ADD CONSTRAINT `adress_fk1`
    FOREIGN KEY (`emp_id`) REFERENCES employee(`emp_id`);

ALTER TABLE `contact_number` ADD CONSTRAINT `contact_number_fk1`
    FOREIGN KEY (`emp_id`) REFERENCES employee(`emp_id`);