SchemaSpy - Table mgd.mgd.all

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

_cellline_key

int4

all_allele_cellline._mutantcellline_key	all_allele_cellline__mutantcellline_key R
all_cellline_derivation._parentcellline_key	all_cellline_derivation__parentcellline_key R

cellline

varchar

255

_cellline_type_key

int4

voc_term._term_key

all_cellline__cellline_type_key R

_strain_key

int4

prb_strain._strain_key

all_cellline__strain_key R

_derivation_key

int4

√

null

all_cellline_derivation._derivation_key

Implied Constraint R

ismutant

int2

_createdby_key

int4

mgi_user._user_key

all_cellline__createdby_key R

_modifiedby_key

int4

mgi_user._user_key

all_cellline__modifiedby_key R

creation_date

timestamp

29,6

modification_date

timestamp

29,6

Table contained 883,807 rows at Mon Sep 26 19:11 EDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
_cellline_key	Primary key	Asc	all_cellline_pkey
_cellline_key	Must be unique	Asc	all_cellline_idx_cellline_key
cellline	Performance	Asc	all_cellline_idx_cellline
_cellline_type_key + _derivation_key + _cellline_key	Performance	Asc/Asc/Asc	all_cellline_idx_cellline_type_key
_createdby_key	Performance	Asc	all_cellline_idx_createdby_key
_derivation_key + _cellline_key	Performance	Asc/Asc	all_cellline_idx_derivation_key
_modifiedby_key	Performance	Asc	all_cellline_idx_modifiedby_key
_strain_key	Performance	Asc	all_cellline_idx_strain_key