Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.mrk_class
Controlled vocabulary table for all Marker Classes. Includes Not Applicable (-2) and Not Specified (-1).

See MRK_Classes.

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
_class_key int4 10
mrk_classes._class_key mrk_classes__class_key_fkey R
mrk_classes_view._class_key Implied Constraint R
primary key
name text 2147483647 class description
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 34 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_class_key Primary key, Used to cluster data Asc mrk_class_pkey
name Performance Asc mrk_class_idx_name

Close relationships  within of separation: