uses
Data source: Native American Ethnobotany Database · About: NAEB
165 rows where use_subcategory = 65 sorted by tribe
This data as json, CSV (advanced)
id | species | tribe ▼ | source | pageno | use_category | use_subcategory | notes | rawsource |
---|---|---|---|---|---|---|---|---|
26841 | Phytolacca americana L. 2931 | Micmac 141 | cfh79 35 | 59 | Drug 2 | Hemostat 65 | Leaves used for bleeding wounds. | Chandler, R. Frank, Lois Freeman and Shirley N. Hooper, 1979, Herbal Remedies of the Maritime Indians, Journal of Ethnopharmacology 1:49-68, page 59 |
28235 | Pinus strobus L. 2977 | Micmac 141 | cfh79 35 | 59 | Drug 2 | Hemostat 65 | Sap used for hemorrhaging. | Chandler, R. Frank, Lois Freeman and Shirley N. Hooper, 1979, Herbal Remedies of the Maritime Indians, Journal of Ethnopharmacology 1:49-68, page 59 |
35951 | Salix lucida Muhl. 3538 | Micmac 141 | cfh79 35 | 61 | Drug 2 | Hemostat 65 | Bark used for bleeding. | Chandler, R. Frank, Lois Freeman and Shirley N. Hooper, 1979, Herbal Remedies of the Maritime Indians, Journal of Ethnopharmacology 1:49-68, page 61 |
37027 | Sanguinaria canadensis L. 3572 | Micmac 141 | cfh79 35 | 61 | Drug 2 | Hemostat 65 | Roots used for hemorrhages and to prevent bleeding. | Chandler, R. Frank, Lois Freeman and Shirley N. Hooper, 1979, Herbal Remedies of the Maritime Indians, Journal of Ethnopharmacology 1:49-68, page 61 |
14266 | Eryngium yuccifolium Michx. 1551 | Natchez 156 | t40 115 | 45 | Drug 2 | Hemostat 65 | Stem and leaves chewed for nosebleeds. | Taylor, Linda Averill, 1940, Plants Used As Curatives by Certain Southeastern Tribes, Cambridge, MA. Botanical Museum of Harvard University, page 45 |
10696 | Cordylanthus ramosus Nutt. ex Benth. 1074 | Navajo 157 | e44 74 | 76 | Drug 2 | Hemostat 65 | Infusion of plant used by men for nosebleeds. | Elmore, Francis H., 1944, Ethnobotany of the Navajo, Sante Fe, NM. School of American Research, page 76 |
19472 | Lappula occidentalis var. cupulata (Gray) Higgins 2095 | Navajo 157 | h56 141 | 153 | Drug 2 | Hemostat 65 | Parts of the plant used for nosebleeds. | Hocking, George M., 1956, Some Plant Materials Used Medicinally and Otherwise by the Navaho Indians in the Chaco Canyon, New Mexico, El Palacio 56:146-165, page 153 |
38658 | Sphaeralcea coccinea ssp. coccinea 3773 | Navajo 157 | e44 74 | 62 | Drug 2 | Hemostat 65 | Infusion of plants used to stop bleeding. | Elmore, Francis H., 1944, Ethnobotany of the Navajo, Sante Fe, NM. School of American Research, page 62 |
3951 | Aquilegia micrantha Eastw. 304 | Navajo, Kayenta 158 | wh51 106 | 22 | Drug 2 | Hemostat 65 | Plant used as a hemostatic. | Wyman, Leland C. and Stuart K. Harris, 1951, The Ethnobotany of the Kayenta Navaho, Albuquerque. The University of New Mexico Press, page 22 |
21355 | Lupinus pusillus ssp. intermontanus (Heller) D. Dunn 2303 | Navajo, Kayenta 158 | wh51 106 | 28 | Drug 2 | Hemostat 65 | Plant used for nosebleeds. | Wyman, Leland C. and Stuart K. Harris, 1951, The Ethnobotany of the Kayenta Navaho, Albuquerque. The University of New Mexico Press, page 28 |
23758 | Nicotiana attenuata Torr. ex S. Wats. 2577 | Navajo, Kayenta 158 | wh51 106 | 41 | Drug 2 | Hemostat 65 | Plant used for nosebleed. | Wyman, Leland C. and Stuart K. Harris, 1951, The Ethnobotany of the Kayenta Navaho, Albuquerque. The University of New Mexico Press, page 41 |
25877 | Penstemon eatonii Gray 2806 | Navajo, Kayenta 158 | wh51 106 | 42 | Drug 2 | Hemostat 65 | Plant used as a hemostatic. | Wyman, Leland C. and Stuart K. Harris, 1951, The Ethnobotany of the Kayenta Navaho, Albuquerque. The University of New Mexico Press, page 42 |
31779 | Pyrola chlorantha Sw. 3240 | Navajo, Kayenta 158 | wh51 106 | 35 | Drug 2 | Hemostat 65 | Plant used as a hemostatic. | Wyman, Leland C. and Stuart K. Harris, 1951, The Ethnobotany of the Kayenta Navaho, Albuquerque. The University of New Mexico Press, page 35 |
9156 | Chamaesyce albomarginata (Torr. & Gray) Small 865 | Navajo, Ramah 159 | v52 18 | 35 | Drug 2 | Hemostat 65 | Poultice of plant used as a hemostatic. | Vestal, Paul A., 1952, The Ethnobotany of the Ramah Navaho, Papers of the Peabody Museum of American Archaeology and Ethnology 40(4):1-94, page 35 |
9170 | Chamaesyce fendleri (Torr. & Gray) Small 866 | Navajo, Ramah 159 | v52 18 | 35 | Drug 2 | Hemostat 65 | Poultice of chewed plant applied to cuts as a hemostatic. | Vestal, Paul A., 1952, The Ethnobotany of the Ramah Navaho, Papers of the Peabody Museum of American Archaeology and Ethnology 40(4):1-94, page 35 |
9243 | Chamaesyce serpyllifolia ssp. serpyllifolia 880 | Navajo, Ramah 159 | v52 18 | 35 | Drug 2 | Hemostat 65 | Poultice of chewed plant applied to cuts as a hemostatic. | Vestal, Paul A., 1952, The Ethnobotany of the Ramah Navaho, Papers of the Peabody Museum of American Archaeology and Ethnology 40(4):1-94, page 35 |
13748 | Erigeron flagellaris Gray 1473 | Navajo, Ramah 159 | v52 18 | 50 | Drug 2 | Hemostat 65 | Poultice of chewed leaves applied as a hemostatic. | Vestal, Paul A., 1952, The Ethnobotany of the Ramah Navaho, Papers of the Peabody Museum of American Archaeology and Ethnology 40(4):1-94, page 50 |
13749 | Erigeron flagellaris Gray 1473 | Navajo, Ramah 159 | v52 18 | 50, 51 | Drug 2 | Hemostat 65 | Poultice of chewed leaves applied as a hemostatic. | Vestal, Paul A., 1952, The Ethnobotany of the Ramah Navaho, Papers of the Peabody Museum of American Archaeology and Ethnology 40(4):1-94, page 50, 51 |
15750 | Gayophytum ramosissimum Torr. & Gray 1710 | Navajo, Ramah 159 | v52 18 | 37 | Drug 2 | Hemostat 65 | Poultice applied to cuts as a hemostatic. | Vestal, Paul A., 1952, The Ethnobotany of the Ramah Navaho, Papers of the Peabody Museum of American Archaeology and Ethnology 40(4):1-94, page 37 |
40605 | Trifolium dubium Sibthorp 4005 | Navajo, Ramah 159 | v52 18 | 33 | Drug 2 | Hemostat 65 | Poultice of chopped plant applied to cut as hemostat. | Vestal, Paul A., 1952, The Ethnobotany of the Ramah Navaho, Papers of the Peabody Museum of American Archaeology and Ethnology 40(4):1-94, page 33 |
14200 | Eriophorum callitrix Cham. ex C.A. Mey. 1539 | Ojibwa 173 | smith32 20 | 368 | Drug 2 | Hemostat 65 | Matted fuzz used as a 'hemostatic.' | Smith, Huron H., 1932, Ethnobotany of the Ojibwe Indians, Bulletin of the Public Museum of Milwaukee 4:327-525, page 368 |
29499 | Populus grandidentata Michx. 3103 | Ojibwa 173 | smith32 20 | 387388 | Drug 2 | Hemostat 65 | Infusion of young root used as a 'hemostatic.' | Smith, Huron H., 1932, Ethnobotany of the Ojibwe Indians, Bulletin of the Public Museum of Milwaukee 4:327-525, page 387388 |
32960 | Rhus glabra L. 3347 | Ojibwa 173 | smith32 20 | 354 | Drug 2 | Hemostat 65 | Infusion of root bark used as a 'hemostatic.' | Smith, Huron H., 1932, Ethnobotany of the Ojibwe Indians, Bulletin of the Public Museum of Milwaukee 4:327-525, page 354 |
33296 | Rhus typhina L. 3355 | Ojibwa 173 | smith32 20 | 354 | Drug 2 | Hemostat 65 | Root used for hemorrhages. | Smith, Huron H., 1932, Ethnobotany of the Ojibwe Indians, Bulletin of the Public Museum of Milwaukee 4:327-525, page 354 |
34197 | Rosa virginiana P. Mill. 3433 | Ojibwa 173 | r28 8 | 231 | Drug 2 | Hemostat 65 | Infusion of roots taken and used as a wash for bleeding foot cuts. | Reagan, Albert B., 1928, Plants Used by the Bois Fort Chippewa (Ojibwa) Indians of Minnesota, Wisconsin Archeologist 7(4):230-248, page 231 |
35846 | Salix fragilis L. 3528 | Ojibwa 173 | smith32 20 | 388 | Drug 2 | Hemostat 65 | Bark used as a styptic and poultice for sores. | Smith, Huron H., 1932, Ethnobotany of the Ojibwe Indians, Bulletin of the Public Museum of Milwaukee 4:327-525, page 388 |
35956 | Salix lucida Muhl. 3538 | Ojibwa 173 | smith32 20 | 388 | Drug 2 | Hemostat 65 | Bark used on bleeding cuts. | Smith, Huron H., 1932, Ethnobotany of the Ojibwe Indians, Bulletin of the Public Museum of Milwaukee 4:327-525, page 388 |
37042 | Sanguinaria canadensis L. 3572 | Ojibwa 173 | r28 8 | 231 | Drug 2 | Hemostat 65 | Infusion of roots taken and used as a wash for bleeding foot cuts. | Reagan, Albert B., 1928, Plants Used by the Bois Fort Chippewa (Ojibwa) Indians of Minnesota, Wisconsin Archeologist 7(4):230-248, page 231 |
38035 | Silphium perfoliatum L. 3687 | Ojibwa 173 | smith32 20 | 365 | Drug 2 | Hemostat 65 | Plant used for hemorrhage. | Smith, Huron H., 1932, Ethnobotany of the Ojibwe Indians, Bulletin of the Public Museum of Milwaukee 4:327-525, page 365 |
40912 | Tsuga canadensis (L.) Carr. 4041 | Ojibwa 173 | smith32 20 | 380 | Drug 2 | Hemostat 65 | Bark used for bleeding wounds. | Smith, Huron H., 1932, Ethnobotany of the Ojibwe Indians, Bulletin of the Public Museum of Milwaukee 4:327-525, page 380 |
41547 | Ulmus rubra Muhl. 4052 | Ojibwa 173 | r28 8 | 231 | Drug 2 | Hemostat 65 | Infusion of roots taken and used as a wash for bleeding foot cuts. | Reagan, Albert B., 1928, Plants Used by the Bois Fort Chippewa (Ojibwa) Indians of Minnesota, Wisconsin Archeologist 7(4):230-248, page 231 |
22119 | Maianthemum racemosum ssp. racemosum 2381 | Ojibwa, South 174 | h91 56 | 199 | Drug 2 | Hemostat 65 | Poultice of crushed, fresh leaves applied to bleeding cuts. | Hoffman, W.J., 1891, The Midewiwin or 'Grand Medicine Society' of the Ojibwa, SI-BAE Annual Report #7, page 199 |
25442 | Panax trifolius L. 2735 | Ojibwa, South 174 | h91 56 | 201 | Drug 2 | Hemostat 65 | Poultice of chewed root applied to cuts as a coagulant. | Hoffman, W.J., 1891, The Midewiwin or 'Grand Medicine Society' of the Ojibwa, SI-BAE Annual Report #7, page 201 |
29928 | Prosartes trachycarpa S. Wats. 3151 | Okanagan-Colville 175 | tbk80 32 | 44 | Drug 2 | Hemostat 65 | Poultice of dampened, bruised leaves applied to bleeding wounds. | Turner, Nancy J., R. Bouchard and Dorothy I.D. Kennedy, 1980, Ethnobotany of the Okanagan-Colville Indians of British Columbia and Washington, Victoria. British Columbia Provincial Museum, page 44 |
35675 | Salix bebbiana Sarg. 3520 | Okanagan-Colville 175 | tbk80 32 | 136 | Drug 2 | Hemostat 65 | Poultice of bark and sap applied as a wad to bleeding wounds. | Turner, Nancy J., R. Bouchard and Dorothy I.D. Kennedy, 1980, Ethnobotany of the Okanagan-Colville Indians of British Columbia and Washington, Victoria. British Columbia Provincial Museum, page 136 |
36063 | Salix scouleriana Barratt ex Hook. 3547 | Okanagan-Colville 175 | tbk80 32 | 136 | Drug 2 | Hemostat 65 | Poultice of bark and sap applied as a wad to bleeding wounds. | Turner, Nancy J., R. Bouchard and Dorothy I.D. Kennedy, 1980, Ethnobotany of the Okanagan-Colville Indians of British Columbia and Washington, Victoria. British Columbia Provincial Museum, page 136 |
36244 | Salix sp. 3551 | Okanagan-Colville 175 | tbk80 32 | 136 | Drug 2 | Hemostat 65 | Poultice of bark and sap applied as a wad to bleeding wounds. | Turner, Nancy J., R. Bouchard and Dorothy I.D. Kennedy, 1980, Ethnobotany of the Okanagan-Colville Indians of British Columbia and Washington, Victoria. British Columbia Provincial Museum, page 136 |
31608 | Pulsatilla patens ssp. multifida (Pritz.) Zamels 3225 | Okanagon 176 | p52 55 | 42 | Drug 2 | Hemostat 65 | Leaves applied to nose for nosebleeds. | Perry, F., 1952, Ethno-Botany of the Indians in the Interior of British Columbia, Museum and Art Notes 2(2):36-43., page 42 |
5446 | Artemisia ludoviciana ssp. ludoviciana 401 | Omaha 177 | g13ii 154 | 334 | Drug 2 | Hemostat 65 | Dried, powdered leaves applied to nostrils for nasal hemorrhage. | Gilmore, Melvin R., 1913, A Study in the Ethnobotany of the Omaha Indians, Nebraska State Historical Society Collections 17:314-57., page 334 |
16375 | Gymnocladus dioicus (L.) K. Koch 1791 | Omaha 177 | ff11 124 | 584 | Drug 2 | Hemostat 65 | Root bark used for hemorrhages, especially from nose and during childbirth. | Fletcher, Alice C. and Francis La Flesche, 1911, The Omaha Tribe, SI-BAE Annual Report #27, page 584 |
32980 | Rhus glabra L. 3347 | Omaha 177 | g19 17 | 99, 100 | Drug 2 | Hemostat 65 | Decoction of fruits used as a post-partum styptic wash. | Gilmore, Melvin R., 1919, Uses of Plants by the Indians of the Missouri River Region, SI-BAE Annual Report #33, page 99, 100 |
16337 | Gutierrezia sarothrae (Pursh) Britt. & Rusby 1786 | Paiute 183 | tha41 12 | 82, 83 | Drug 2 | Hemostat 65 | Poultice of boiled leaves applied to top of head for nosebleed. | Train, Percy, James R. Henrichs and W. Andrew Archer, 1941, Medicinal Uses of Plants by Indian Tribes of Nevada, Washington DC. U.S. Department of Agriculture, page 82, 83 |
21916 | Mahonia nervosa (Pursh) Nutt. 2374 | Paiute 183 | m53 98 | 72 | Drug 2 | Hemostat 65 | Infusion of roots and leaves taken as a general tonic for nosebleeds. | Mahar, James Michael., 1953, Ethnobotany of the Oregon Paiutes of the Warm Springs Indian Reservation, Reed College, B.A. Thesis, page 72 |
36849 | Sambucus racemosa var. melanocarpa (Gray) McMinn 3568 | Paiute 183 | tha41 12 | 137138 | Drug 2 | Hemostat 65 | Poultice of bruised leaves applied to bleeding wounds. | Train, Percy, James R. Henrichs and W. Andrew Archer, 1941, Medicinal Uses of Plants by Indian Tribes of Nevada, Washington DC. U.S. Department of Agriculture, page 137138 |
1402 | Acourtia wrightii (Gray) Reveal & King 57 | Pima 193 | r08 104 | 80 | Drug 2 | Hemostat 65 | Plant used as a styptic. | Russell, Frank, 1908, The Pima Indians, SI-BAE Annual Report #26:1-390, page 80 |
1932 | Agrimonia gryposepala Wallr. 109 | Potawatomi 206 | smith33 43 | 76 | Drug 2 | Hemostat 65 | Plant used as styptic and infusion snuffed for nosebleed by Prairie Potawatomi. | Smith, Huron H., 1933, Ethnobotany of the Forest Potawatomi Indians, Bulletin of the Public Museum of the City of Milwaukee 7:1-230, page 76 |
21497 | Lycopodium clavatum L. 2321 | Potawatomi 206 | smith33 43 | 64 | Drug 2 | Hemostat 65 | Spores of fruiting spikes used as a styptic and coagulant. | Smith, Huron H., 1933, Ethnobotany of the Forest Potawatomi Indians, Bulletin of the Public Museum of the City of Milwaukee 7:1-230, page 64 |
21514 | Lycopodium obscurum L. 2324 | Potawatomi 206 | smith33 43 | 64 | Drug 2 | Hemostat 65 | Spores of fruiting spikes used as a styptic and coagulant. | Smith, Huron H., 1933, Ethnobotany of the Forest Potawatomi Indians, Bulletin of the Public Museum of the City of Milwaukee 7:1-230, page 64 |
33303 | Rhus typhina L. 3355 | Potawatomi 206 | smith33 43 | 38 | Drug 2 | Hemostat 65 | Root bark used as a 'hemostatic.' | Smith, Huron H., 1933, Ethnobotany of the Forest Potawatomi Indians, Bulletin of the Public Museum of the City of Milwaukee 7:1-230, page 38 |
35784 | Salix discolor Muhl. 3525 | Potawatomi 206 | smith33 43 | 81, 82 | Drug 2 | Hemostat 65 | Decoction of root bark used for hemorrhages. | Smith, Huron H., 1933, Ethnobotany of the Forest Potawatomi Indians, Bulletin of the Public Museum of the City of Milwaukee 7:1-230, page 81, 82 |
41837 | Urtica dioica ssp. gracilis (Ait.) Seland. 4059 | Quinault 210 | g73 25 | 28 | Drug 2 | Hemostat 65 | Decoction of peeled bark taken for nosebleeds. | Gunther, Erna, 1973, Ethnobotany of Western Washington, Seattle. University of Washington Press. Revised edition, page 28 |
39614 | Tephrosia purpurea (L.) Pers. 3910 | Seminole 228 | s54 88 | 304 | Drug 2 | Hemostat 65 | Decoction of plant used for nose bleeds. | Sturtevant, William, 1954, The Mikasuki Seminole: Medical Beliefs and Practices, Yale University, PhD Thesis, page 304 |
27327 | Picrothamnus desertorum Nutt. 2942 | Shoshoni 232 | tha41 12 | 43, 44 | Drug 2 | Hemostat 65 | Decoction of leaves sniffed for nosebleed. | Train, Percy, James R. Henrichs and W. Andrew Archer, 1941, Medicinal Uses of Plants by Indian Tribes of Nevada, Washington DC. U.S. Department of Agriculture, page 43, 44 |
24079 | Nuphar lutea ssp. advena (Ait.) Kartesz & Gandhi 2595 | Sioux 238 | b05 73 | 17 | Drug 2 | Hemostat 65 | Dry, porous rhizomes ground fine and applied to wounds as a styptic. | Blankinship, J. W., 1905, Native Economic Plants of Montana, Bozeman. Montana Agricultural College Experimental Station, Bulletin 56, page 17 |
24150 | Nuphar lutea ssp. variegata (Dur.) E.O. Beal 2597 | Sioux 238 | h92 30 | 33 | Drug 2 | Hemostat 65 | Rootstocks powdered and used as a styptic for wounds. | Hart, Jeff, 1992, Montana Native Plants and Early Peoples, Helena. Montana Historical Society Press, page 33 |
30962 | Prunus virginiana var. demissa (Nutt.) Torr. 3182 | Sioux 238 | b05 73 | 19 | Drug 2 | Hemostat 65 | Dried roots chewed and placed in bleeding wounds. | Blankinship, J. W., 1905, Native Economic Plants of Montana, Bozeman. Montana Agricultural College Experimental Station, Bulletin 56, page 19 |
31609 | Pulsatilla patens ssp. multifida (Pritz.) Zamels 3225 | Thompson 259 | steed28 33 | 474 | Drug 2 | Hemostat 65 | Fresh leaves used to plug nostrils and as an inhalant for nosebleed. | Steedman, E.V., 1928, The Ethnobotany of the Thompson Indians of British Columbia, SI-BAE Annual Report #45:441-522, page 474 |
31610 | Pulsatilla patens ssp. multifida (Pritz.) Zamels 3225 | Thompson 259 | p52 55 | 42 | Drug 2 | Hemostat 65 | Leaves applied to nose for nosebleeds. | Perry, F., 1952, Ethno-Botany of the Indians in the Interior of British Columbia, Museum and Art Notes 2(2):36-43., page 42 |
31611 | Pulsatilla patens ssp. multifida (Pritz.) Zamels 3225 | Thompson 259 | tta90 10 | 246 | Drug 2 | Hemostat 65 | Wool from seed heads mixed with pitch and used inside the nostril for nosebleeds. | Turner, Nancy J., Laurence C. Thompson and M. Terry Thompson et al., 1990, Thompson Ethnobotany: Knowledge and Usage of Plants by the Thompson Indians of British Columbia, Victoria. Royal British Columbia Museum, page 246 |
37422 | Schoenoplectus acutus var. acutus 3603 | Thompson 259 | tta90 10 | 115 | Drug 2 | Hemostat 65 | Burned stalk ashes used on baby's bleeding navel. | Turner, Nancy J., Laurence C. Thompson and M. Terry Thompson et al., 1990, Thompson Ethnobotany: Knowledge and Usage of Plants by the Thompson Indians of British Columbia, Victoria. Royal British Columbia Museum, page 115 |
40580 | Trichostema lanceolatum Benth. 3995 | Tubatulabal 269 | v38 137 | 59 | Drug 2 | Hemostat 65 | Infusion of entire plant snuffed up the nose for nosebleeds. | Voegelin, Ermine W., 1938, Tubatulabal Ethnography, Anthropological Records 2(1):1-84, page 59 |
22177 | Maianthemum stellatum (L.) Link 2382 | Washo 276 | tha41 12 | 139140 | Drug 2 | Hemostat 65 | Powdered root applied to bleeding wounds. | Train, Percy, James R. Henrichs and W. Andrew Archer, 1941, Medicinal Uses of Plants by Indian Tribes of Nevada, Washington DC. U.S. Department of Agriculture, page 139140 |
18761 | Juniperus monosperma (Engelm.) Sarg. 2058 | Zuni 291 | s15 6 | 55 | Drug 2 | Hemostat 65 | Simple or compound infusion of twigs taken after childbirth to stop blood flow. | Stevenson, Matilda Coxe, 1915, Ethnobotany of the Zuni Indians, SI-BAE Annual Report #30, page 55 |
26525 | Phoradendron juniperinum Engelm. ex Gray 2895 | Zuni 291 | s15 6 | 55 | Drug 2 | Hemostat 65 | Simple or compound infusion of twigs taken after childbirth to stop blood flow. | Stevenson, Matilda Coxe, 1915, Ethnobotany of the Zuni Indians, SI-BAE Annual Report #30, page 55 |
39175 | Symphyotrichum lanceolatum ssp. hesperium var. hesperium (Gray) Nesom 3869 | Zuni 291 | s15 6 | 43 | Drug 2 | Hemostat 65 | Smoke from crushed blossoms inhaled for nosebleed. | Stevenson, Matilda Coxe, 1915, Ethnobotany of the Zuni Indians, SI-BAE Annual Report #30, page 43 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE uses ( id INTEGER PRIMARY KEY NOT NULL, species INTEGER NOT NULL, tribe INTEGER NOT NULL, source INTEGER NOT NULL, pageno TEXT NOT NULL, use_category INTEGER, use_subcategory INTEGER, notes TEXT, rawsource TEXT NOT NULL, FOREIGN KEY(use_category) REFERENCES use_categories(id), FOREIGN KEY(use_subcategory) REFERENCES use_subcategories(id), FOREIGN KEY(tribe) REFERENCES tribes(id), FOREIGN KEY(species) REFERENCES species(id), FOREIGN KEY(source) REFERENCES sources(id) );