My tables

CREATE TABLE IF NOT EXISTS `mydb`.`scrum_team` (
  `scrum_teamID` INT(11) NOT NULL AUTO_INCREMENT,
  `team_name` VARCHAR(45) NULL,
  `date_started` DATETIME NULL,
  `scrum_masterID` INT(11) NULL,
  `product_ownerID` INT(11) NULL,
  PRIMARY KEY (`scrum_teamID`),
  INDEX `fk_scrum_team_scrum_master1_idx` (`scrum_masterID` ASC),
  INDEX `fk_scrum_team_product_owner1_idx` (`product_ownerID` ASC),
  CONSTRAINT `fk_scrum_team_scrum_master1`
    FOREIGN KEY (`scrum_masterID`)
    REFERENCES `mydb`.`scrum_master` (`scrum_masterID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_scrum_team_product_owner1`
    FOREIGN KEY (`product_ownerID`)
    REFERENCES `mydb`.`product_owner` (`product_ownerID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB

CREATE TABLE IF NOT EXISTS `mydb`.`scrum_master` (
  `scrum_masterID` INT(11) NOT NULL AUTO_INCREMENT,
  `personID` INT(11) NULL,
  PRIMARY KEY (`scrum_masterID`),
  INDEX `fk_scrum_master_person1_idx` (`personID` ASC),
  CONSTRAINT `fk_scrum_master_person1`
    FOREIGN KEY (`personID`)
    REFERENCES `mydb`.`person` (`personID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
Note this table will have more fields in the future

CREATE TABLE IF NOT EXISTS `mydb`.`person` (
  `personID` INT(11) NOT NULL AUTO_INCREMENT,
  `first_name` VARCHAR(45) NULL,
  `insertion` VARCHAR(45) NULL,
  `phone` VARCHAR(45) NULL,
  `email` VARCHAR(45) NULL,
  `location` VARCHAR(45) NULL,
  `christian_name` VARCHAR(45) NULL,
  `ittle` VARCHAR(45) NULL,
  `copafilth_itemID` INT(11) NULL,
  `gmt_offset` INT(4) NULL,
  `personcol` VARCHAR(45) NULL,
  PRIMARY KEY (`personID`),
  INDEX `fk_person_copafilth_item1_idx` (`copafilth_itemID` ASC),
  UNIQUE INDEX `email_UNIQUE` (`email` ASC),
  CONSTRAINT `fk_person_copafilth_item1`
    FOREIGN KEY (`copafilth_itemID`)
    REFERENCES `mydb`.`copafilth_item` (`copafilth_itemID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB