This page is for application designers and data modellers working on an ERD. It explains how to edit the properties of tables and their attributes.

Editing a Table

To

change table details:

1. In the ERD, to open a table's properties:
   Click
   • either click on the
   Table
   • table header bar
   • Or From the more menu select Edit.
   • See Table for the options available to edit.

Edit Attributes

1. Double-click on an attribute to open its properties.
2. This works by directly double clicking an attribute visible on an ERD or from within the table properties Attributes section.
Common Tasks:
3. Changing the attribute name, can be achieved by simply updating and saving the Name value.
Changing the data type, can be necessary
• or in the table header bar, click 

  Insert excerpt
  _more_options_erd _more_options_erd nopanel true

   and select 

  Insert excerpt
  _edit _edit nopanel true

  .
4. PhixFlow opens the table properties; see Table for details about the options.

Editing Attributes

To change attribute details:

1. In an ERD:
   • in the table, click an attribute listed in the table
   • alternatively, open the table properties. In the Attributes section, double-click on an attribute name.
2. PhixFlow opens the attribute properties; see Attribute for details about the options.

Things you might want to edit for an attribute:

• Change the attribute name
  Update the Basic Settings → Name field and click 

  Insert excerpt
  _finish _finish nopanel true

   to save.
  
  

• Change the data type
  You may need to do this if there is a change in the data or

• the wrong type was initially applied.

• 
  Click the Basic Settings → Type field drop-down and select a type from the list; see Understanding Data Types

• .

  Note
  You can only change the data type

• for an attribute

• when it contains no data. If your attribute already contains data,

• see Clearing and Loading Data in an ERD

• .

  
  

• Adding an expression

• 
  In an attribute you can add a script that affects the attribute data using the Basic Settings → Expression field; see Expressions and PhixScripts, Expression Basics and Functions. You can:

  • check data in the attribute, for example to validate a value is present

  • process data, for example, to convert values to uppercase

  • populate an attribute with data, for example to set a fixed string value