Table uniprotdb.public.organismtype 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.organismtype_dbreference_hjid fke43b3d2762738266 R
entrytype.organism fk5adfa2ac48f8f456 R
organismnametype.organismtype_name_hjid fk8f6d77774ebd64e2 R
organismtype_evidence.organismtype_evidence_hjid fk85fa8a0a51d1b216 R
hjtype varchar 2147483647
hjversion int8 19
lineage int8 19  √  null
organismtype_lineagetype.hjid fk44b91f4c167da5b0 R
entrytype_organismhost_hjid int8 19  √  null
entrytype.hjid fk44b91f4c46dcd7e3 R
entrytype_organismhost_hjindex int4 10  √  null

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

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

Close relationships  within of separation: