Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.mrk_cluster
A record in this table defines a relationship between a set of markers. This table was designed to represent Homology clusters to allow multiple markers per organism to be in a cluster and has been generalized by including a cluster type, a source and an accession ID

See MRK_Marker

 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
_cluster_key int4 10
mrk_clustermember._cluster_key mrk_clustermember__cluster_key_fkey C
Primary key
_clustertype_key int4 10
voc_term._term_key mrk_cluster__clustertype_key_fkey R
The term for the type of cluster
_clustersource_key int4 10
voc_term._term_key mrk_cluster__clustersource_key_fkey R
The term for the source or 'provider' of the cluster
clusterid text 2147483647  √  null Cluster Accession ID
version text 2147483647  √  null Cluster version or release number
cluster_date timestamp 29,6  √  now() Cluster Date
_createdby_key int4 10 1001
mgi_user._user_key mrk_cluster__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key mrk_cluster__modifiedby_key_fkey R
user who last modified the record
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 117,991 rows at Thu Dec 21 05:31 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_cluster_key Primary key, Used to cluster data Asc mrk_cluster_pkey
clusterid Performance Asc mrk_cluster_idx_clusterid
_clustersource_key Performance Asc mrk_cluster_idx_clustersource_key
_clustertype_key Performance Asc mrk_cluster_idx_clustertype_key

Close relationships  within of separation: