# Notion Site Logbook — Structure

## Database 1: Sites
One entry per job site.

**Properties:**
- Site Name (title) — e.g. "Arncliffe — Ford Civil"
- Client/Builder (text) — e.g. "Ford Civil"
- Address (text)
- Status (select): Active / Complete / On Hold
- Start Date (date)
- End Date (date)
- Foreman (text)
- Engineer (text)
- Site Contact (phone)
- Notes (rich text)
- Cover Photo (files)

## Database 2: Daily Logs
One entry per day worked. Linked to Sites.

**Properties:**
- Date (date)
- Site (relation → Sites)
- Crew (multi-select) — Rocky, Mike, etc.
- Start Time (text)
- Finish Time (text)
- Break (text)
- Hours (number)
- Work Description (rich text)
- Day Works Y/N (checkbox)
- Issues (rich text) — delays, wrong marks, weather
- Tomorrow's Plan (rich text)
- Photos (files)

## Database 3: Contacts
People at each site. Linked to Sites.

**Properties:**
- Name (title)
- Role (select): Foreman / Engineer / Supervisor / Labourer / Subbie / Client
- Company (text)
- Phone (phone)
- Site (relation → Sites)
- Notes (rich text)

## Views

### Sites DB:
- Gallery view (cover photos, status badges)
- Active sites filtered view

### Daily Logs DB:
- Calendar view (see work across weeks)
- Table view filtered by site
- This week view

### Contacts DB:
- Table grouped by site
- Table grouped by role