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
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
_cluster_key serial 10  √  nextval('mrk_cluster_seq'::regclass)
mrk_clustermember
Primary key
_clustertype_key int4 10
voc_term
The term for the type of cluster
_clustersource_key int4 10
voc_term
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 who created the record
_modifiedby_key int4 10 1001
mgi_user
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 62,796 rows at Mon Sep 11 06:12 EDT 2023

Indexes:
Column(s) Type Sort
_cluster_key Primary key Asc
clusterid Performance Asc
_clustersource_key Performance Asc
_clustertype_key Performance Asc

Close relationships  within of separation: