Table coupon restrict

• Introduction
• Resources | Standards

• Database
• Schema

• Developers API
• Resources | Overrides |
• Tutorials

• Modules
• Overview | Payment |
• Shipping | Order Total

• Miscellaneous
• Security | XML Schemas |
• Porting modules from osC | Manually entering products

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

A unique, auto incremented value, to identify each restrict id record.

Type:	int(11)
Null:	No
Default:
Extra:	auto_increment

coupon_id

Links the specific coupon restrict record to the specific coupon in the coupons table.

Type:	int(11)
Null:	No
Default:	0

product_id

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.