ER diagram

From GGBN Wiki
Revision as of 14:05, 14 July 2011 by WikiSysop (talk | contribs)
Jump to: navigation, search

Contents

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