This topic is for application designers who need to define data structures, including streams, attributes, properties and relationships.
PhixFlow Entity-Relationship Diagrams (ERDs) define the logical structure of the data in your application. "Entities" represent the things in the world that you want to represent as data. Defining the data for your application is considered the first step in your design.
The following example shows an ERD for a school. The school has entities: departments, teachers, students, classrooms and so on. All these entities are represented as tables and the lines connecting them show their relationships to one another. We can see from this a School Department has many Class Rooms and Teachers. This is covered in more detail in Understanding ERDs and Views.
| Iframe | ||||||
|---|---|---|---|---|---|---|
|
ERD Page Layout
Here is a simplified view of the ERD editor.
- The Toolbar provides ERD specific options, such as displaying the available table that can be added to your ERD and options for creating new table.
- The Repository browser, can list all of the available tables in your application and any associated packages. Select Tables from the toolbar to display this area.
- The Canvas area where the ERD will be configured. Tables can be added by:
- Dragging Table from the create menu of the toolbar onto the canvas.
- Clicking Tables from the list menu of the toolbar and dragging a table from the repository onto the canvas.
- Excel documents can be dragged directly onto the canvas and will be imported automatically.
- The Tables and Relationships, are displayed on the canvas. A Table Shows all of the attributes it contains within it and the data type. A relationship between two tables is displayed as a line connecting the primary key of one table to a foreign key of a second table. This is discussed in more detail in Relationships.
| HTML Comment | ||
|---|---|---|
| ||
May need more details on options for loading data, or a separate concept page.
|