issued
logical
target
subject
users
int
id
PK
text
username
UK
text
password_hash
text
role
timestamp
created_at
sessions
events
int
id
PK
text
router_id
text
event_type
text
payload_json
timestamp
created_at
routers
commands
text
id
PK
text
router_id
text
command
text
args_json
text
status
text
result_json
timestamp
created_at
timestamp
completed_at
alerts
int
id
PK
text
router_id
text
kind
text
message
bool
acknowledged
timestamp
created_at
timestamp
acknowledged_at