Folio fortepan/hu

{
    "folio": {
        "code": "_bootstrap/_bootstrap",
        "label": null,
        "dataset_key": null,
        "row_count": 0
    },
    "cores": [
        {
            "code": "obj",
            "label": null,
            "row_count": 100
        }
    ],
    "dtoTables": [
        {
            "id": "_bootstrap/_bootstrap:dto_photograph",
            "name": "dto_photograph",
            "kind": "dto",
            "core_code": "obj",
            "dto_type": "photograph",
            "label": "Photograph",
            "description": null,
            "row_count": 100
        }
    ],
    "views": [
        "dto_photograph"
    ],
    "generatedAt": "2026-06-02T00:43:35+00:00",
    "metadata": {
        "archivePreparedAt": "2026-06-02T00:43:35+00:00",
        "schema": {
            "tables": 2,
            "properties": 64
        },
        "views": {
            "views": 1
        }
    }
}

# Folio _bootstrap/_bootstrap

_bootstrap/_bootstrap

- Dataset key: ``
- Rows: 0
- Cores: 1
- Observed DTO tables: 1

## Cores

| Core | Label | Rows |
| --- | --- | ---: |
| `obj` | obj | 100 |

# Observed Schema

## `dto_photograph`

- Core: `obj`
- DTO type: `photograph`
- Rows: 100

| Field | Type | Flags | Description |
| --- | --- | --- | --- |
| `sourceId` | `int` |  |  |
| `contentType` | `?string` |  |  |
| `aggregator` | `?string` |  |  |
| `dctermsDate` | `int` |  |  |
| `dctermsDescription` | `string` |  |  |
| `dctermsSource` | `string` |  |  |
| `dctermsLicense` | `string` |  |  |
| `iiifBase` | `?string` |  | IIIF Image API base URL — use for AI vision and imgProxy resizing |
| `country` | `?string` |  |  |
| `city` | `?string` |  |  |
| `schemaLatitude` | `float` |  |  |
| `schemaLongitude` | `float` |  |  |
| `sourceTags` | `json` |  |  |
| `sourceTagsHu` | `json` |  |  |
| `donorId` | `int` |  |  |
| `countryId` | `int` |  |  |
| `cityId` | `int` |  |  |
| `id` | `?string` |  |  |
| `date` | `?string` |  | dcterms:date — display string, may be fuzzy ("ca. 1920") |
| `description` | `?string` |  | dcterms:description — short curatorial text from the source institution |
| `rightsUri` | `?string` |  | dcterms:license URI (rightsstatements.org) |
| `sourceUrl` | `?string` |  |  |
| `latitude` | `?float` |  |  |
| `longitude` | `?float` |  |  |
| `source` | `string` |  | Source of this data: import \| ai \| ocr \| human |
| `title` | `?string` |  | dcterms:title |
| `ai:denseSummary` | `string` |  |  |
| `language` | `?string` |  | dcterms:language |
| `content_type` | `string` |  |  |
| `denseSummary` | `?string` |  | ai:denseSummary — ≤ 400 char retrieval-optimised summary. Entity-rich, factual, no filler. Used by Meilisearch /chat, RAG, chatbots. / |
| `confidence` | `?float` |  | Confidence 0.0–1.0 (null = certain, i.e. human-entered) |

# Query Guide

This folio stores canonical rows in `item` and observed field metadata in `schema_table` / `schema_property`.

```sql
select * from schema_table where kind = 'dto';
select * from schema_property where table_id = ? order by position;
select local_id, label, dto_type, dto_data, extras from item limit 20;
```

Convenience views are generated from observed DTO fields:

```sql
select * from dto_photograph limit 20;
```