COMMENT ON SCHEMA "TNRS" IS '

IMPORTANT: when changing this schema, you must also make the same changes on vegbiendev:

$ make backups/TNRS.backup-remake # runtime: 3 min ("real 2m44.277s")

';

COMMENT ON FUNCTION tnrs_populate_fields() IS '

IMPORTANT: when changing this function, you must regenerate the derived cols:

runtime: 1.5 min ("92633 ms")

';

COMMENT ON TABLE tnrs IS '

IMPORTANT: when changing this table''s schema, you may need to re-run TNRS:

$ inputs/.TNRS/data.sql.run refresh

';

COMMENT ON TABLE batch_download_settings IS '

stores data from http://tnrs.iplantcollaborative.org/TNRSapp.html > Submit List > results section > Download settings > settings.txt

';

COMMENT ON TABLE client_version IS '

contains svn revisions

';

COMMENT ON COLUMN client_version.global_rev IS '

from `svn info .` > Last Changed Rev

';

COMMENT ON COLUMN client_version."/lib/tnrs.py rev" IS '

from `svn info lib/tnrs.py` > Last Changed Rev

';

COMMENT ON COLUMN client_version."/bin/tnrs_db rev" IS '

from `svn info bin/tnrs_db` > Last Changed Rev

';

COMMENT ON VIEW "taxon_scrub.scrubbed_unique_taxon_name.*" IS '

scrubbed_family: Name_matched_accepted_family was missing from the TNRS results at one point, so Family_matched is used as a workaround to populate this. the workaround is for *accepted names only*, as no opinion names do not have an Accepted_name_family to prepend to the scrubbed name to parse.

';