Tables |
db |
dbxref |
db | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
db_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
name | varchar | 255 | UNIQUE, NOT NULL | ||
description | varchar | 255 | NULL | contact_id bigint, foreign key (contact_id) references contact (contact_id) on delete cascade INITIALLY DEFERRED, | |
urlprefix | varchar | 255 | NULL | ||
url | varchar | 255 | NULL |
Type | Fields |
---|---|
NOT NULL | db_id |
NOT NULL | name |
UNIQUE | name |
dbxref | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
dbxref_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
db_id | integer | 20 | UNIQUE, NOT NULL | db.db_id | |
accession | varchar | 1024 | UNIQUE, NOT NULL, The local part of the identifier. Guaranteed by the db authority to be unique for that db. | ||
version | varchar | 255 | UNIQUE, NOT NULL | ||
description | text | 64000 |
Name | Fields |
---|---|
dbxref_idx1 | db_id |
dbxref_idx2 | accession |
dbxref_idx3 | version |
Type | Fields |
---|---|
NOT NULL | dbxref_id |
NOT NULL | db_id |
FOREIGN KEY | db_id |
NOT NULL | accession |
NOT NULL | version |
UNIQUE | db_id, accession, version |