Schema Browser
Mouse Genome Informatics
MGI Home
Help
Tables
Relationships
Utility Tables
Constraints
Columns
View
pub
.
mgd
.
mgi_organism_mgitype_view
Generated by
SchemaSpy
Implied relationships
Related columns
Constraints
Comments
Legend
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
_assoc_key
int4
10
√
null
seq_allele_assoc
._assoc_key
Implied Constraint
R
_organism_key
int4
10
√
null
_mgitype_key
int4
10
√
null
acc_mgitype
._mgitype_key
Implied Constraint
R
sequencenum
int4
10
√
null
_createdby_key
int4
10
√
null
_modifiedby_key
int4
10
√
null
creation_date
timestamp
29,6
√
null
modification_date
timestamp
29,6
√
null
commonname
text
2147483647
√
null
latinname
text
2147483647
√
null
typename
text
2147483647
√
null
Analyzed at Mon Sep 11 06:12 EDT 2023
Close relationships: