createSpeciesTable top-level constant

Implementation

const String createSpeciesTable = '''
CREATE TABLE species (
  id INTEGER PRIMARY KEY,
  code_specie INTEGER,
  vernacularName TEXT,
  otherNames TEXT,
  scientificName TEXT,
  scientificNameAuthorship TEXT,
  kingdom TEXT,
  phylum TEXT,
  clas TEXT,
  "order" TEXT,
  family TEXT,
  genus TEXT,
  descriptionGeneral TEXT,
  habit TEXT,
  leaves TEXT,
  flowers TEXT,
  fruits TEXT,
  seeds TEXT,
  specificEpithet TEXT,
  infraspecificEpithet TEXT,
  taxonRank TEXT,
  taxon_key INTEGER,
  views INTEGER,
  img_general TEXT,
  img_leafs TEXT,
  img_fruits TEXT,
  img_flowers TEXT,
  img_seeds TEXT,
  img_stem TEXT,
  img_landscape_one TEXT,
  img_landscape_two TEXT,
  img_landscape_three TEXT,
  protocol TEXT,
  resolution_protocol TEXT,
  annex_one TEXT,
  annex_two TEXT,
  format_coordinates TEXT,
  intructive_coordinates TEXT,
  format_inventary TEXT
)
''';