Schema Browser
 Home  | About  | Help  | FAQ  
Table mgd.mgd.hmd_homology_assay Generated by
SchemaSpy
Legend: SourceForge.net
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 10
hmd_homology._homology_key hmd_homology_assay__homology_key R
_assay_key int4 10
hmd_assay._assay_key hmd_homology_assay__assay_key R
creation_date timestamp 29,6
modification_date timestamp 29,6

Table contained 70,438 rows at Mon Sep 26 19:11 EDT 2011

Indexes:
Column(s) Type Sort Constraint Name
_homology_key + _assay_key Primary key Asc/Asc hmd_homology_assay_pkey
_homology_key + _assay_key Must be unique Asc/Asc hmd_homology_assay_idx_homology_assay_key
_assay_key Performance Asc hmd_homology_assay_idx_assay_key

Close relationships  within of separation: