ATK Relations: Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
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. | 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. | ||
{| border=1 cellpadding=5 | {| border=1 cellpadding=5 | ||
|- style="background-color: #FFFACD;" | |- style="background-color: #FFFACD;" | ||
! Relation || Description || Screenshot | ! Relation || Description || Screenshot | ||
Revision as of 18:02, 19 August 2008
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' | |
| 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' |