When you open process design page and then click on Databases, you will see a list of all relational database schemas tied to that process. If there is no schema yet you can simply click Import and add one of the existing schemas or Add New Schema to create a schema and its tables.
Import
Displays all existing schemas. Select the ones you want to include in your process and click Ok. Clicking on Edit button unfolds a menu including:
Name
Name of schema, you can enter any name in to name field.
Prefix
Enter short name in to prefix field.
Click Details button to display all the tables of the schema and again click Details button of one of the tables listed:
Fields
Name
Enter name of field.
Type
Limited text, unlimited text, integer number, floating number, money, yes/no, date/time, unique identifier, xml and binary are listed. Select to type of field.
Size
Specifies the length of field in numbers of character. Only applicable to limited text type.
Languages
Under this section multiple language names can be added. For each language added, a separate column gets added to table with the name "columnname_languagename". In this way corresponding translation of the column data is being stored in its distinct column.
General
Primary Key
Id, code and name are listed. Select to primary key.
Authorize By
GUID's identified on the table shows up in this section. If one of them is selected
Relations
Click on add new relation button:
Name
Will be updated.
Type
One to many, one to one, one to one zero, many to one are listed. Select to type of relations.
Updated Rule
Will be updated.
Target Schema
Will be updated.
Target Table
Will be updated.
Constraints
- Source field : Will be updated.
- Target field : Will be updated.