Business record properties
Business records have properties that are set in the Properties view.
Property | Description |
---|---|
name | Record name. |
active | The active property indicates that the table
participates in the application code generation. It is checked by default when a managed form
(4fdm) is created. When a table is inactive, it does not provide the modeling
features and cannot be or be linked to a master record. |
masterTable | A data set can be composed of several database tables. The master table is a table on which CRUD operations will apply. The generator creates the CRUD operations for a given data set only if its unique key is composed by fields of the master table. |
unique key | A data set unique key is a field or a list of fields ensuring the uniqueness of data in the data set. It must be defined as a primary key or a secondary key in the database schema. |
Functionality | See Enable and disable CRUD logic. Only for generated forms and web services. |
Query | See Joins and Data order. |
Property | Description |
---|---|
name | Record field name. |
lookup | See Lookup fields. |
fieldType | Used to specify that its data type is derived from the data types in a database table or that it is Non_Database, indicating that the data type is not derived from a database columnSee formFields. |
sqlTabName | The sqlTabName property is the name of the database table for formField form items. |
colName | The colName property is the name of the database column. |
tableAliasName | Table alias name. |
fieldIdRef | Unique reference id of the field in the record. |
dataType | See dataType. |
defaultValue | See defaultValue. |
Property | Description |
---|---|
foreignFields | The foreign key field(s) in the relation. |
primaryFields | The primary key field(s) in the relation. |