Table cxgn.sgn.domain

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

Dashed lines show
implied relationships

< n > number of related tables

Please support this project

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

domain_id

bigserial

√

nextval('domain_domain_id_seq'::regclass)

domain_match.domain_id

domain_match_domain_id_fkey

method_id

int8

√

null

domain_accession

varchar

√

null

description

text

2147483647

√

null

interpro_id

int8

√

null

description_fulltext

tsvector

2147483647

√

null

dbxref_id

int8

√

null

metadata_id

int8

√

null

metadata.metadata_id

domain_metadata_id_fkey

Table contained 24,823 rows at Wed May 20 01:50 EDT 2009

Indexes:

Column(s)	Type	Sort	Constraint Name
domain_id	Primary key	Asc	domain_pkey
interpro_id	Performance	Asc	interpro_id_idx
method_id	Performance	Asc	method_id_idx
description_fulltext	Performance	Asc	sgn_domain_description_fulltext_index