Skip to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

The price of a product in time

El_Pablo
in Relationships

Featured Replies

Hi,

How would you model the structure of the tables to know what was the price of a product in time? In a billing system it's important to keep the price up to date and also keep the price paid for a product for a specific time.

This is one of my approach

products (pkProductID, price (lookup from prices), ...)

prices (pkPriceID, fkProductIDprice, date, ...)

billDetail (fkProductID, fkBillID, price (lookup from product), ...)

Thanx for any other suggestion.

The price in Products is redundant. The line item (billDetail) can lookup directly from Prices, based on ProductID and either the date or just the most recent price (depending on whether you have future prices and/or bill retroactively).

  • Author

To get the most recent price, I will need to create a script? I'm I right or there's another way?

No, not at all - just sort the relationship by date (or by PriceID), descending.

  • Author

Yeah that's true!

Create an account or sign in to comment
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Account

Navigation

Search

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.