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. All of the schema import, update and add operations are not executed until the process graph is committed.
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 is added to table with the name "columnName_languageName". In this way corresponding translation of the column data is being stored in a distinct column and it is fetched depending on the user's culture choice.
General
Primary Key
Id, code and name are listed. Select to primary key.
Authorize By
All the fields of unique identifier type from the table shows up in this section. Selecting one of them will restrict users to see only the row with selected field whose data is identical to their userId upon a select query.
Relations
Click on Add New Relation button:
Name
Enter a name for relation. It will be used later to call that relation. e.g. Word UserLogons is the relation name in usage Users.UserLogons
Type
Select relation type. Options are
- One to many
- One to one
- One to one or zero
- Many to one
Update Rule
Select update rule for related rows. With cascade rule, which is the only rule provided, when one of the records is updated or deleted, corresponding data on the other related table also gets updated or deleted.
Target Schema
Select a schema to create a relation to its table.
Target Table
Select a table from target schema to create a relation to.
Constraints
- Source field : Select a field name from first table to relate from.
- Target field : Select a field name for second table to relate to.
Initial Data
For some purposes, for example testing, you can populate tables with initial data enterd in XML format.
Add New Schema
In order to add a new schema you have to enter a name and a prefix. The rest is same as described above.