ATK Relations: Difference between revisions
No edit summary |
No edit summary |
||
| Line 15: | Line 15: | ||
| [[atkManyBoolRelation]] || 'An article has several categories, indicated with checkboxes' || [[Image:atkManyBoolRelation.png]] | | [[atkManyBoolRelation]] || 'An article has several categories, indicated with checkboxes' || [[Image:atkManyBoolRelation.png]] | ||
|- | |- | ||
| [[atkManyToOneTreeRelation]] | | [[atkManyToOneTreeRelation]] || 'A category has a parent category' || [[Image:atkManyToOneTreeRelation.png]] | ||
|- | |- | ||
| [[atkMatrixRelation]] | | [[atkMatrixRelation]] || 'In a project, phases x and y depend on phases a and b' || | ||
|- | |- | ||
| [[atkSecureRelation]] | | [[atkSecureRelation]] || 'A patient has personal information, that must be secured' || | ||
|- | |- | ||
| [[atkShuttleRelation]] | | [[atkShuttleRelation]] || 'An operator operates in several countries, selected from a list' || [[Image:atkShuttleRelation.png]] | ||
|- | |- | ||
| [[atkExtendableShuttleRelation]] | | [[atkExtendableShuttleRelation]] || 'An operator operates in several countries, selected from a list which can be filtered' || | ||
|} | |} | ||
Revision as of 18:01, 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' |