ATK Relations: Difference between revisions
No edit summary |
No edit summary |
||
| (2 intermediate revisions by one other user not shown) | |||
| 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 | ||
| Line 12: | Line 12: | ||
|- | |- | ||
| [[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' || | ||
|- | |||
| [[atkManyToManySelectRelation]] || 'A shopper buys multiple products, a product can be bought by multiple shoppers' || | |||
|- | |- | ||
| [[atkManyBoolRelation]] || 'An article has several categories, indicated with checkboxes' || [[Image:atkManyBoolRelation.png]] | | [[atkManyBoolRelation]] || 'An article has several categories, indicated with checkboxes' || [[Image:atkManyBoolRelation.png]] | ||
| Line 25: | Line 27: | ||
| [[atkExtendableShuttleRelation]] || 'An operator operates in several countries, selected from a list which can be filtered' || | | [[atkExtendableShuttleRelation]] || 'An operator operates in several countries, selected from a list which can be filtered' || | ||
|} | |} | ||
Relations behave similar to [[Attributes]] (in fact, relationships are nothing more then special attributes). | |||
Latest revision as of 10:44, 8 March 2010
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' | |
| atkManyToManySelectRelation | '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' |
Relations behave similar to Attributes (in fact, relationships are nothing more then special attributes).