Text Schema - Taxonomy

• ftp://ftp-fc.sc.egov.usda.gov/ITIS/
   
• 331,154 records

CREATE TABLE kingdom (id INTEGER, nam VARCHAR);

CREATE TABLE tax  (
  tsn              SERIAL NOT NULL,
  unit_name1       CHAR(35) NOT NULL,
  unit_name2       VARCHAR(35),
  unit_name3       VARCHAR(35),
  unit_name4       VARCHAR(35),
  usage            VARCHAR(12) NOT NULL,
  unaccept_reason  VARCHAR(50),
  credibility_rtng VARCHAR(40) NOT NULL,
  parent_tsn       INTEGER,
  taxon_author_id  INTEGER,
  kingdom_id       SMALLINT NOT NULL,
  rank_id          SMALLINT NOT NULL,
  update_date      DATE NOT NULL
);

Previous: Table Stats         [Table of Contents]         Next: Taxonomy Query