-- PLEASE DO NOT EDIT THIS CODE
-- This code was generated using the UMPLE 1.32.1.6535.66c005ced modeling language!

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

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

);



-- PLEASE DO NOT EDIT THIS CODE
-- This code was generated using the UMPLE 1.32.1.6535.66c005ced modeling language!

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

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

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

);


ALTER TABLE `example`.`mentor` ADD CONSTRAINT `fk_mentor_person_name` FOREIGN KEY (`person_name`) REFERENCES `example`.`person`(`name`);

-- PLEASE DO NOT EDIT THIS CODE
-- This code was generated using the UMPLE 1.32.1.6535.66c005ced modeling language!

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

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

  /*student Associations*/
  person_name VARCHAR(255),
  
  /*student Attributes*/
  locker INT,
  PRIMARY KEY(locker)

);


ALTER TABLE `example`.`student` ADD CONSTRAINT `fk_student_person_name` FOREIGN KEY (`person_name`) REFERENCES `example`.`person`(`name`);