How to Define an ERD

Open an Existing ERD

1. From the home menu, select Data and click on an ERD in the list.
2. In the repository, open your application and find Data → ERD.
   • either right-click on an ERD name and select Display.
   • or double-click the ERD name to open the properties. In the properties toolbar, click the

     Insert excerpt
     _erd _erd nopanel true

      icon.

Create a New ERD

1. From the home menu, select Data.
2. PhixFlow displays the list of ERDs. Select Create New from the left hand side.

3. In the pop-up, enter a name for your ERD, and a description then click 

   Insert excerpt
   _dialog_finish _dialog_finish nopanel true

   .

   Tip
   When you are creating tables, choose a name that reflects the entity your table represents.

   
   

4. PhixFlow opens a new ERD canvas on the left with a toolbar at the top. Hover your mouse pointer over toolbar icons to display a tooltip.

Create a Table From an Excel File

todo?? Flow 4.10

Add an Existing Table

1. In the toolbar, click Table ListImage RemovedWaiting for qualified icon??PhixFlow filters the repository to click 

   Insert excerpt
   _table_list _table_list nopanel true

2. PhixFlow filters the repository to show the list of tables available in this application.
3. Drag a table from the repository onto the ERD canvas. 

Create a New Table

Image Removed

1. Drag 

   Insert excerpt
   _table_new _table_new nopanel true

     from the toolbar into the diagram. Waiting for qualified icon??
2. In the pop-up, enter a name, for example "Customer" and click

   Insert excerpt
   _dialog_finish _dialog_finish nopanel true

   .
3. PhixFlow adds the table to the canvas and opens its properties tab on the right. The header displays the name entered in step 2. PhixFlow automatically adds 2 attributes:

1. • UID - the PhixFlow requires a unique identifier and primary key .for each table.
   • Name -  Figure out how to explain what the name attribute is for and how it's needed for the display name???
To add attributes to the table:In the table,
2. • PhixFlow sets the Name attribute to be the display name. In data grids and forms etc. PhixFlow uses this attribute to provide a user-friendly name, rather than a numeric identifier. Optionally, change the attribute name.
3. To add attributes to the table:
   1. In the table, click 

      Insert excerpt
      _new _new nopanel true

      . PhixFlow opens the attribute properties on the right.
   2. In the properties, enter the Name, Type and Length for the data; see Attributes.
      PhixFlow creates attributes with a Type or String and Length of 50 characters. Remember to select appropriate type properties for an attributes data, such as Date or Integer.

   3. Insert excerpt
      _dialog_finish _dialog_finish nopanel true

       the attribute properties.
4. PhixFlow adds the attribute to the table in the ERD.

Create Relationships

In an ERD you can create a one-to-many relationship between a primary key in one table with an attribute in another table. For relationship concepts, see Understanding ERDs.

To create a relationship, click-drag from one attribute to another.

See the table below for the relationships that can be created between attributes.

PhixFlow cannot create a relationship between your selected attributes if your selected foreign key attribute: 

• is already a foreign key to a different primary key.
• has a different Data Type and type properties to the primary key.

In these cases, PhixFlow reports an error: Related attributes must have the same type and length. This <type/length is different.

You can:

• create a new attribute to be the foreign key
• change the foreign key attributes to match the primary key, provided there is no data in the table
• create the relationship with a different attribute.

To change the data type properties, In the ERD, click on an attribute to open its properties.

Show

Relationships From Other ERDs

If a table appears on more than one ERD it may have relationships with tables that are not visible in your current ERD. You can check for other relationships using the show in/out buttons

Show all tables using this table (many:1)

Sow all tables used by this table (1:many)To see other related tables, right-click a table to show the context menu and select:

• Insert excerpt
  _rel_in _rel_in nopanel true

• Insert excerpt
  _rel_out _rel_out nopanel true

Saving ERDs

Changes to tables, attributes and relationships are automatically saved. However, you must click 

Properties

Basic Settings

ERD Toolbar

The toolbar is at the top of the canvas. Hover your mouse pointer over the toolbar to see a tooltip.

Table Pop-up Menu

You can access more options in a pop-up menu:

• in the table header, click 

  Insert excerpt
  _more_options_erd _more_options_erd nopanel true

   
• right-click anywhere in the table.