SchemaSpy - Table mgd.mgd.hmd

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

_homology_key

int4

hmd_homology_assay._homology_key	hmd_homology_assay__homology_key R
hmd_homology_marker._homology_key	Implied Constraint R
hmd_notes._homology_key	hmd_notes__homology_key R
mrk_homology_cache._homology_key	Implied Constraint R

_class_key

int4

hmd_class._class_key

hmd_homology__class_key R

_refs_key

int4

bib_refs._refs_key

hmd_homology__refs_key R

creation_date

timestamp

29,6

modification_date

timestamp

29,6

Table contained 40,716 rows at Mon Sep 26 19:11 EDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
_homology_key	Primary key	Asc	hmd_homology_pkey
_homology_key	Must be unique	Asc	hmd_homology_idx_homology_key
_class_key	Performance	Asc	hmd_homology_idx_class_key
_refs_key	Performance	Asc	hmd_homology_idx_refs_key