MySQLi Data Model

Table relationships can be defined in the graphical Data Modeling interface that will be maintained for your Connection. Future visits to Query Builder will automatically replicate relationships defined in Data Modeling.

Define Data Model

  1. Use the Connection select list to select an existing MySQLi Connection that you would like to configure relationships for.

Clicking OK will launch the Data Modeling interface.

Data Modeling

Relationships in the Data Modeling interface can be defined by doing the following in the graphical workspace:

  1. Drag tables that you want to form relationships with into the work space.
  2. To create a JOIN, mouse to the right of a table column until a single arrow appears. Then click and drag to the left of the table and column you wish to join to.
  3. Changes can be made to the Join Properties Overly by clicking and toggling between 1 and 0.
  4. To save space, tables can be minimized by clicking the collapse and expand buttons to the right of the table name.
  5. Tables can be removed from your model by clicking the Trash Can icon.

 

When you are finished, clicking OK will save the model for your current connection. When visiting the Query Builder interface whil defining a MySQLi Recordset, your joins will automatically be created once the needed tables are dragged into the Query Builder design area.