`entity_id`, - unique id
`entity_type_id`, - I guess its 3 for all categories
`attribute_set_id`, - I guess its 3 too for all categories
`parent_id`, - For root i guess its 1
`created_at`, - timestamp
`updated_at`, - timestamp
`path`, - root cate id/sub cat id/sub cat id ..etc..
`position`, - ????
`level`, - I guess its depth 1/2/3/4 path will have depth 3
`children_count` - How many children categories a parent category have…
So can anyone help me to understand that position attribute?
Position is a sort order of the category in the menu or category tree within any specific parent category.
So you may have categories sorted alphabetically or specify position and have them sorted according to your needs.
As I know it is not required and you can leave default values there.