ATK Relations: Difference between revisions
No edit summary |
No edit summary |
||
| Line 5: | Line 5: | ||
* [[atkManyToOneRelation]] - 'A project has a projectleader (that can lead multiple projects)' | * [[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' | * [[atkManyToManyRelation]] - 'A shopper buys multiple products, a product can be bought by multiple shoppers' | ||
* [[atkManyBoolRelation]] - 'An article has several categories, | * [[atkManyBoolRelation]] - 'An article has several categories, indicated with checkboxes' | ||
* [[atkManyToOneTreeRelation]] - 'A category has a parent category' | * [[atkManyToOneTreeRelation]] - 'A category has a parent category' | ||
* [[atkMatrixRelation]] - 'In a project, phases x and y depend on phases a and b' | * [[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' | |||
Revision as of 10:18, 28 December 2006
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'