Description
The items should have categories. Categories, in turn, should also be able to be a part of other categories, etc. There should be also a way to attach behavior to items of specific categories (e.g. increase attendances counter, when a subscriptions is being bought). There should also be build-in categories with items having additional fields (e.g. subscriptions).
Advantages
Ability to manage large lists of items.
Disadvantages
Inheritance in RDBMS is not an easy task.
Implementation Draft
- Add an extra field in the item entity to signify a custom category.
- Use this field to signify build-in category with inheritance.
Description
The items should have categories. Categories, in turn, should also be able to be a part of other categories, etc. There should be also a way to attach behavior to items of specific categories (e.g. increase attendances counter, when a subscriptions is being bought). There should also be build-in categories with items having additional fields (e.g. subscriptions).
Advantages
Ability to manage large lists of items.
Disadvantages
Inheritance in RDBMS is not an easy task.
Implementation Draft