Reference
Data reference
The tables and columns behind pages, layouts, media, redirects and menus.
The tables Aurora keeps content in, for imports, reports and queries. Use the models (Aurora\Models\…) to write: they keep the history, search index and caches up to date. Ids are UUIDs, and the fields marked per language are JSON keyed by language code ({"en": "About us", "nb": "Om oss"}).
pages
| Column | Holds |
|---|---|
title, slug, excerpt, meta_title, meta_description | Per language |
blocks | One flat list for every language, each block {id, type, data, parent, slot, settings} |
block_translations | Block text in other languages, text only: {"nb": {"<block id>": {"<field>": "…"}}} |
settings | The layouts' own fields, by view: {"layouts": {"<view>": {…}}} |
locales | The languages the page is written in |
status, published_at, unpublish_at | draft, review or published, and the dates that schedule it |
layout_id, parent_id, site_id, is_homepage | Its layout, parent page, site, and whether it's the homepage |
og_image, noindex, exclude_from_search | The share image (an asset id), and whether it's hidden from search engines and from site search |
password, members_only | A password (hashed), or signed-in visitors only |
working_copy, working_copy_by_id, working_copy_at | Unpublished changes to a live page, and who saved them when |
author_id, last_edited_by_id | Who wrote it, and who changed it last |
The other tables
| Table | Columns |
|---|---|
layouts | name, handle, description, icon, view, is_default, sort, and class for a layout defined in code |
assets | title, alt and caption (per language), credit, focal_point, folder_id, mime_type, disk, access; folders in asset_folders, where each file is used in asset_usages |
redirects | from_path, and where it goes: page_id, asset_id or to_url; status_code, hits, last_hit_at, site_id |
menus | name, is_visible, site_id; where each is shown in menu_locations (location) |
menu_items | menu_id, parent_id, title (per language), linkable_type and linkable_id (a page) or url, icon, classes, rel, target, order |
settings | key and value (JSON); read them with Setting::get() |
language_lines | The admin's labels: group, key, text (per language) and imported |