← All tables and views

Pubs table

discounts

Initial, volume, and store-specific sales discounts.

3rows

5 columns

Schema from the provider contract
ColumnTypeNullableKeyReferences
discounttypeVARCHAR(40)no——
stor_idCHAR(4)yes—stores.stor_id
lowqtyINTEGERyes——
highqtyINTEGERyes——
discountDECIMAL(4,2)no——

Data preview

Sample records

3 rows available
discounttypestor_idlowqtyhighqtydiscount
Customer Discount8042NULLNULL5
Initial CustomerNULLNULLNULL10.5
Volume DiscountNULL10010006.7

Interactive explorer

Explore discounts

Powered by DataTug