SchemaSpy - Table mgd.mgd.prb_source

	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

_source_key

int4

10

gxd_antigen._source_key	gxd_antigen__source_key R
prb_probe._source_key	prb_probe__source_key R
seq_source_assoc._source_key	seq_source_assoc__source_key R

_segmenttype_key

int4

10

voc_term._term_key

prb_source__segmenttype_key R

_vector_key

int4

10

voc_term._term_key

prb_source__vector_key R

_organism_key

int4

10

mgi_organism._organism_key

prb_source__organism_key R

_strain_key

int4

10

prb_strain._strain_key

Implied Constraint R

_tissue_key

int4

10

prb_tissue._tissue_key

Implied Constraint R

_gender_key

int4

10

voc_term._term_key

prb_source__gender_key R

_cellline_key

int4

10

voc_term._term_key

prb_source__cellline_key R

_refs_key

int4

10

√

null

bib_refs._refs_key

prb_source__refs_key R

name

varchar

255

√

null

description

varchar

255

√

null

age

varchar

50

agemin

float8

17,17

agemax

float8

17,17

iscuratoredited

int2

5

_createdby_key

int4

10

mgi_user._user_key

prb_source__createdby_key R

_modifiedby_key

int4

10

mgi_user._user_key

prb_source__modifiedby_key R

creation_date

timestamp

29,6

modification_date

timestamp

29,6

Table contained 57,241 rows at Mon Sep 26 19:11 EDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
_source_key	Primary key	Asc	prb_source_pkey
_source_key	Must be unique	Asc	prb_source_idx_source_key
_cellline_key	Performance	Asc	prb_source_idx_cellline_key
_createdby_key	Performance	Asc	prb_source_idx_createdby_key
_gender_key	Performance	Asc	prb_source_idx_gender_key
_modifiedby_key	Performance	Asc	prb_source_idx_modifiedby_key
name	Performance	Asc	prb_source_idx_name
_organism_key + _source_key	Performance	Asc/Asc	prb_source_idx_organism_source_key
_refs_key	Performance	Asc	prb_source_idx_refs_key
_segmenttype_key	Performance	Asc	prb_source_idx_segmenttype_key
_strain_key	Performance	Asc	prb_source_idx_strain_key
_tissue_key	Performance	Asc	prb_source_idx_tissue_key
_vector_key	Performance	Asc	prb_source_idx_vector_key