Import
Click on edit buttonWhen 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 on details button: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
Will be updated. Specifies the length of field in numbers of character. Only applicable to limited text type.
Languages
Will be updated.
General
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
Will be updated. GUID's identified on the table shows up in this section. If one of them is selected
Relations
Click on add new relation button:
...