> ## Documentation Index
> Fetch the complete documentation index at: https://exegia.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Database Schema

> The corpora table and how to query it

## The corpora table

| Column         | Type     | Description                 |
| -------------- | -------- | --------------------------- |
| `id`           | `uuid`   | Primary key                 |
| `name`         | `text`   | Unique identifier           |
| `type`         | `text`   | bible, commentary, lexicon  |
| `language`     | `text`   | hebrew, greek, arabic, etc. |
| `period`       | `text`   | Historical period           |
| `repository`   | `text`   | Source URL                  |
| `category`     | `text[]` | biblical, religious, etc.   |
| `download_uri` | `text`   | Storage URL                 |

## Example queries

```sql theme={null}
-- Query corpora by language
SELECT name, type, language, period
FROM corpora
WHERE language = 'hebrew'
ORDER BY created_at DESC;
```

## Security

* **Row-level security** is enabled on the `corpora` table.
* **Reads are public** — anyone with the anon key can query corpora.
* **Writes are auth-protected** — inserting, updating, or deleting rows requires authentication.

## Migrations and seeds

* Database schema lives in ordered SQL migrations under `supabase/migrations/`.
* Seed data provides **30+ pre-loaded corpora** under `supabase/seeds/` for local development and testing.

```bash theme={null}
# Reset the database and re-run all migrations + seeds
supabase db reset
```