To generate a data model from back-end LOB objects, follow these steps:

1. You have Selected an Endpoint Type for your Object Service. Follow these steps to continue work with Objects Definition.

   The data model configure screen for the object service appears.

   

2. Click Generate.
3. From the Import Objects from Backend screen, click the EmpDirDetails schema to expand the tables details.
4. Under Tables, select the check boxes for the individual tables.



5. Click NEXT.

The Import Objects from Backend screen shows the imported back-end objects and the names of the imported objects for the data model. You can edit the names of the objects for the data model.

 

6. Click GENERATE.



7. In the Data Model tab of the navigation pane, click the plus button next to the contact object.

Fields and Relationships appear under the contact object.

8. Click Fields.

The list of fields in the contact object appears in the Configure screen. You can change the name of the fields or modify the attributes. For example, you can change the primary key attribute. You cannot change the auto-generated attribute.



NOTE: For metadata and Data Pre and Post Processors, refer to Automatic Field Level Encryption for Object Services.

9. In the Data Model tab of the navigation pane, under the contact object, click Relationships.

The list of relationships for the contact object appears. The contact object has a many-to-one relationship with the VTI_SAMPLE_COMPANY object and a one-to-many relationship with the VTI_SAMPLE_ORDER_ITEM object. You can edit or delete the relationships, or add new relationships.



10. In the navigation pane, click the Mapping tab.

The Common Mapping configuration screen for the VTI_SAMPLE_ORDER object appears. The common mapping between a data model field and a back-end object field is applied to a transform request, response, or both, when methods are invoked on a back-end object. The double-headed arrow icon in the Type drop-down indicates that the mapping transformation is applied to both request and response. The right-arrow icon indicates only request mapping, and the left-arrow icon indicates only response mapping of the object.

11. Click Save.

You can now publish the Quantum Fabric application as it is, or you can also configure the objects to be enabled for offline synchronization.

For more details on how to enable synchronization for the application, click Sync scope mapped to an object service.

 

After you have generated the data model from the back-end objects that you imported, you can publish your app. You can then provide the code that Quantum Fabric generates to a mobile application developer. The mobile application developer integrates the code with platform SDKs and adds additional logic and modifies the presentation layer. The mobile application developer builds the client binary and publishes it to the enterprise app store.

NOTE: To lock fields (read-only fields) in a data model of Object Services, refer to Configuring Read-only Fields for Object Services through MFCLI

At run time, Quantum Fabric is the middleware that talks to the back end, manages the integration, and filters, transforms, and synchronizes the data it sends to the front-end clients.

1. Steps to create an object:
   1. Create a new object service. See Create an Object Service.

   2. Click Save & Configure.

      The Configure screen for the new object service appears. The Data Model and Mapping tabs appear. The Data Model tab is selected by default.

   3. Click CONFIGURE NEW.

   4. In the Name text box, enter department, and then click SAVE.

      In the Configure screen, the department object is created and appears in the list of objects.

      NOTE: For Locked Apps: If you are using Locked Object Services, you cannot create new objects.
      
      For more information, refer Locking a Fabric App.
      

2. Steps to create fields:

   NOTE: For Locked Apps: If you are using Locked Object Services, you cannot edit the locked base object fields (The locked base fields of objects are categorized as the BASE FIELDS).
   However, you can add fields to the locked objects as custom fields. The new fields in the locked objects are categorized as CUSTOM FIELDS.
   
   For more information, refer Locking a Fabric App.
   

   1. In the Data Model tab of the navigation pane, click the plus button next to the department object.

      Fields and Relationships appear under the department object.

   2. Click Fields.

      The metadata details of the field is created by default and appears the same in the Field Configure screen.

      

   3. Click the Add button.

      A row is created for the new field including the basic columns NAME, TYPE, PRIMARY KEY, and DETAILS.

   4. Under the NAME column, type the required name of the field, for example Department_id.

      

   5. Under the TYPE column, select the data type of the field. The string data type is selected by default.
      The available data types as follows:

      Basic data types:

      string date boolean number

      Advanced data types

      binary: Used for uploading an image file format as evidence/proof. enum: Click here for more details on How to Configure Enum data type and examples. workflow state: Used for associating a back-end workflow. While defining a workflow state data type for a field, you can create a workflow or use an existing one. A workflow can contain a set of nodes represents a specific task or an event as per your business logic. Here, the workflow data type is a part of a field in an object. Backend workflow is linked to a verb in an Object Service and whenever that verb in the object service is invoked, the related workflow is triggers automatically. So that the workflow will execute all the subsequent tasks that were defined with in it and completes the entire backend process that is related to the linked verb. Using Workflow, you can visualize and design a backend process. It justifies the low code concept and you can design the backend workflow simply by dragging and dropping different types of nodes and connecting them as per the logic you need. For more information on how to configure a workflow, refer to Workflow

   6. If you want to set the field as a primary key, under the PRIMARY KEY column, click the toggle button to set to TRUE. The primary key value is FALSE by default.
   7. If you want to view and configure the additional columns of the field, click the View Details button under the DETAILS column.

      IMPORTANT: The View Details button is active only after you save the field details.

      

      The field details page displays the additional columns including unique, nullable, max length, autogenerated, creatable, updatable, precision, description, and metadata.

      The following details to help you when to use some of the specific constraints to specify rules for a field:
      Field constraints	Description
      	Unique: The unique constraint ensures that all values in a column are different. Both the unique and primary key constraints provide a guarantee for uniqueness for a column or set of columns. A primary key constraint automatically has a unique constraint. However, you can have many unique constraints per table, but only one primary key constraint per table.
      	Primary key  The primary key constraint uniquely identifies each record in a table. Primary keys must contain unique values, and cannot contain NULL values. A table can have only ONE primary key; and in the table, this primary key can consist of single or multiple columns (fields).
      	Precision is the number of digits in a number.  For example, the number 123 has a precision of 3. For example, the number 123.45 has a precision of 5 and a scale of 2. Scale is the number of digits to the right of the decimal point in a number.
      	Metadata: This metadata of the Object allows app developers to control client-side logic by using the Data Pre and Post Processors for Models functionality, which helps to access the metadata dynamically at runtime and has custom JS code written to transform the data based on the metadata. This allows app developers to modify business logic at the client app and control which fields get transformed and how. For example, you can write your custom logic for fields in models to transform data in client before sending to back end and vice versa such as data encryption, decryption, currency or temperature conversion, prepend or append characters such as salutations (Mr. or Dr.) or currency symbol ($ or €) and so on. For more information on metadata, Click here for more information on Object Metadata for Controlling Client-side Logic.

   8. If you want to add more fields to the object, repeat step 2 in the procedure.
   9. Click SAVE to save the details of the field.

   NOTE: If you want to create more objects in the data model, select the Data Model root node and click Add. And then repeat steps 1 and 2.

   NOTE: For Locked Apps: If you are using Locked Object Services, you cannot create new objects and edit the locked base object fields.
   
   For more information, refer Locking a Fabric App.
   

   NOTE: To lock fields (read-only fields) in a data model of Object Services, refer to Configuring Read-only Fields for Object Services through MFCLI

   NOTE: You can view the service in the Data Panel feature of Quantum Visualizer. By using the Data Panel, you can link back-end data services to your application UI elements seamlessly with low-code to no code. For more information on Data Panel, click here.

NOTE: You can also clone a data model of an existing object service. Refer to Actions in objects services.

To configure the relationships, follow these steps:

1. In the Data Model tab of the navigation pane, under the department object, click Relationships.

The Relationships screen appears.

2. Click the Add button.

The screen for configuring the relationships appears.

3. Click in the Select Target Objects field, and then select the employee object from the drop-down menu.
4. Click in the Select Relationship Type field, and select One to Many from the drop-down menu.
5. Under Specify Object Attribute Relationships, click in the Source Object Attributes field, and then select Department_id from the drop-down menu.
6. Click in the Target Object Attributes field, and then select Department_id from the drop-down menu.

   

7. Click SAVE.

NOTE: You can add objects to the data model, configure relationships, and enable synchronization for the application.

NOTE: You can sort fields by clicking the column name header in the data model.