On Sun, 19 Jun 2022 at 08:35, Håvard F. Aasen via Emc-developers <emc-developers@lists.sourceforge.net> wrote:
> As this is described, it seems to me that toolID really is a description, > and T_number could be used as the primary key, like so > toolID INTEGER PRIMARY KEY, -- alias T_number > description TEXT > Does this suggestion has any unintended side effect? Not completely sure > the reasoning behind the original table layout. You have to bear in mind how the tools are called up from the G-code. M6 T6 There is only a single integer passed to whatever selects the tool. And if T6 is a 6mm square ended milling cutter (for example) it is quite likely that you don't care _which_ 6mm square ended cutter you get. You would generally be perfectly happy to get the nearest, the least worn, the one actually in the active carousel, or one chosen by some other criterion. So, the tool _number_ as associated with the G-code T-command is very deliberately _not_ a key but a "property." -- atp "A motorcycle is a bicycle with a pandemonium attachment and is designed for the especial use of mechanical geniuses, daredevils and lunatics." — George Fitch, Atlanta Constitution Newspaper, 1912 _______________________________________________ Emc-developers mailing list Emc-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/emc-developers
