These tables are used for storing the taxonomy information from the NCBI.
TABLE taxonomy
========
taxon_id Required.
Primary key.
(id from NCBI, not assigned sequence number)
Cannot be updated.
NUMBER(10)
term Required.
Unique.
VARCHAR2(240)
is_default_display Required.
VARCHAR2(1)
Allowable values: Y or N.
common_name Optional.
VARCHAR2(240)
rank Optional.
VARCHAR2(10)
date_created Required.
On insert, set to SYSDATE.
On update, keep original date.
created_by Required.
On insert, set to USER
Other_rules:
-------------
is_default_display indicates whether a taxonomy term is used for the
default display on CGD pages (eg. Homology pull down from a protein
page).
TABLE taxonomy_link
========
taxonomy_link_no Required.
Primary key.
Oracle assigned sequence number.
Cannot be updated.
NUMBER(10)
tab_name Required.
VARCHAR2(30)
primary_key Required.
VARCHAR2(40)
primary_key_col Required.
VARCHAR2(100)
taxon_id Required.
Foreign key to Taxonomy table.
date_created Required.
On insert, set to SYSDATE.
On update, keep original date.
created_by Required.
On insert, set to USER
TABLE tax_hierarchy
=================
parent_id Required.
Part of primary key.
Cannot be updated.
NUMBER(10)
child_id Required.
Part of primary key.
Cannot be updated.
NUMBER(10)
generation Required.
NUMBER(10)
TABLE tax_synonym
=================
synonym_no Required.
Primary key, oracle generated sequence number.
Cannot be updated.
NUMBER(10)
tax_synonym Required.
VARCHAR2(240)
taxon_id Required.
Foreign key to taxonomy table.
NUMBER(10)