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.

• 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'
• 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'