Table gmbuilder.public.commenttype 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
cofactortype.commenttype_cofactor_hjid fkfe1886b59e6bd1dc R
commenttype_evidence.commenttype_evidence_hjid fk55102ddd751fd9c0 R
commenttype_linktype.commenttype_link_hjid fk856ab5da6ecf92fd R
eventtype.commenttype_event_hjid fk7951b8d4603ad4e9 R
evidencedstringtype.commenttype_text_hjid fk45d53f9891c845aa R
interactanttype.commenttype_interactant_hjid fkdcfa0aabdb8bd172 R
isoformtype.commenttype_isoform_hjid fk981cf9838394509a R
locationtype.commenttype_location_hjid fk65214af9d640322 R
subcellularlocationtype.commenttype_subcellularlocation_hjid fkdab41539501d42c4 R
hjtype varchar 2147483647
hjversion int8 19
phdependence int8 19  √  null
bpccommentgroupphdependencetype.hjid fke0cb521966aa2ef5 R
disease int8 19  √  null
commenttype_diseasetype.hjid fke0cb5219ea21feef R
redoxpotential int8 19  √  null
bpccommentgroupredoxpotentialtype.hjid fke0cb5219d49cbcdf R
experiments int4 10  √  null
name varchar 2147483647  √  null
absorption int8 19  √  null
bpccommentgroupabsorptiontype.hjid fke0cb521925e10d55 R
temperaturedependence int8 19  √  null
bpccommentgrouptemperaturedependencetype.hjid fke0cb52196e81953 R
organismsdiffer bool 1  √  null
error varchar 2147483647  √  null
method varchar 2147483647  √  null
mass float4 8,8  √  null
molecule int8 19  √  null
moleculetype.hjid fke0cb5219236a6dbe R
type varchar 2147483647  √  null
conflict int8 19  √  null
commenttype_conflicttype.hjid fke0cb5219cfa3bf01 R
kinetics int8 19  √  null
bpccommentgroupkineticstype.hjid fke0cb5219d8cf5aeb R
locationtype varchar 2147483647  √  null

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

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

Close relationships  within of separation: