SchemaSpy - Table mgd.mgd.all_cellline_derivation

	Schema Browser
Home \| About \| Help \| FAQ

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

_derivation_key

int4

10

all_cellline._derivation_key

Implied Constraint R

name

varchar

255

√

null

description

varchar

255

√

null

_vector_key

int4

10

voc_term._term_key

all_cellline_derivation__vector_key R

_vectortype_key

int4

10

voc_term._term_key

all_cellline_derivation__vectortype_key R

_parentcellline_key

int4

10

all_cellline._cellline_key

all_cellline_derivation__parentcellline_key R

_derivationtype_key

int4

10

voc_term._term_key

all_cellline_derivation__derivationtype_key R

_creator_key

int4

10

voc_term._term_key

all_cellline_derivation__creator_key R

_refs_key

int4

10

√

null

bib_refs._refs_key

all_cellline_derivation__refs_key R

_createdby_key

int4

10

mgi_user._user_key

all_cellline_derivation__createdby_key R

_modifiedby_key

int4

10

mgi_user._user_key

all_cellline_derivation__modifiedby_key R

creation_date

timestamp

29,6

modification_date

timestamp

29,6

Table contained 4,734 rows at Mon Sep 26 19:11 EDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
_derivation_key	Primary key	Asc	all_cellline_derivation_pkey
_derivation_key	Must be unique	Asc	all_cellline_derivation_idx_derivation_key
_creator_key	Performance	Asc	all_cellline_derivation_idx_creator_key
_derivationtype_key + _parentcellline_key + _creator_key	Performance	Asc/Asc/Asc	all_cellline_derivation_idx_derivationtype_key
name + _derivation_key	Performance	Asc/Asc	all_cellline_derivation_idx_name
_parentcellline_key + _derivation_key	Performance	Asc/Asc	all_cellline_derivation_idx_pcl
_refs_key	Performance	Asc	all_cellline_derivation_idx_refs_key