Table 1.
Structure of the database of medicinal plants used in the traditional management of diabetes and its sequelae in Central America.
| Name of the table | Content | Fields in the table |
|---|---|---|
| Analysis_by_Accepted_Genus | Results of the analysis of use reports at genus level | Family; TPL accepted genus; total # of uses; reports for each disease category (CD, DM, KD, SI, UP, VL) |
| Analysis_by_family_no_species | Results of the analysis of use reports at family level | Family; Total species in TPL; species in database; total use reports; reports for each disease category (CD, DM, KD, SI, UP, VL) |
| Analysis_UseReports_by_Accepted_FullName | Results of the analysis of use reports at species level | Species accepted full name; total # of use reports; reports for each disease category (CD, DM, KD, SI, UP, VL) |
| ConditionCode_Lookup | Codes for disease category used in the database | CD (cardiovascular disease); DM (Diabetes mellitus); KD (Kidney disease); ND (Nerve Damage); SD (Sexual dysfunction); SI (Skin infection/disease); UP (Urinary problems); VL (Vision loss) |
| CountryCode_LookUP | Codes for countries used in the database | BE (Belize); CA (Central America); CR (Costa Rica); ES (EL Salvador); GU (Guatemala); HO (Honduras); NI (Nicaragua); Pa (Panama) |
| MedicinalPlants_matched_TPL | Plant names collated from references matched to The Plant List (TPL) | Medicinal plant full name; family; genus; species; infraspecific rank; infraspecific epithet; plant name author; exact match to TPL (Y/N); TPL record ID; TPL family; TPL full name matched to; TPL genus matched to; TPL species matched to; TPL plant name authors; International Plant Name Index (ipni) ID; Taxonomic status of name according to TPL v1.1; Confidence level of name: H = High (3-star, globally peer-reviewed), M= Medium, L= Low; TPL accepted name identifier; TPL accepted full name; TPL accepted genus; TPL accepted species; TPL accepted infraspecific rank; TPL accepted infraspecific epithet; TPL accepted name authors; Accepted name ipni ID; Taxonomic status of linked ׳accepted׳ name; Confidence level of ׳accepted׳ name |
| MedicinalPlants_ReferenceUseReports | Use reports extracted from literature | Reference key; Condition; plant full name (prior to name validation); TPL accepted name ID; Family; TPL accepted full name; accepted name ipni ID; TPL ‘accepted’ name taxonomic status; TPL accepted name confidence level; Plant part used; Mode of use |
| MedicinaPlants_Synonyms | Complete list of synonyms found in TPL for each medicinal plant in dataset | TPL accepted name; TPL accepted name ID; TPL accepted name taxonomic status; TPL name data source; accepted name ipni ID; TPL accepted name confidence level; TPL synonym full name; TPL synonym ID; TPL synonym taxonomic status; TPL synonym name source; TPL synonym ipni ID; TPL synonym confidence level |
| References | Sources consulted or from which data was extracted | Reference key; Reference authors; Year of publication ; Title; Journal; volume, issue and page numbers; country; study size; ethnic group studied; primary data; source used |