IFLDLIST.PNG - 1,247BYTES IFLD.PNG Node of Table Fields

Nodes for field definitions of a specific table.


Operations on Main Tree View
Select the node of IFLDLIST.PNG - 1,247BYTESField List to list existing fields on the content pane. Right-click on the node to add a single or list of fields. Select the child node IFLD.PNG - 1,231BYTESField to edit the definition. You can delete the definition by right-clicking or keying Del on the node.



Operations on content pane
Select node ITBLLIST.PNG - 1,242BYTESTable List to show list of internal/external tables and datamodel on the content pane. Drag the row of field to change order of field. Right-click the row to add/delete a field definition. Select node IFLD.PNG - 1,231BYTESField to show the definition of the field. Details are as follow.

* Field Name, ID(alias)

ID(alias) is the ID of field integrated in DDL. When it's left blank, name will be used in DDL.

* Not Null, No Update, Show on Model

Not Null property is integrated in DDL. No Update field is the field which is not editted on UI screen. Fields in Primary Key is automatically set as No Update field. Show on Model is whether field is shown on datamodel or not.

* DataType

It represents the value domain of the field. This is an important property as domain of corresponding fields in key definition are validated when defining table relationship. Data type is defined in the node of System. Push Edit button to edit data type.

* Attr.(Attribute) Type

Native represents a normal filed which is implemented physically. Inherited represents a virtual field inherited from a related table. Derived represents a virtual field which value is calculated according to a prescribed rule.

* Functions Using this
List of internal functions processing this table.

* External Functions Using this
List of external functions processing this table.

To Overview