ER diagram: Difference between revisions

From GGBN Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
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

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

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: 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