ATK Relations - Revision history

Boy at 10:44, 8 March 2010

2010-03-08T10:44:14Z

← Older revision		Revision as of 10:44, 8 March 2010
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]]

bahtiar at 18:03, 19 August 2008

2008-08-19T18:03:47Z

← Older revision		Revision as of 18:03, 19 August 2008
Line 25:		Line 25:
	\| [[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).

bahtiar at 18:02, 19 August 2008

2008-08-19T18:02:32Z

← Older revision		Revision as of 18:02, 19 August 2008
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 ~~width="80%"~~		{\| border=1 cellpadding=5
	\|- style="background-color: #FFFACD;"		\|- style="background-color: #FFFACD;"
	! Relation \|\| Description \|\| Screenshot		! Relation \|\| Description \|\| Screenshot

bahtiar at 18:01, 19 August 2008

2008-08-19T18:01:56Z

← Older revision		Revision as of 18:01, 19 August 2008
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]] - 'A category has a parent category' \|\| [[Image:atkManyToOneTreeRelation.png]]		\| [[atkManyToOneTreeRelation]] \|\| 'A category has a parent category' \|\| [[Image:atkManyToOneTreeRelation.png]]
	\|-		\|-
	\| [[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' \|\|		\| [[atkSecureRelation]] \|\| 'A patient has personal information, that must be secured' \|\|
	\|-		\|-
	\| [[atkShuttleRelation]] - 'An operator operates in several countries, selected from a list' \|\| [[Image:atkShuttleRelation.png]]		\| [[atkShuttleRelation]] \|\| 'An operator operates in several countries, selected from a list' \|\| [[Image:atkShuttleRelation.png]]
	\|-		\|-
	\| [[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' \|\|
	\|}		\|}

bahtiar at 18:01, 19 August 2008

2008-08-19T18:01:25Z

← Older revision		Revision as of 18:01, 19 August 2008
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.

	* [[atkOneToOneRelation]] - 'A person has one address'		{\| border=1 cellpadding=5 width="80%"
	* [[atkOneToManyRelation]] - 'A department has many employees'		\|- style="background-color: #FFFACD;"
	* [[atkManyToOneRelation]] - 'A project has a projectleader (that can lead multiple projects)'		! Relation \|\| Description \|\| Screenshot
	* [[atkManyToManyRelation]] - 'A shopper buys multiple products, a product can be bought by multiple shoppers'		\|-
	* [[atkManyBoolRelation]] - 'An article has several categories, indicated with checkboxes'		\| [[atkOneToOneRelation]] \|\| 'A person has one address' \|\|
	* [[atkManyToOneTreeRelation]] - 'A category has a parent category'		\|-
	* [[atkMatrixRelation]] - 'In a project, phases x and y depend on phases a and b'		\| [[atkOneToManyRelation]] \|\| 'A department has many employees' \|\| [[Image:atkOneToManyRelation.png]]
	* [[atkSecureRelation]] - 'A patient has personal information, that must be secured'		\|-
	* [[atkShuttleRelation]] - 'An operator operates in several countries, selected from a list'		\| [[atkManyToOneRelation]] \|\| 'A project has a projectleader (that can lead multiple projects)' \|\| [[Image:atkManyToOneRelation.png]]
	* [[atkExtendableShuttleRelation]] - 'An operator operates in several countries, selected from a list which can be filtered'		\|-
			\| [[atkManyToManyRelation]] \|\| '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]]
			\|-
			\| [[atkManyToOneTreeRelation]] - 'A category has a parent category' \|\| [[Image:atkManyToOneTreeRelation.png]]
			\|-
			\| [[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' \|\| [[Image:atkShuttleRelation.png]]
			\|-
			\| [[atkExtendableShuttleRelation]] - 'An operator operates in several countries, selected from a list which can be filtered' \|\|
			\|}

Tjeerd at 13:04, 28 June 2007

2007-06-28T13:04:22Z

← Older revision		Revision as of 13:04, 28 June 2007
Line 10:		Line 10:
	* [[atkSecureRelation]] - 'A patient has personal information, that must be secured'		* [[atkSecureRelation]] - 'A patient has personal information, that must be secured'
	* [[atkShuttleRelation]] - 'An operator operates in several countries, selected from a list'		* [[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'

bahtiar at 10:18, 28 December 2006

2006-12-28T10:18:55Z

← Older revision		Revision as of 10:18, 28 December 2006
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, ~~selected from a list of 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'
	==atkSecureRelation==		* [[atkShuttleRelation]] - 'An operator operates in several countries, selected from a list'

	~~Document me!~~

	==atkShuttleRelation==

	~~Document me!~~

bahtiar at 10:16, 28 December 2006

2006-12-28T10:16:48Z

← Older revision		Revision as of 10:16, 28 December 2006
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'
	==atkMatrixRelation==

	~~The atkMatrixRelation is no longer maintained~~ and ~~probably does not work. Over the years that ATK has existed, there haven~~'~~t been many uses for the atkMatrixRelation.~~

	==atkSecureRelation==		==atkSecureRelation==

bahtiar at 10:15, 28 December 2006

2006-12-28T10:15:44Z

@@ Line 5: / Line 5: @@
 * [[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'
-==atkManyBoolRelation==
+* [[atkManyToOneTreeRelation]] - 'A category has a parent category'
 ==atkMatrixRelation==

bahtiar at 10:10, 28 December 2006

2006-12-28T10:10:09Z

@@ Line 4: / Line 4: @@
 * [[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==