MariaDB 10.4

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


10.4.26-MariaDB-1:10.4.26+maria~deb10-log


CREATE TABLE persons (
  person_id int(11) NOT NULL AUTO_INCREMENT,
  name varchar(255) NOT NULL,
  email varchar(50) DEFAULT NULL,
  phone int(11) DEFAULT NULL,
  bio text DEFAULT NULL,
  dob date DEFAULT NULL,
  gender enum('Male','Female','Other') NOT NULL,
  status tinyint(4) NOT NULL,
  created_at timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (person_id),
  UNIQUE KEY email (email),
  UNIQUE KEY phone (phone)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE person_addresses (
  person_id int(11) NOT NULL ,
  address varchar(255) NOT NULL,
  created_at timestamp NOT NULL DEFAULT current_timestamp(),
  UNIQUE KEY uc_person_address (person_id,address),
  CONSTRAINT fk_person FOREIGN KEY (person_id) REFERENCES persons(person_id) ON UPDATE CASCADE ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;