search

sde1000 / quicktill

Figure out where all the money and stock went to
GNU General Public License v3.0
43 stars 8 forks source link

Table of till instances #279

Closed sde1000 closed 7 months ago

sde1000 commented 7 months ago

Currently when a register starts it invents itself a guid, which is used in the User.register column to detect when a user moves from one register to another.

Apart from the transient entries in User.register, these guids aren't stored anywhere. Tools that watch the Users table (eg. the new "monitor" subcommand) can't display any further information about the register a user has moved to.

We could add a table of till instances, with primary key being the register guid and additional columns being things like software version, startup time, configuration name and terminal name, to enable more information to be displayed. A row would be added to this every time the register is started.

Possibly we could make User.register be a relationship to the instances table?

The instances table could be purged once entries are eg. a month old.

sde1000 commented 7 months ago

Actually, if we're adding a table then why bother with guids any more? Just use an integer as the primary key.