Schema Browser
Mouse Genome Informatics
MGI Home
Help
Tables
Relationships
Utility Tables
Constraints
Columns
View
pub
.
mgd
.
voc_term_repqualifier_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
name
text
2147483647
√
null
_term_key
int4
10
√
null
voc_term_emaps
._term_key
Implied Constraint
R
_vocab_key
int4
10
√
null
voc_vocab
._vocab_key
Implied Constraint
R
term
text
2147483647
√
null
abbreviation
text
2147483647
√
null
note
text
2147483647
√
null
sequencenum
int4
10
√
null
isobsolete
int2
5
√
null
_createdby_key
int4
10
√
null
_modifiedby_key
int4
10
√
null
creation_date
timestamp
29,6
√
null
modification_date
timestamp
29,6
√
null
Analyzed at Mon Sep 11 06:12 EDT 2023
Close relationships: