-
One item with two prices or two expiry dates
I have a problem and I can't solve it.
Its about designing a database with table where items are stored, but those items can be with more than one selling price - two and more, or those items can be with more than one expiring date.
For example, one article once can come with 20 dollars price, 30 pieces. After some days, the same article can come with 30 dollars price, 10 pieces. BUT, the problem is that there are still articles for 20 dollars!
-
Maybe add a subid column to the table and enter them as different row with proper subid?
-
Or maybe a id / quantity snowflake?
A table with the unit id, a separate (snowflaked) table joined by that id, that contained the id paired with the distinct quantities / ranges , and the price on each distinct row of the snowflake.
Just the kind of thing I would do to support OLAP, etc., but maybe of use to you here, as well.
HTH,
B*
-
Any success?
Were you able to get anywhere with meeting your requirement? Let us know if we can help further ...
Bill
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|