Complex Attributes in Nucleotide tables

Note:header_info has been normalized to 3 relational tables:

• Header_info contains all the attributes excepts keywords and extra accessions.
• Keywords contains the entry_id, keyword, and the type of entry (GenBank or SWISS-PROT).
• Extra_accessions contains the entry_id and the accession.

 

entry_id int No

locus_id varchar(15) Yes

accession varchar(15) No

gi_id int No

length int No

strand varchar(10) Yes

mol varchar(10) No

def varchar(255) Yes

organism varchar(100) No

common_name varchar(100) Yes

mol_type varchar(50) Yes

source varchar(255) Yes

origin varchar(255) Yes

update_date datetime Yes

entry_date datetime Yes

create_date datetime Yes

div varchar(10) Yes

taxonomy varchar(255) No

genus varchar(50) Yes

species varchar(50) Yes

rest varchar(50) Yes

 

entry_id int No

extra_accessions varchar(10) Yes

entry_id int No

keyword varchar(100) No

source varchar(10) No