...
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 Add New Relation button:
Name
Will be updated. TypeEnter 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
...
Updated Rule
Will be updated.
Target Schema
Will be updated.
...
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 : Will be updated. Select a field name from first table to relate from.
- Target field : Will be updated. Select a field name for second table to relate to.