# Data Model

## Core App

| Model | Description |
|-------|-------------|
| `Aircraft` | Central fleet inventory (UUID primary key) |
| `AircraftNote` | Notes attached to aircraft with timestamps; `public` flag controls share-link visibility |
| `AircraftEvent` | Audit trail of all changes to aircraft data |
| `AircraftRole` | Per-aircraft user roles (`owner` or `pilot`) |
| `AircraftShareToken` | Share link tokens with privilege level (`status` or `maintenance`), optional expiry, and optional label |

## Health App

| Model | Description |
|-------|-------------|
| `ComponentType` | Component categories (consumable flag) |
| `Component` | Parts with TBO, inspection, and replacement tracking; supports parent-child hierarchy |
| `DocumentCollection` | Logical document groupings |
| `Document` | Maintenance documentation by type |
| `DocumentImage` | Individual pages/images within documents |
| `LogbookEntry` | Maintenance log entries with hours, dates, and file attachments |
| `Squawk` | Maintenance defects with priority levels and optional component link |
| `InspectionType` | Recurring inspection requirements with hour/day intervals |
| `InspectionRecord` | Inspection completion records |
| `AD` | Airworthiness Directives with recurrence settings |
| `ADCompliance` | AD compliance records |
| `MajorRecord` | Major repair and alteration records |
| `ConsumeableRecord` | Oil/fuel consumption records |

## Relationships

```
Aircraft (central hub)
├── AircraftNote (1:N)
├── AircraftEvent (1:N)
├── AircraftRole (1:N) → User
├── AircraftShareToken (1:N)
├── Component (1:N)
│   ├── ComponentType (N:1)
│   ├── Parent Component (self-reference)
│   └── Squawk (1:N, optional link)
├── Squawk (1:N)
├── LogbookEntry (1:N)
├── Document (1:N)
│   ├── DocumentCollection (N:1, optional)
│   └── DocumentImage (1:N)
├── InspectionType (1:N)
├── InspectionRecord (1:N)
├── AD (1:N)
├── ADCompliance (1:N) → AD
├── MajorRecord (1:N)
└── ConsumeableRecord (1:N)
```

## Component Hours Fields

| Field | Purpose | Reset on service? |
|-------|---------|-------------------|
| `hours_in_service` | Hours since last replacement | Yes — `replacement_critical` only |
| `hours_since_overhaul` | Hours since last overhaul/rebuild | No — only on major overhaul |

## Component Critical Flags

| Flag | Tracked via | Purpose |
|------|-------------|---------|
| `replacement_critical` | `replacement_hours` + `hours_in_service` | Periodic replacement (oil, filters) |
| `tbo_critical` | `tbo_hours` + `hours_since_overhaul` | Time between overhauls (engines, props) |
| `inspection_critical` | `InspectionType` records | Requires periodic inspections |

## Squawk Priorities

| Value | Label | Color |
|-------|-------|-------|
| 0 | Ground Aircraft | Red |
| 1 | Fix Soon | Orange |
| 2 | Fix at Next Inspection | Blue |
| 3 | Fix Eventually | Grey |

## Share Token Privilege Levels

| Level | Data Visible |
|-------|-------------|
| `status` | Overview, airworthiness, active squawks, public notes, current AD/inspection status, oil/fuel, public documents |
| `maintenance` | Everything in `status` + full history (logbook, AD/inspection history, resolved squawks, major records) |