search

nycmeshnet / meshdb

A convenient, stable, and sane database for tracking Members and Nodes for use with robots and humans
https://db.nycmesh.net
MIT License
11 stars 13 forks source link

Add a way to track who has the POE adapter #186

Open Andrew-Dickinson opened 8 months ago

Andrew-Dickinson commented 8 months ago

Add a way to track which member has the PoE adapter so that we can figure out who to call when it goes down unexpectedly

From Lydon in slack:

Could we include a field for "POE Supply" on each node? This could help us keep track of where power sources are, specifically when devices are offline and we can't just look at the device notes. (Including a "Port" field could do this for omni's as well, but I'm thinking mainly for netpowers etc.). Saves scrolling through chat or guessing who was the first install and should be on port 1. We'd have to keep it up to date, but maybe that's something that could be included in a "post install" form that installers fill out.

Andrew-Dickinson commented 8 months ago

Some wrinkles: this could be more than one person in the case of a Netpower install

WillNilges commented 8 months ago

This should be covered by the new model through powered_by_install.

https://wiki.mesh.nycmesh.net/books/services-software/page/meshdb-schema-design

Andrew-Dickinson commented 2 months ago

Perhaps we should also track which port on which device a given install is connected to, I could see an optional pair of fields, one a foreign key to device, the other a string field for the port name / number working well?

Andrew-Dickinson commented 2 months ago

https://nycmesh.slack.com/archives/C06GW3Q92TY/p1724821395717539