ATK Relations
A relation defines a relation between two tables. One or more records in the first table belong to one or more records in the second table. A one to many relation would be '1 library has N books'. Below is a list of the relations that are currently available in ATK.
| Relation | Description | Screenshot |
|---|---|---|
| atkOneToOneRelation | 'A person has one address' | |
| atkOneToManyRelation | 'A department has many employees' | 
|
| atkManyToOneRelation | 'A project has a projectleader (that can lead multiple projects)' | 
|
| atkManyToManyRelation | 'A shopper buys multiple products, a product can be bought by multiple shoppers' | |
| atkManyToManySelectRelation | 'A shopper buys multiple products, a product can be bought by multiple shoppers' | |
| atkManyBoolRelation | 'An article has several categories, indicated with checkboxes' | 
|
| atkManyToOneTreeRelation | 'A category has a parent category' | 
|
| atkMatrixRelation | 'In a project, phases x and y depend on phases a and b' | |
| atkSecureRelation | 'A patient has personal information, that must be secured' | |
| atkShuttleRelation | 'An operator operates in several countries, selected from a list' | 
|
| atkExtendableShuttleRelation | 'An operator operates in several countries, selected from a list which can be filtered' |
Relations behave similar to Attributes (in fact, relationships are nothing more then special attributes).