I ask you, now I have such a member discount list , members of different grades, different discount for different consumption amount, how to design a database table to reflect the rules?

CodePudding user response:

The create table discount (
Member of type varchar (10),
Int, consumption amount
Discount number (1, 2)
)

CodePudding user response:

The create table discount (
Member type,
Lower limit discount,
Discount cap,
The discount value
)