title: Relational data model to Google datastore mapping
body: <p>First off, I come from a RDBMS/SQL/C++/Java/Python background and I'm a newbie<br>
  to Gaelyk, the Google API and the Google datastore.  </p>
  
  <p>I like to model (using flowcharts for code and DB modeling tools for the database)<br>
  before I code.<br>
  I've used Erwin heavily in the past to do DB modeling.  </p>
  
  <p>In Erwin, I've designed a logical / physical data model of a database I'd like to<br>
  implement using the Google datastore and Gaelyk with the Google AppEngine SDK.  </p>
  
  <p>I wanted to design the data layout before coding anything.<br>
  My design tool of choice has been Erwin Data Modeler.  </p>
  
  <p>When I looked at the Google datastore, I saw that there<br>
  are no relational constraints, and joins are done via<br>
  WHERE clause :bind variables.  </p>
  
  <p>How can I map my existing model (with PKs/FKs, dependent entities, heavy relational links)  to the Google datastore?  </p>
  
  <p>Is there a modeling tool that will allow me to design for the Google datastore?<br>
  Is the DB design supposed to flow from the Gaelyk MVC pattern and direct coding?<br>
  I'm not used to this as I come from an RDBMS background where you model heavily<br>
  and all good things come from good relational design.  </p>
  
  <p>Also, before coding a database client app in an imperative language (C++, C, Java, Python),<br>
  I like to write pseudocode, BUT first and foremost comes the DB design (if the app<br>
  has a DB back-end)  </p>
  
  <p>Am I doing this all wrong?  It looks like there's a set of tools available to me<br>
  to start coding, but the design tool set is not there.  </p>
  
  <p>Addendum:<br>
  Here is the logical model I'm trying to map<img src="https://i.stack.imgur.com/9dsPr.png" alt="Model"></p>
  
  <p>How would I map a circular relationship<br>
  account --(1:m)-- following --(m:1)-- following_account_id --(1:1)-- account_id?</p>