# Schema Decision Record

## Change
- Tables / views / functions affected:
- Reason for change:
- Reviewer:
- Date:

## Model summary
- Ownership model:
- Core relationships:
- Required constraints:
- Defaults / timestamps:
- Audit needs:

## Design review
| Topic | Current | Decision | Reason |
|---|---|---|---|
| Naming |  |  |  |
| PK / FK design |  |  |  |
| Nullable vs required |  |  |  |
| Enum vs lookup |  |  |  |
| View vs table |  |  |  |
| Derived data |  |  |  |

## Operational impact
- Migration shape:
- Data backfill needed:
- API / contract impact:
- Performance considerations:
- Security / RLS considerations:

## Alternatives considered
- 
- 

## Open risks
- 
- 

## Final decision
- Approved / revise / split / reject
