(
  ncode char(8) not null primary key,
  accepted boolean not null,
  tcode char(8) not null,
  rank int1,
  famcode char(8),
  gencode char(8), 
  speccode char(8),
  tricode char(8),
  family char(20),
  genus_hybrid char(1),
  genus char(20),
  species_hybrid char(1),
  species char(30),
  trirank char(6),
  tri char(30),
  quadrank char(4),
  quad char(30),
  html_name text,
  html_auth_name text
) ;

index on ncode