[ic] Database Schema notes

[Stefan Hornburg (Racke)]

On 12/09/2013 07:19 PM, Dan Busarow wrote:
> Another late response.  When I was doing POS software in an earlier life, in addition to Category/Subcategory we also had
> 
>   Department / Class / Line
> 
> This was for department stores, example
> 
>   Sporting Goods / Baseball / Spaulding
> 
> This was brick and mortar stuff so it was used only for reporting.   I can see the utility for additional search criteria too.
> 
> Dan

Navigation schema supports multiple hierarchies, so this shouldn't be a problem.
The only tricky thing is how to determine the "main" category for an item and store this information into
the schema.

Regards
	Racke

-- 
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team