# Database layout

- `postgres/` — PostgreSQL persistent data volume
- `init/` — bootstrap SQL for extensions, schema, and retention helpers

Bootstrap now enables:
- `postgis`
- `pgcrypto`
- core FR24 ingest schema under `fr24`

Schema objects:
- `captures`
- `raw_packets`
- `aircraft`
- `flights`
- `tracks`
- `track_points`
- `processing_state`
- `noise_results`

Notes:
- `raw_packets` is partitioned by `partition_date`
- raw retention target is 3 days
- no runtime is started from this repository during preparation