Mostly noting this here for my remembering, though potentially more food
for thought - I double-checked, and the s2categories is basically table 2
in your outline - s2 layer id, category keyword id, an 'active' column
(because I think right now we can deactivate categories, and I can see that
being useful in the future) and... a 'has_subcats' column which I maaaaaaay
have just added on my own db when I was first looking at nested
subcategories (which has kind of been replaced by 'tags').
Of course, now the tricky part is figuring out where the category keyword
id -> name map is....
no subject
Mostly noting this here for my remembering, though potentially more food for thought - I double-checked, and the s2categories is basically table 2 in your outline - s2 layer id, category keyword id, an 'active' column (because I think right now we can deactivate categories, and I can see that being useful in the future) and... a 'has_subcats' column which I maaaaaaay have just added on my own db when I was first looking at nested subcategories (which has kind of been replaced by 'tags').
Of course, now the tricky part is figuring out where the category keyword id -> name map is....