|
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.ProductCategories
Result
|
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 |