ATK Relations: Difference between revisions
No edit summary |
No edit summary |
||
| Line 10: | Line 10: | ||
* [[atkSecureRelation]] - 'A patient has personal information, that must be secured' | * [[atkSecureRelation]] - 'A patient has personal information, that must be secured' | ||
* [[atkShuttleRelation]] - 'An operator operates in several countries, selected from a list' | * [[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' | |||
Revision as of 13:04, 28 June 2007
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'