Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 20, 2024 at 08:13 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `bos_coupons` PROCEDURE ANALYSE();
Rows: 8
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 |