Server: mysql.puroparty.com | Database: puroparty | Table: bos_coupons |
Field | Type | Null | Default |
---|---|---|---|
coupon_id | int(11) | No | |
coupon_code | varchar(255) | No | |
coupon_percent | tinyint(3) | No | 0 |
coupon_amount | float(6,2) | No | 0.00 |
coupon_expires | date | No | 0000-00-00 |
coupon_uses | int(5) | No | 0 |
coupon_restrict | tinyint(1) | No | 0 |
coupon_type | tinyint(1) | No | 0 |
Keyname | Type | Cardinality | Field | |
---|---|---|---|---|
PRIMARY | PRIMARY | 2 | coupon_id | |
coupon_id_2 | UNIQUE | 2 | coupon_id | |
coupon_code_2 | UNIQUE | 2 | coupon_code | |
coupon_expires_2 | UNIQUE | 2 | coupon_expires | |
coupon_uses_2 | UNIQUE | 2 | coupon_uses | |
coupon_expires_3 | UNIQUE | 2 | coupon_expires | |
coupon_uses_4 | UNIQUE | 2 | coupon_uses | |
coupon_code_5 | UNIQUE | 2 | coupon_code | |
coupon_id_4 | UNIQUE | 2 | coupon_id | |
coupon_id_6 | UNIQUE | 2 | coupon_id | |
coupon_code_8 | UNIQUE | 2 | coupon_code | |
coupon_expires_6 | UNIQUE | 2 | coupon_expires | |
coupon_uses_6 | UNIQUE | 2 | coupon_uses | |
coupon_expires_8 | UNIQUE | 2 | coupon_expires | |
coupon_code_11 | UNIQUE | 2 | coupon_code | |
coupon_uses_7 | UNIQUE | 2 | coupon_uses | |
coupon_id_8 | UNIQUE | 2 | coupon_id | |
coupon_code_13 | UNIQUE | 2 | coupon_code | |
coupon_uses_10 | UNIQUE | 2 | coupon_uses | |
coupon_code_14 | UNIQUE | 2 | coupon_code | |
coupon_expires_10 | UNIQUE | 2 | coupon_expires | |
coupon_id | INDEX | None | coupon_id | |
coupon_code | INDEX | None | coupon_code | |
coupon_percent | INDEX | None | coupon_percent | |
coupon_amount | INDEX | None | coupon_amount | |
coupon_expires | INDEX | None | coupon_expires | |
coupon_uses | INDEX | None | coupon_uses | |
coupon_restrict | INDEX | None | coupon_restrict | |
coupon_type | INDEX | None | coupon_type | |
coupon_percent_2 | INDEX | None | coupon_percent | |
coupon_code_4 | INDEX | None | coupon_code | |
coupon_amount_2 | INDEX | None | coupon_amount | |
coupon_restrict_2 | INDEX | None | coupon_restrict | |
coupon_expires_4 | INDEX | None | coupon_expires | |
coupon_uses_3 | INDEX | None | coupon_uses | |
coupon_id_3 | INDEX | None | coupon_id | |
coupon_type_2 | INDEX | None | coupon_type | |
coupon_id_5 | INDEX | None | coupon_id | |
coupon_code_7 | INDEX | None | coupon_code | |
coupon_percent_3 | INDEX | None | coupon_percent | |
coupon_amount_3 | INDEX | None | coupon_amount | |
coupon_expires_5 | INDEX | None | coupon_expires | |
coupon_uses_5 | INDEX | None | coupon_uses | |
coupon_restrict_3 | INDEX | None | coupon_restrict | |
coupon_type_3 | INDEX | None | coupon_type | |
coupon_expires_7 | INDEX | None | coupon_expires | |
coupon_id_7 | INDEX | None | coupon_id | |
coupon_percent_4 | INDEX | None | coupon_percent | |
coupon_code_10 | INDEX | None | coupon_code | |
coupon_restrict_4 | INDEX | None | coupon_restrict | |
coupon_amount_4 | INDEX | None | coupon_amount | |
coupon_type_4 | INDEX | None | coupon_type | |
coupon_uses_8 | INDEX | None | coupon_uses | |
coupon_percent_5 | INDEX | None | coupon_percent | |
coupon_amount_5 | INDEX | None | coupon_amount | |
coupon_uses_9 | INDEX | None | coupon_uses | |
coupon_type_5 | INDEX | None | coupon_type | |
coupon_expires_9 | INDEX | None | coupon_expires | |
coupon_code_15 | INDEX | None | coupon_code | |
coupon_id_9 | INDEX | None | coupon_id | |
coupon_code_3 | INDEX | None | coupon_code | |
coupon_code_6 | INDEX | None | coupon_code | |
coupon_code_9 | INDEX | None | coupon_code | |
coupon_code_12 | INDEX | None | coupon_code |
Space usage :
|
Row Statistic :
|