title: INSERT with Subtype SuperType
body: <p>I am currently working with a db that utilizes a subtype / supertype structure. I am wondering the best approach to handling INSERTs. Do I keep the population of multiple tables in the SQL itself, or with PHP, or even a combo of the two?</p>
  
  <p>I am using MySQL / PHP (w/ Yii Framework)</p>
  
  <p><strong>///EDIT///</strong></p>
  
  <p>Don't know whats up with a down vote.  Didn't realize the importance of any tables as this is a general approach question.   But here is an example.  If a Party is created how do Business and or User get populated with that PartyId? SQL/PHP/Both?</p>
  
  <p><img src="https://i.stack.imgur.com/amvRM.png" alt="enter image description here"></p>