Install Folio

bin/console folio:pull --dataset smith/hac

Link Types

Forward Reverse Links
coll contains obj
contains
obj belongs_to coll
belongs_to
494
per created obj
created
obj created_by per
created_by
12

Observed Schema

Name Core Type Rows
dto_coll_collection coll collection 3
dto_object obj object 430
dto_per_org per org 9

Archive Docs

Folio Metadata json
{
    "folio": {
        "code": "smith/hac",
        "label": "HAC",
        "dataset_key": "smith/hac",
        "row_count": 442
    },
    "cores": [
        {
            "code": "coll",
            "label": null,
            "row_count": 3
        },
        {
            "code": "obj",
            "label": null,
            "row_count": 430
        },
        {
            "code": "per",
            "label": null,
            "row_count": 9
        }
    ],
    "dtoTables": [
        {
            "id": "smith/hac:dto_coll_collection",
            "name": "dto_coll_collection",
            "kind": "dto",
            "core_code": "coll",
            "dto_type": "collection",
            "label": "Collection",
            "description": "A collection / series \u2014 an aggregation of items rather than a single object.\nTwo producers: the \"folio of folios\" (each row is a whole folio) and aggregators like the\nSmithsonian that expose collections and series alongside objects. Unlike a generic item, a\ncollection is browsed by its dataset-level descriptors \u2014 provider, country, language, size \u2014\nso those are promoted to facets here. `subjects` (a parent facet) carries the dtoType mix.\n/",
            "row_count": 3
        },
        {
            "id": "smith/hac:dto_object",
            "name": "dto_object",
            "kind": "dto",
            "core_code": "obj",
            "dto_type": "object",
            "label": "Artifact",
            "description": "Three-dimensional physical objects and artifacts that do not fit a more specific type: tools, vessels, garments, specimens, etc.",
            "row_count": 430
        },
        {
            "id": "smith/hac:dto_per_org",
            "name": "dto_per_org",
            "kind": "dto",
            "core_code": "per",
            "dto_type": "org",
            "label": "Org",
            "description": "Concrete BaseItemDto for subjects whose content type is unknown or mixed.\nUse when no domain-specific DTO subclass applies.\n/",
            "row_count": 9
        }
    ],
    "views": [
        "dto_coll_collection",
        "dto_object",
        "dto_per_org"
    ],
    "generatedAt": "2026-06-29T18:03:32+00:00",
    "metadata": {
        "archivePreparedAt": "2026-06-29T18:03:32+00:00",
        "schema": {
            "tables": 6,
            "properties": 31
        },
        "views": {
            "views": 3
        }
    }
}
Overview md
# Folio smith/hac

HAC

- Dataset key: `smith/hac`
- Rows: 442
- Cores: 3
- Observed DTO tables: 3

## Cores

| Core | Label | Rows |
| --- | --- | ---: |
| `coll` | coll | 3 |
| `obj` | obj | 430 |
| `per` | per | 9 |
Observed Schema md
# Observed Schema

## `dto_coll_collection`

- Core: `coll`
- DTO type: `collection`
- Rows: 3

A collection / series — an aggregation of items rather than a single object.
Two producers: the "folio of folios" (each row is a whole folio) and aggregators like the
Smithsonian that expose collections and series alongside objects. Unlike a generic item, a
collection is browsed by its dataset-level descriptors — provider, country, language, size —
so those are promoted to facets here. `subjects` (a parent facet) carries the dtoType mix.
/

| Field | Type | Flags | Description |
| --- | --- | --- | --- |
| `id` | `?string` |  |  |
| `contentType` | `?string` |  |  |
| `stage` | `?string` | filterable, facet | Pipeline processing stage (raw / normalized / enriched). A facet so you can filter to enriched items; later this can be made dev-only. |
| `title` | `?string` |  | dcterms:title |
| `pageCount` | `?int` | sortable | Number of pages in the document. |
| `source` | `string` |  | Source of this data: import \| ai \| ocr \| human |

## `dto_object`

- Core: `obj`
- DTO type: `object`
- Rows: 430

Three-dimensional physical objects and artifacts that do not fit a more specific type: tools, vessels, garments, specimens, etc.

| Field | Type | Flags | Description |
| --- | --- | --- | --- |
| `id` | `?string` |  |  |
| `sourceUrl` | `?string` |  |  |
| `contentType` | `?string` |  |  |
| `stage` | `?string` | filterable, facet | Pipeline processing stage (raw / normalized / enriched). A facet so you can filter to enriched items; later this can be made dev-only. |
| `title` | `?string` |  | dcterms:title |
| `description` | `?string` |  | dcterms:description — short curatorial text from the source institution |
| `credit` | `?string` |  | Credit line / acknowledgment, e.g. "Gift of the Brooklyn Museum of Art, Paul F. Walter Collection". |
| `citationUrl` | `?string` |  | ItemField::CITATION_URL — deep link back to the source record (e.g. the NARA catalog page). Rendered as the "Original" link on the folio item page. |
| `rights` | `?string` |  | dcterms:rights |
| `genreSpecific` | `?array` | filterable, facet | Specific genre/form terms (MODS genre @specific) — e.g. ["Albumen prints"]. A facet. |
| `iiifBase` | `?string` |  | IIIF Image API base URL — use for AI vision and imgProxy resizing |
| `thumbnailUrl` | `?string` |  |  |
| `largeImageUrl` | `?string` |  |  |
| `pageCount` | `?int` | sortable | Number of pages in the document. |
| `source` | `string` |  | Source of this data: import \| ai \| ocr \| human |
| `dimensions` | `?array` |  | MuseumVocab::DIMENSIONS — structured dimension records. Each entry: {height?, width?, length?, depth?, radius?, units, name?} where height/width/length/depth/radius are numeric values in `units` (e.g. "cm", "in", "mm"). `name` is an optional label like "framed", "sight", "with mount", etc. Producers should emit only the keys present on the source record. / |
| `dimensionsRaw` | `?string` |  | Original free-text dimensions string from the source, kept as a fallback when the normalizer cannot fully parse it (e.g. fractional inches, museum-specific shorthand). Templates may render this verbatim when `$dimensions` is empty. / |
| `accession` | `?string` |  | MuseumVocab::ACCESSION — local accession / catalog number |
| `creators` | `?array` |  | dcterms:creator — array of names |

## `dto_per_org`

- Core: `per`
- DTO type: `org`
- Rows: 9

Concrete BaseItemDto for subjects whose content type is unknown or mixed.
Use when no domain-specific DTO subclass applies.
/

| Field | Type | Flags | Description |
| --- | --- | --- | --- |
| `id` | `?string` |  |  |
| `contentType` | `?string` |  |  |
| `stage` | `?string` | filterable, facet | Pipeline processing stage (raw / normalized / enriched). A facet so you can filter to enriched items; later this can be made dev-only. |
| `title` | `?string` |  | dcterms:title |
| `pageCount` | `?int` | sortable | Number of pages in the document. |
| `source` | `string` |  | Source of this data: import \| ai \| ocr \| human |
Query Guide md
# 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_coll_collection limit 20;
```

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

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