ATK Relations: Difference between revisions
No edit summary |
No edit summary |
||
| Line 7: | Line 7: | ||
* [[atkManyBoolRelation]] - 'An article has several categories, selected from a list of categories' | * [[atkManyBoolRelation]] - 'An article has several categories, selected from a list of categories' | ||
* [[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' | |||
==atkSecureRelation== | ==atkSecureRelation== | ||
Revision as of 10:16, 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, selected from a list of categories'
- atkManyToOneTreeRelation - 'A category has a parent category'
- atkMatrixRelation - 'In a project, phases x and y depend on phases a and b'
atkSecureRelation
Document me!
atkShuttleRelation
Document me!