Editing a Table
To change table details:
- In the ERD, to open a table's properties:
- either click on the table header bar
- or in the table header bar, click More Optionsand select Edit.
- PhixFlow opens the table properties; see Table for details about the options.
Editing Attributes
To change attribute details:
- In an ERD, in a table,
- 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.
- 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 Name field and click OK. 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 Type field drop-down and select a type from the list; see Understanding Data Types.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: Expressions can be added to attributes to apply processing or populate a value. For example, to uppercase the values in the attribute or setting a fixed string value. See Functions for all available options.