# Filter rules

1. Filter **can be** generated by system
2. Operator decides which filters should be applied

# Product filter sources

| Filter group | Field | Attribute |  Option | Yarn | Patterns | Hooks | Needles |
|--------------|-------|-----------|--------|------|----------|-------|---------|
| color |  |  | ✔ | ✔ |  |  |  |
| yarn-length |  | Length |  | ✔ |  |  |  |
| pin-sze, pin-size-uk, pin-size-us |  | Recommended needles |  | ✔ |  |  |  |
| gauge |  | Gauge |  | ✔ | ✔ |  |  |
| brand | brand |  |  | ✔ | ✔ | ✔ | ✔ |
| category | category |  |  | ✔ | ✔ | ✔ | ✔ |
| quality | category |  |  | ✔ |  |  |  |
| group |  | Yarn Weight |  | ✔ |  |  |  |
| type |  | Type |️  |  | ✔ |  |  |
| designer |  | Designer |  |  | ✔ |  |  |
| wear-size |  | Size |  |  | ✔ |  |  |
| size |  |  | ✔ |  |  | ✔ | ✔ |
| difficulty |  | Difficulty level |  |  | ✔ |  |  |
| material |  | Material |  |  |  | ✔ |  |

# Materialized tables dependencies

| #  | Table |
|----|-------|
| T1 | oc_category |
| T2 | oc_filter |
| T3 | oc_option_value_filter |
| T4 | oc_product |
| T5 | oc_product_filter |
| T6 | oc_product_option_value |
| T7 | oc_product_option_value_to_category |
| T8 | oc_product_to_category |


| # | Materialized table | Dependencies |
|---|--------------------|--------------|
| M1 | oc_product_category | oc_product_to_category <br>oc_product <br>oc_product_option_value_to_category <br>oc_product_option_value |
| M2 | oc_product_category_filter_mode_to_filter | oc_product_category_filter_mode <br>oc_product_filter <br>oc_product_option_value_to_filter |
| M3 | oc_product_category_filter_mode | oc_product_to_category_depth <br>oc_product_to_category <br>oc_product <br>oc_product_option_value_to_category <br>oc_product_option_value |
| M4 | oc_product_category_to_filter | oc_product_category <br>oc_product_filter <br>oc_product_option_value_to_filter |
| M5 | oc_product_option_value_to_filter | oc_product_option_value <br>oc_product <br>oc_option_value_filter <br>oc_filter |
| M6 | oc_product_to_category_depth | oc_product_to_category <br>oc_category <br> |

| #  | T1 | T2 | T3 | T4 | T5 | T6 | T7 | T8 | M1 | M3 | M5 |
|----|----|----|----|----|----|----|----|----|----|----|----|
| M1 |   |   |   | ✔ |   | ✔ | ✔ | ✔ |   |   |   |
| M2 |   |   |   |   | ✔ |   |   |   |   | ✔ | ✔ |
| M3 |   |   |   | ✔ |   | ✔ | ✔ | ✔ |   |   |   |
| M4 |   |   |   |   | ✔ |   |   |   | ✔ |   | ✔ |
| M5 |   | ✔ | ✔ | ✔ |   | ✔ |   |   |   |   |   |
| M6 | ✔ |   |   |   |   |   |   | ✔ |   |   |   |