Databases > pubs > Tables > discounts

pubs

discounts

Created: Modified:

Columns

  • discounttype
    [varchar](40) NOT NULL
  • stor_id
    [char](4) NULL
  • lowqty
    [smallint] NULL
  • highqty
    [smallint] NULL
  • discount
    [decimal](4, 2) NOT NULL

Foreign Keys

  • FK__discounts__stor___3C69FB99
    stores
    stor_id ⥱ stor_id

Sample Data

discounttype
stor_id
lowqty
highqty
discount
Initial Customer
NULL
NULL
NULL
10.5
Volume Discount
NULL
100
1000
6.7
Customer Discount
8042
NULL
NULL
5