There are two main approaches to start building an application service from scratch - data-driven and user-interface-driven a.k.a bottom-up and top-down. In this wizard we will follow the first approach.

Let's create a Data Structure, which will represent the entity Book.

The layout of the data structure is as follows:


BOOKID                 INTEGER         not null    primaryKey

BOOKISBN               CHAR        13  not null

BOOKTITLE              VARCHAR     200 not null

BOOKAUTHOR             VARCHAR     100 not null

BOOKEDITOR             VARCHAR     100

BOOKPUBLISHER          VARCHAR     100

BOOKFORMAT             VARCHAR     100

BOOKPUBLICATIONDATE    DATE

BOOKPRICE              DOUBLE          not null

The data model will be stored in a JSON format under the DataStructures folder of your project. After activation or publishing, the corresponding database table will be created

More information about how to manually create such a data structure, as well as the general concepts behind, can be found at: http://www.dirigible.io/samples/data_model.html and http://www.dirigible.io/help/data_structures.html