> For the complete documentation index, see [llms.txt](https://pecan.gitbook.io/betydb-data-access/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://pecan.gitbook.io/betydb-data-access/appendix-full-search-details.md).

# Appendix: Full Search Details

## List of searchable columns in each table

### Search page

On the main search page, the search covers the following fields:

* Scientific name&#x20;
* Common name&#x20;
* Trait&#x20;
* Trait description&#x20;
* City&#x20;
* Site name&#x20;
* Author&#x20;
* Cultivar&#x20;
* Entity

## List of Rails associations pertaining to cross-table API queries

## Specification of result formats

### The CSV format

### The XML format

### The JSON format

### Regular expressions in API queries
