Table coupon restrict

From Zen Cart(tm) Wiki
Jump to: navigation, search

Database Version

1.3.5


Description

Stores all the restrictions regarding specific coupons.


Table Details

Primary Key

restrict_id

Indexed Fields

coupon_id
product_id


Columns

restrict_id Primary Key

A unique, auto incremented value, to identify each restrict id record.
Type: int(11)
Null: No
Default:
Extra: auto_increment


coupon_id Index

Links the specific coupon restrict record to the specific coupon in the coupons table.
Type: int(11)
Null: No
Default: 0


product_id Index

Links the specific coupon restrict record to the specific product in the products table.
Type: int(11)
Null: No
Default: 0


category_id

Links the specific coupon restrict record to the specific category in the categories table.
Type: int(11)
Null: No
Default: 0


coupon_restrict

Is the coupon a restricted coupon? Can be set to N (no) or Y (yes).
Type: char(1)
Null: No
Default: N


Default Entries

None.