Hi all, this my first post here, I have so many categories with three sub-levels, what strategy do you recommend for the structure? I attach a gif to give a better idea, thanks



P.S.
.... maybe for my case since many of the categories defined with 3 sub-levels each formed by a maximum of six elements, I adopt the technique Adjacency List Model

I'd use a self referencing FK.
eg

table categories
ID
Description
ParentID references ID in the same table

see Ask the Expert

or do a google on SQL categor r937
Google

healdem, thanks for the props

i think this is what you had in mind... Categories and Subcategories

I knew it was out there, somewhere.. but could I find it....