title: create a table that contains atributes with values from another table
body: <p>I have a relationship where a Medic is a person, and Medic has 3 attributes:- a <code>ID</code>, a <code>paycheck</code>, and a <code>speciality</code>, and a person has a <code>name</code>,<code>age</code>,<code>gender</code>,<code>address</code>, and since a medic is a <code>person</code>, i want to make it</p>
  
  <p>So when a medic is created with a specif <code>ID</code> it will get the <code>info( name,age etc )</code> from the <code>person</code> with that <code>id</code>.</p>
  
  <p>Is there a way to do that without using <code>update</code>, but instead make it happen on table creation like saying <code>table Medic</code> has attributes <code>Name where Medic.name = Person.Name</code> if <code>person.id = medic.id</code>.</p>