# INVEETAIRE — Database Schema Changelog

> **Format:** Semantic Versioning (MAJOR.MINOR.PATCH)  
> **Convention:** Follow [Keep a Changelog](https://keepachangelog.com/en/1.0.0/)

---

## [Unreleased]

_No pending changes._

---

## [v1.0.0] — 2026-07-21

### Added
- Initial schema documentation for all 43 tables
- `docs/database/README_SCHEMA.md` — Schema architecture overview
- `docs/database/AI_CONTEXT.md` — Business domain guide
- `docs/database/RELATIONSHIP.md` — Entity relationship documentation
- `docs/database/schema.sql` — Documentation-only schema snapshot
- `docs/database/tables/` — 43 individual table documentation files

### Notes
- This entry documents the existing production schema as of DX001
- No structural database changes were introduced in this sprint
- Supabase integration documentation deferred to DX002

---

## Future Entry Template

```markdown
## [vX.Y.Z] — YYYY-MM-DD

### Added
- New table: `table_name` — Description of purpose
- New column: `table_name.column_name` — Description

### Modified
- `table_name.column_name` — Changed from X to Y, reason: ...

### Removed
- Column `table_name.column_name` — No longer needed because ...
- Table `table_name` — Replaced by `new_table_name`

### Deprecated
- `table_name.column_name` — Will be removed in vX.Y.Z, use `new_column` instead

### Notes
- Migration: run `database/migrations/vX.Y.Z_description.sql`
- Breaking: any breaking changes noted here
```

---

## Version Guide

| Increment | When to use |
|-----------|-------------|
| **MAJOR** (X) | Breaking schema change — column removed, type changed, table renamed/removed |
| **MINOR** (Y) | Non-breaking addition — new table, new nullable column, new index |
| **PATCH** (Z) | Documentation fix — no schema change, just docs update |