# DB Schema

SQLite database: `logs/stdapp.sqlite`

## roles
- id INTEGER PK
- name TEXT UNIQUE NOT NULL

## users
- id INTEGER PK
- username TEXT UNIQUE NOT NULL
- password_hash TEXT NOT NULL
- role_id INTEGER FK -> roles.id