Field_name
|
Min_value
|
Max_value
|
Min_length
|
Max_length
|
Empties_or_zeros
|
Nulls
|
Avg_value_or_avg_length
|
Std
|
Optimal_fieldtype
|
puroparty.bos_coupons.coupon_id |
4 |
5 |
1 |
1 |
0 |
0 |
4.5000 |
0.5000 |
ENUM('4','5') NOT NULL |
puroparty.bos_coupons.coupon_code |
pasale1 |
tina |
4 |
7 |
0 |
0 |
5.5000 |
NULL |
ENUM('pasale1','tina') NOT NULL |
puroparty.bos_coupons.coupon_percent |
100 |
100 |
3 |
3 |
0 |
0 |
100.0000 |
0.0000 |
ENUM('100') NOT NULL |
puroparty.bos_coupons.coupon_amount |
0.00 |
0.00 |
4 |
4 |
2 |
0 |
0.00 |
0.00 |
ENUM('0.00') NOT NULL |
puroparty.bos_coupons.coupon_expires |
0000-00-00 |
2007-11-07 |
10 |
10 |
0 |
0 |
10.0000 |
NULL |
ENUM('0000-00-00','2007-11-07') NOT NULL |
puroparty.bos_coupons.coupon_uses |
1 |
9 |
1 |
1 |
0 |
0 |
5.0000 |
4.0000 |
ENUM('1','9') NOT NULL |
puroparty.bos_coupons.coupon_restrict |
0 |
0 |
1 |
1 |
2 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.bos_coupons.coupon_type |
0 |
0 |
1 |
1 |
2 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |