29 lines
345 B
Markdown
Executable File
29 lines
345 B
Markdown
Executable File
# 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
|