documentation icon indicating copy to clipboard operation
documentation copied to clipboard

combine boards and cross reference?

Open EvilOlaf opened this issue 3 years ago • 2 comments
trafficstars

Mostly a question for @TRSx80: Why there are two tables instead of simply adding a column and merge? Is there a special reason?

EvilOlaf avatar Apr 07 '22 05:04 EvilOlaf

Database normalization.

In other words, combining to one table would result in needing to change the same data on many lines. Compared to how it is now, with the (name/handle cross reference) data in only one (separate) place.

Current representation can be seen as two (database) tables, a boards table and a name lookup table.

TRSx80 avatar Apr 17 '22 22:04 TRSx80

I don't know why that would make a big difference but welp, you maintain it anyways :D

EvilOlaf avatar Apr 18 '22 05:04 EvilOlaf