ER diagram - Revision history

WikiSysop: /* Entity-relation diagram of the DNA Module V2.0 */

2016-09-28T14:46:28Z

Entity-relation diagram of the DNA Module V2.0

← Older revision		Revision as of 16:46, 28 September 2016
Line 1:		Line 1:
	=Entity-relation diagram of the DNA Module V2.0=		=Entity-relation diagram of the DNA Module V2.0=
	~~February 2014~~: ~~We are currently updating this information! Individual table descriptions are updated already~~.		September 2016: The new version will be called SaM (Sample Management). The empty sql script can be found at http://www.ggbn.org/ggbn_portal/documents/sam_dev.sql

	==Overview==		==Overview==

WikiSysop: /* Table: tissue */

2016-09-28T14:34:21Z

Table: tissue

@@ Line 5,036: / Line 5,036: @@
+|
+|
+|
 |}

WikiSysop: /* Table: schemata */

2016-09-28T13:46:10Z

Table: schemata

@@ Line 2,929: / Line 2,929: @@
+|
 |List of all schemata (ABCD, DwC)
 |-
 |Created_When

WikiSysop: /* Table: kindofunit */

2016-09-28T13:22:35Z

Table: kindofunit

← Older revision		Revision as of 15:22, 28 September 2016
Line 1,921:		Line 1,921:
	\|		\|
	\|}		\|}

			===Table: labnumber===

			tbd

	===Table: landusecode===		===Table: landusecode===

WikiSysop: /* Table: cachetaxonidentified */

2016-09-28T13:05:18Z

Table: cachetaxonidentified

← Older revision		Revision as of 15:05, 28 September 2016
Line 1,072:		Line 1,072:
	\|		\|
	\|		\|
	\|-
	~~\|Other~~
	~~\|varchar(500)~~
	~~\|YES~~
	\|
	\|
	~~\|Deprecated~~
	\|-		\|-
	\|NameAuthorYear		\|NameAuthorYear

WikiSysop: /* Table: cachecollection */

2016-09-28T11:37:07Z

Table: cachecollection

← Older revision		Revision as of 13:37, 28 September 2016
Line 836:		Line 836:
	\|		\|
	\|decimal value of Latitude		\|decimal value of Latitude
	\|-
	~~\|CollectionInfo_Other~~
	~~\|varchar(500)~~
	~~\|YES~~
	\|
	\|
	~~\|deprecated~~
	\|-		\|-
	\|TypeStatus		\|TypeStatus

WikiSysop: /* Entity-relation diagram of the DNA Module V2.0 */

2015-02-08T12:55:10Z

Entity-relation diagram of the DNA Module V2.0

← Older revision		Revision as of 14:55, 8 February 2015
Line 1:		Line 1:
	=Entity-relation diagram of the DNA Module V2.0=		=Entity-relation diagram of the DNA Module V2.0=
	February 2014: We are currently updating this information!		February 2014: We are currently updating this information! Individual table descriptions are updated already.

	==Overview==		==Overview==

WikiSysop: /* View descriptions */

2015-02-08T12:54:32Z

View descriptions

← Older revision		Revision as of 14:54, 8 February 2015
Line 5,410:		Line 5,410:

	==View descriptions==		==View descriptions==
	~~===View: wrapper_view_amplifications===~~		coming soon, required for BioCASe mapping
	~~===View: wrapper_view_dna===~~
	~~===View: wrapper_view_providers===~~
	~~===View: wrapper_view_publications_dna===~~
	~~===View: wrapper_view_specimens===~~

	[[Category:DNA_Module]]		[[Category:DNA_Module]]

WikiSysop: /* Table: usersettings */

2015-02-08T12:54:05Z

Table: usersettings

← Older revision		Revision as of 14:54, 8 February 2015
Line 5,282:		Line 5,282:
	Belongs to: [[#User_management \| User management]]		Belongs to: [[#User_management \| User management]]
	{\| border="1" width="95%"		{\| border="1" width="95%"
	!width="15%" \| ~~Column~~		!width="28%" \| Field
	!width="9%" \| Type		!width="12%" \| Type
	!width="4%" \| Null		!width="6%" \| Null
	!width="4%" \| Key		!width="6%" \| Key
	!width="20%" \| Default		!width="20%" \| Default
	!~~Description~~		!Comment
	\|-		\|-
	\|ID_Setting		\|ID_Setting
	\|int		\|int(10) unsigned
	\|No		\|NO
	\|PRI		\|PRI
	\|~~AUTO_INCREMENT~~		\|
	\|PK of all user settings		\|PK of all user settings
	\|-		\|-
	\|~~ID_User~~		\|FK_User
	\|int		\|int(10) unsigned
	\|No		\|NO
	\|~~Key~~		\|MUL
	\|~~No default~~		\|
	\|FK to [[#Table:_user \| table:user]]		\|FK to [[#Table:_user \| table:user]]
	\|-		\|-
	\|RecordsPerPage		\|RecordsPerPage
	\|float		\|float
	\|~~Yes~~		\|YES
			\|
	\|		\|
	\|~~NULL~~		\|Records per page hitlist (Search Tool)
	~~\|records~~ per page hitlist (Search Tool)
	\|-		\|-
	\|Sorting		\|Sorting
	\|varchar(50)		\|varchar(50)
	\|Yes		\|YES
			\|
			\|
			\|Sorting of hitlist (Search Tool)
			\|-
			\|MainMMPath
			\|varchar(500)
			\|YES
			\|
			\|
			\|Main Multimedia Path (Specimen Tool)
			\|-
			\|MainMMCreator
			\|varchar(100)
			\|YES
			\|
			\|
			\|Main Multimedia Creator (Specimen Tool)
			\|-
			\|MainMMType
			\|varchar(50)
			\|YES
			\|
			\|
			\|Main Multimedia Type (Specimen Tool)
			\|-
			\|MainMMLicense
			\|varchar(50)
			\|YES
			\|
			\|
			\|Main Multimedia License (Specimen Tool)
			\|-
			\|MainMMUseEXIF
			\|varchar(50)
			\|YES
			\|
			\|
			\|if 'Yes' use EXIF information (Specimen Tool)
			\|-
			\|CollDataSameAsMM
			\|varchar(50)
			\|YES
			\|
	\|		\|
	\|~~NULL~~		\|if 'Yes' use Multimedia Creator und Date als Collector and Collection Date
	~~\|sorting of hitlist (Search Tool)~~
	\|-		\|-
	\|~~RecordsPerpageSP~~		\|RecordsPerPageSP
	\|float		\|float
	\|~~Yes~~		\|YES
			\|
	\|		\|
	\|~~NULL~~		\|Records per page hitlist (Specimen Tool)
	~~\|records~~ per page hitlist (Specimen Tool)
	\|-		\|-
	\|SortingSP		\|SortingSP
	\|varchar(50)		\|varchar(50)
	\|~~Yes~~		\|YES
			\|
			\|
			\|Sorting of hitlist (Specimen Tool)
			\|-
			\|ShowUnitIDSP
			\|varchar(50)
			\|YES
			\|
			\|
			\|
			\|-
			\|ShowCollCodeSP
			\|varchar(50)
			\|YES
			\|
			\|
			\|
			\|-
			\|ShowInstCodeSP
			\|varchar(50)
			\|YES
			\|
			\|
			\|
			\|-
			\|Created_Who
			\|varchar(50)
			\|NO
			\|
			\|unknown
			\|
			\|-
			\|Created_When
			\|timestamp
			\|NO
			\|
			\|CURRENT_TIMESTAMP
	\|		\|
	~~\|NULL~~
	~~\|sorting of hitlist (Specimen Tool)~~
	\|}		\|}

WikiSysop: /* Table: usergroups */

2015-02-08T12:51:03Z

Table: usergroups

← Older revision		Revision as of 14:51, 8 February 2015
Line 5,243:		Line 5,243:
	Belongs to: [[#User_management \| User management]]		Belongs to: [[#User_management \| User management]]
	{\| border="1" width="95%"		{\| border="1" width="95%"
	!width="15%" \| ~~Column~~		!width="28%" \| Field
	!width="9%" \| Type		!width="12%" \| Type
	!width="4%" \| Null		!width="6%" \| Null
	!width="4%" \| Key		!width="6%" \| Key
	!width="20%" \| Default		!width="20%" \| Default
	!~~Description~~		!Comment
	\|-		\|-
	\|~~ID_Groups~~		\|ID_Group
	\|int		\|int(10) unsigned
	\|No		\|NO
	\|PRI		\|PRI
	\|~~AUTO_INCREMENT~~		\|
	\|PK of all user groups		\|PK of all user groups
	\|-		\|-
	\|Group		\|Group
	\|varchar(50)		\|varchar(50)
	\|~~Yes~~		\|NO
			\|
	\|		\|
	~~\|NULL~~
	\|Group name		\|Group name
	\|-		\|-
	\|~~ConfigTool~~		\|Created_Who
	~~\|varchar(50)~~
	~~\|Yes~~
	\|
	~~\|NULL~~
	\|
	\|-
	~~\|CreatedOther~~
	~~\|varchar(50)~~
	~~\|Yes~~
	\|
	~~\|NULL~~
	\|
	\|-
	~~\|CreatedSelf~~
	\|varchar(50)		\|varchar(50)
	\|~~Yes~~		\|NO
	\|		\|
	\|~~NULL~~		\|unknown
	\|		\|
	\|-		\|-
	\|~~BlockGeneral~~		\|Created_When
	\|~~varchar(50)~~		\|timestamp
	\|~~Yes~~		\|NO
	\|
	~~\|NULL~~
	\|
	\|-
	~~\|BlockTemp~~
	~~\|varchar(50)~~
	~~\|Yes~~
	\|
	~~\|NULL~~
	\|
	\|-
	~~\|AvailableDNA~~
	~~\|varchar(50)~~
	~~\|Yes~~
	\|
	~~\|NULL~~
	\|
	\|-
	~~\|NotesInternal~~
	~~\|varchar(50)~~
	~~\|Yes~~
	\|
	~~\|NULL~~
	\|
	\|-
	~~\|NotesExternal~~
	~~\|varchar(50)~~
	~~\|Yes~~
	\|		\|
	\|~~NULL~~		\|CURRENT_TIMESTAMP
	\|		\|
	\|}		\|}