-- PLEASE DO NOT EDIT THIS CODE
-- This code was generated using the UMPLE 1.35.0.7523.c616a4dce modeling language!

CREATE DATABASE IF NOT EXISTS `example`;
USE `example`;

CREATE TABLE IF NOT EXISTS `example`.`person`
(
  /*------------------------*/
  /* MEMBER VARIABLES       */
  /*------------------------*/
  
  /*person Attributes*/
  name VARCHAR(255),
  id INT,
  age INT,
  PRIMARY KEY(id, name)

);



-- PLEASE DO NOT EDIT THIS CODE
-- This code was generated using the UMPLE 1.35.0.7523.c616a4dce modeling language!

CREATE DATABASE IF NOT EXISTS `example`;
USE `example`;

CREATE TABLE IF NOT EXISTS `example`.`mentor`
(
  /*------------------------*/
  /* MEMBER VARIABLES       */
  /*------------------------*/

  /*mentor Associations*/
  person_id INT,
  person_name VARCHAR(255),
  
  /*mentor Attributes*/
  class INT,
  PRIMARY KEY(class)

);


ALTER TABLE `example`.`mentor` ADD CONSTRAINT `fk_mentor_person_id_name` FOREIGN KEY (`person_id`, `person_name`) REFERENCES `example`.`person`(`id`, `name`);