# modele-donnees.md

## Tables SQLite

### Table ip
- ip (PK)
- name
- known (bool)
- location
- host
- first_seen
- last_seen
- last_status
- mac
- vendor
- hostname
- open_ports (JSON)

### Table ip_history
- id
- ip (FK)
- timestamp
- status
- open_ports (JSON)

## Index recommandés
- index sur last_status
- index sur ip_history.timestamp