[ic] Database Schema notes

Dan Busarow dan at buildingonline.com
Mon Dec 9 18:19:00 UTC 2013

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 Busarow
  888-496-6648 ext 218

On 12/9/13, 11:03 AM, Spencer Christensen wrote:
> Coming into this late- could product_class represent a product's Brand
> or Manufacturer?  Because I don't see those in the schema anywhere else.
> On 12/09/2013 10:14 AM, Stefan Hornburg (Racke) wrote:
>> On 12/01/2013 12:15 PM, Stefan Hornburg (Racke) wrote:
>>> On 10/15/2013 02:02 AM, Josh Lavin wrote:
>>>> Hello ic-users,
>>>> At the Ecommerce Innovation conference we had a rountable discussion
>>>> regarding the database schema for Interchange 6 / Nitesi.
>>>> You can see the original schema which we discussed here:
>>>> https://metacpan.org/module/HORNBURG/Nitesi-DBI-0.0092/lib/Nitesi/Database/Schema.pod
>>>> Following are my notes from the disussion. You can also find them as a
>>>> Github Gist here (if you want to fork, etc):
>>>> https://gist.github.com/perusionjosh/6984222
>>>> It is possible that I misquoted participants or got things wrong, so
>>>> feel free to provide corrections!
>>> Does anyone remember why we added "product_classes" ? Just to distinguish products
>>> by manufacturers?
>> OK, if no one gives feedback on this we will remove the product classes from the schema.
>> Regards
>> 	Racke

More information about the interchange-users mailing list