| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| coupon_id |
int |
11 |
|
√ |
|
|
|
| coupon_type |
char |
1 |
|
|
F |
|
|
| coupon_code |
varchar |
32 |
|
|
|
|
|
| coupon_amount |
decimal |
8,4 |
|
|
0.0000 |
|
|
| coupon_minimum_order |
decimal |
8,4 |
|
|
0.0000 |
|
|
| coupon_start_date |
datetime |
19 |
|
|
0000-00-00 00:00:00 |
|
|
| coupon_expire_date |
datetime |
19 |
|
|
0000-00-00 00:00:00 |
|
|
| uses_per_coupon |
int |
5 |
|
|
1 |
|
|
| uses_per_user |
int |
5 |
|
|
0 |
|
|
| restrict_to_products |
varchar |
255 |
√ |
|
null |
|
|
| restrict_to_categories |
varchar |
255 |
√ |
|
null |
|
|
| restrict_to_customers |
text |
65535 |
√ |
|
null |
|
|
| coupon_active |
char |
1 |
|
|
Y |
|
|
| date_created |
datetime |
19 |
|
|
0000-00-00 00:00:00 |
|
|
| date_modified |
datetime |
19 |
|
|
0000-00-00 00:00:00 |
|
|
Table contained 0 rows at Mon Jun 18 16:54 CDT 2007
|
