cxgn_breedbase
.sgn
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
interpro
0
rows
Columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
interpro_id
bigserial
19
√
nextval('sgn.interpro_interpro_id_seq'::regclass)
domain
.interpro_id
Implied Constraint
R
interpro_accession
varchar
20
√
null
interpro_go
.interpro_accession
interpro_go_interpro_accession_fkey
C
description
text
2147483647
√
null
description_fulltext
tsvector
2147483647
√
null
Showing 1 to 4 of 4 entries
Previous
1
Next
Indexes
Search:
Constraint Name
Type
Sort
Column(s)
interpro_pkey
Primary key
Asc
interpro_id
interpro_accession_idx
Performance
Asc
interpro_accession
interpro_interpro_accession_key
Must be unique
Asc
interpro_accession
sgn_interpro_description_fulltext_index
Performance
Asc
description_fulltext
Showing 1 to 4 of 4 entries
Previous
1
Next
Relationships
Close relationships within degrees of separation
One
Two degrees
One implied
Two implied