Database — Overview
The database is the structured core of Pachurros. It works for anything you can think of in rows and columns — shot lists, equipment lists, contacts, tasks, budget overviews, image sequences, and more.
What makes up a database
Section titled “What makes up a database”Every database consists of:
- Rows — a single entry (e.g. a subject, a task, an appointment)
- Columns — properties of each entry (e.g. status, date, assignee)
- Views — different ways to display the same data
You can create as many views of the same database as you like and switch between them freely. The data is always the same — only the presentation changes.
Views at a glance
Section titled “Views at a glance”| View | Best used for |
|---|---|
| Table | Full overview, many columns visible at once |
| Kanban | Workflow status, task management |
| Gallery | Image-based content, visual overview |
| Calendar | Scheduling, shooting days |
| Timeline | Project duration, phases and milestones |
| Map | Location-based data, shooting locations |
Creating a new database
Section titled “Creating a new database”- Click + New Database in the sidebar
- Give it a name
- Optionally select a starter template
Adding an entry
Section titled “Adding an entry”- In Table view: Click + New Row at the bottom
- In Kanban view: Click + below a column
- In Gallery: Click + New Entry
Opening a row
Section titled “Opening a row”Click on a row (or the open icon) to see the detail view — all fields, comments, and attached media.
Further topics
Section titled “Further topics”- Column types — all 13 types explained
- Configure views — filters, sorting, grouping
- Comments & cells — collaboration at the row level
- Calendar subscription (iCal) — subscribe to calendar views