| category_id |
varchar(768) |
category node ID |
| marketplace |
varchar(768) |
amazon marketplace |
| active |
boolean |
if category is active on Amazon with associated ASINs |
| category_name |
varchar(768) |
name of category |
| root_category_id |
int |
root/department category ID, aka Parent category |
| root_category_name |
string |
name of root category_id aka parent category |
| preceding_category_id |
int |
category ID of one level up in the hierarchy |
| path_by_id |
varchar(768) |
path from root level to indexed category ID as a string |
| path_by_id_array |
array(int) |
path from root level to indexed category ID as an array |
| path_by_name |
varchar(768) |
path from root level to indexed category name as a string |
| path_by_name_array |
array(varchar) |
path from root level to indexed category name as an array |
| level |
int |
levels below root category. i.e. Root category is level 0 |
| sub_category_count |
int |
count of categories below indexed record |
| start_date |
date |
start of evaluation period - matches sales estimates and asin metadata tables |
| end_date |
date |
end of evaluation period - matches sales estimates and asin metadata tables |
| updated_at |
date |
date of last update |