Digital content eCommerce schema advice? I don't have much experience designing databases, I'm looking for some advice on my design from more seasoned designers/developers. I'm developing a digital content eCommerce store which will be desktop based and mobile based similar to iTunes.

Schema


The store will most work like iTunes, it's just that it's focused on music at the moment. I'm not sure if I should explain each table responsibility. Users can reload monetary credits to their profiles from an external application.

Please advice if this design will work and is sufficient. Thank You.
Get yourself a good data model pattern book.
Accept the fact that most relationships are many-to-many.
Read up on table inheritance and the Party/Party Role model.


Some starting points:


An order has many line items, which belong to a product
A product will probably belong to multiple categories
A product will likely have more than one artist