ProductCategories
Column | Format | Unique value | Contents |
|---|---|---|---|
Level | int | Level of category; maximum level is 4. | |
Id | varchar(5) |
| ID of the category. |
ParentID | varchar(5) | ID of the parent category, null for top level categories. | |
Name | varchar(40) | Name of the category. |
Example Data
Query
SQL
SELECT TOP 10 *
FROM dbo.ProductCategoriesResult
Level | Id | ParentId | Name |
|---|---|---|---|
1 | 10 | NULL | VAATTEET |
1 | 25 | NULL | PEHMEÄT |
2 | 100 | 10 | TAKIT |
2 | 101 | 10 | HOUSUT |
2 | 102 | 10 | SADEASUT |
2 | 250 | 25 | TAKIT |
2 | 251 | 25 | HOUSUT |
3 | 1000 | 100 | TAKKI |
3 | 1001 | 100 | N VILLAKANGASTAKIT |
3 | 1008 | 100 | M VILLAKANGASTAKIT |
3 | 25000 | 250 | UNTUVATAKIT |