Difference between revisions of "ER diagram"
From GGBN Wiki
| Line 2: | Line 2: | ||
==Overview== | ==Overview== | ||
Bild einbauen | Bild einbauen | ||
| + | ===DNA extractions=== | ||
| + | ===Specimen data providers=== | ||
| + | ===Specimen cache=== | ||
| + | ===Locations stock/aliquots=== | ||
| + | ===Molecular publications=== | ||
| + | ===Customer requests=== | ||
| + | ===Users=== | ||
| + | ===Log tables=== | ||
| + | ===Specimen Tool=== | ||
Kurze Einführung, worum gehts, Allgemeiner Aufbau | Kurze Einführung, worum gehts, Allgemeiner Aufbau | ||
==Table descriptions== | ==Table descriptions== | ||
| + | ===Table: _log_aliquots=== | ||
| + | ===Table: _log_amplifications=== | ||
| + | ===Table: _log_cache=== | ||
| + | ===Table: _log_cachehigertaxa=== | ||
| + | ===Table: _log_cacheimages=== | ||
| + | ===Table: _log_cachetaxonidentified=== | ||
| + | ===Table: _log_sptoolcollections=== | ||
| + | ===Table: _log_sptoolecology=== | ||
| + | ===Table: _log_sptoolhighertaxon=== | ||
| + | ===Table: _log_sptoolimages=== | ||
| + | ===Table: _log_sptooltaxa=== | ||
| + | ===Table: abcdmetadata=== | ||
| + | ===Table: abcdmetadataspecimens=== | ||
| + | ===Table: aliquots=== | ||
| + | ===Table: aliquots_box=== | ||
| + | ===Table: aliquots_fridge=== | ||
| + | ===Table: aliquots_rack=== | ||
| + | ===Table: amplifications=== | ||
| + | ===Table: authors=== | ||
| + | ===Table: basisofrecordspecimen=== | ||
| + | ===Table: cachecollection=== | ||
| + | ===Table: cachehighertaxa=== | ||
| + | ===Table: cacheimages=== | ||
| + | ===Table: cachetaxonidentified=== | ||
| + | ===Table: continentorocean=== | ||
| + | ===Table: countrycontinent=== | ||
| + | ===Table: countryisocode=== | ||
| + | ===Table: dataset=== | ||
| + | ===Table: degradation=== | ||
===Table: dnabanknumbers=== | ===Table: dnabanknumbers=== | ||
| + | ===Table: dnatype=== | ||
| + | ===Table: extractionmethod=== | ||
| + | ===Table: fragment=== | ||
| + | ===Table: images=== | ||
| + | ===Table: journals=== | ||
| + | ===Table: location_stock=== | ||
| + | ===Table: people=== | ||
| + | ===Table: preservation=== | ||
| + | ===Table: primer=== | ||
| + | ===Table: provider=== | ||
| + | ===Table: publications=== | ||
| + | ===Table: publications_amplifications=== | ||
| + | ===Table: publications_authors=== | ||
| + | ===Table: purification=== | ||
| + | ===Table: relationdna_voucher=== | ||
| + | ===Table: request=== | ||
| + | ===Table: schemata=== | ||
| + | ===Table: seasandoceans=== | ||
| + | ===Table: sex=== | ||
| + | ===Table: specimentype=== | ||
| + | ===Table: sptoolassociatedunits=== | ||
| + | ===Table: sptoolcollection=== | ||
| + | ===Table: sptoolecology=== | ||
| + | ===Table: sptoolhighertaxon=== | ||
| + | ===Table: sptoolmultimedia=== | ||
| + | ===Table: sptooltaxa=== | ||
| + | ===Table: stock_box=== | ||
| + | ===Table: stock_fridge=== | ||
| + | ===Table: stock_rack=== | ||
| + | ===Table: tissue=== | ||
| + | ===Table: user=== | ||
| + | ===Table: usergroups=== | ||
| + | ===Table: usersettings=== | ||
| + | ==View descriptions== | ||
| + | ===View: wrapper_view_amplifications=== | ||
| + | ===View: wrapper_view_dna=== | ||
| + | ===View: wrapper_view_providers=== | ||
| + | ===View: wrapper_view_publications_dna=== | ||
| + | ===View: wrapper_view_specimens=== | ||
[[Category:DNA_Module]] | [[Category:DNA_Module]] | ||
Revision as of 13:05, 14 July 2011
Contents
- 1 Entity-relation diagram of the DNA Module V2.0
- 1.1 Overview
- 1.2 Table descriptions
- 1.2.1 Table: _log_aliquots
- 1.2.2 Table: _log_amplifications
- 1.2.3 Table: _log_cache
- 1.2.4 Table: _log_cachehigertaxa
- 1.2.5 Table: _log_cacheimages
- 1.2.6 Table: _log_cachetaxonidentified
- 1.2.7 Table: _log_sptoolcollections
- 1.2.8 Table: _log_sptoolecology
- 1.2.9 Table: _log_sptoolhighertaxon
- 1.2.10 Table: _log_sptoolimages
- 1.2.11 Table: _log_sptooltaxa
- 1.2.12 Table: abcdmetadata
- 1.2.13 Table: abcdmetadataspecimens
- 1.2.14 Table: aliquots
- 1.2.15 Table: aliquots_box
- 1.2.16 Table: aliquots_fridge
- 1.2.17 Table: aliquots_rack
- 1.2.18 Table: amplifications
- 1.2.19 Table: authors
- 1.2.20 Table: basisofrecordspecimen
- 1.2.21 Table: cachecollection
- 1.2.22 Table: cachehighertaxa
- 1.2.23 Table: cacheimages
- 1.2.24 Table: cachetaxonidentified
- 1.2.25 Table: continentorocean
- 1.2.26 Table: countrycontinent
- 1.2.27 Table: countryisocode
- 1.2.28 Table: dataset
- 1.2.29 Table: degradation
- 1.2.30 Table: dnabanknumbers
- 1.2.31 Table: dnatype
- 1.2.32 Table: extractionmethod
- 1.2.33 Table: fragment
- 1.2.34 Table: images
- 1.2.35 Table: journals
- 1.2.36 Table: location_stock
- 1.2.37 Table: people
- 1.2.38 Table: preservation
- 1.2.39 Table: primer
- 1.2.40 Table: provider
- 1.2.41 Table: publications
- 1.2.42 Table: publications_amplifications
- 1.2.43 Table: publications_authors
- 1.2.44 Table: purification
- 1.2.45 Table: relationdna_voucher
- 1.2.46 Table: request
- 1.2.47 Table: schemata
- 1.2.48 Table: seasandoceans
- 1.2.49 Table: sex
- 1.2.50 Table: specimentype
- 1.2.51 Table: sptoolassociatedunits
- 1.2.52 Table: sptoolcollection
- 1.2.53 Table: sptoolecology
- 1.2.54 Table: sptoolhighertaxon
- 1.2.55 Table: sptoolmultimedia
- 1.2.56 Table: sptooltaxa
- 1.2.57 Table: stock_box
- 1.2.58 Table: stock_fridge
- 1.2.59 Table: stock_rack
- 1.2.60 Table: tissue
- 1.2.61 Table: user
- 1.2.62 Table: usergroups
- 1.2.63 Table: usersettings
- 1.3 View descriptions
Entity-relation diagram of the DNA Module V2.0
Overview
Bild einbauen
DNA extractions
Specimen data providers
Specimen cache
Locations stock/aliquots
Molecular publications
Customer requests
Users
Log tables
Specimen Tool
Kurze Einführung, worum gehts, Allgemeiner Aufbau
