next up previous
Next: Protein data in table Up: Guide to the EpoDB Previous: Nucleotide data in table

Complex Attributes in Nucleotide tables

Note:header_info has been normalized to 3 relational tables:

 

header_info (relational)

Column TypeNull allowed
entry_id intNo
locus_id varchar(15)Yes
accession varchar(15)No
gi_id intNo
length intNo
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 datetimeYes
entry_date datetimeYes
create_date datetimeYes
div varchar(10)Yes
taxonomy varchar(255)No
genus varchar(50)Yes
species varchar(50)Yes
rest varchar(50)Yes
 

extra_accessions (relational)

Column TypeNull allowed
entry_id intNo
extra_accessions varchar(10)Yes

keywords (relational)

Column TypeNull allowed
entry_id intNo
keyword varchar(100)No
source varchar(10)No


next up previous
Next: Protein data in table Up: Guide to the EpoDB Previous: Nucleotide data in table

Chris Stoeckert 10/4/98
Fidel Salas 1/15/1998