Table gmbuilder.public.entrytype 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
hjid int8 19
dbreferencetype.entrytype_dbreference_hjid fke43b3d27e13d04b6 R
entrytype_accession.entrytype_accession_hjid fkf3878e31135b043f R
entrytype_comment.entrytype_comment_hjid fk208663aca2ddba4 R
entrytype_name.entrytype_name_hjid fk3476d05e4cb1a72 R
evidencetype.entrytype_evidence_hjid fk3691f25187be97a6 R
featuretype.entrytype_feature_hjid fk4cf1bb3022d4956d R
genelocationtype.entrytype_genelocation_hjid fk3055bc647f1c3193 R
genetype.entrytype_gene_hjid fk6fb5300fcb570028 R
keywordtype.entrytype_keyword_hjid fk1603aca37c00d25a R
organismtype.entrytype_organismhost_hjid fk44b91f4c46dcd7e3 R
referencetype.entrytype_reference_hjid fk8f0bd50574685d78 R
hjtype varchar 2147483647
hjversion int8 19
organism int8 19  √  null
organismtype.hjid fk5adfa2ac48f8f456 R
modified timestamp 29,6  √  null
dataset varchar 2147483647  √  null
sequence int8 19  √  null
sequencetype.hjid fk5adfa2ac4029d2b4 R
protein int8 19  √  null
proteintype.hjid fk5adfa2ac3fcd2588 R
created timestamp 29,6  √  null
version int4 10  √  null
proteinexistence int8 19  √  null
proteinexistencetype.hjid fk5adfa2ac25cd0850 R
uniprottype_entry_hjid int8 19  √  null
uniprottype.hjid fk5adfa2ac4b853b11 R
uniprottype_entry_hjindex int4 10  √  null

Table contained 0 rows at Mon Nov 21 10:45 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
hjid Primary key Asc entrytype_pkey

Close relationships  within of separation: