NameDescriptionTypeAdditional information
PromotionID

Primary key, auto-incremented. database reference = promotions.id

integer

None.

PromotionName

database reference = promotions.promotion_name

string

String length: inclusive between 0 and 150

Coupon

database reference = order_discounts.coupon

string

String length: inclusive between 0 and 50

DiscountAmount

database reference = order_discounts.discount_amount

decimal number

None.