mysql.puroparty.com
puroparty
ads_coupons
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: ads_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 | 0 | coupon_id | |
| coupon_id_2 | UNIQUE | 0 | coupon_id | |
| coupon_code_2 | UNIQUE | 0 | coupon_code | |
| coupon_percent_2 | UNIQUE | 0 | coupon_percent | |
| coupon_amount_2 | UNIQUE | 0 | coupon_amount | |
| coupon_expires_2 | UNIQUE | 0 | coupon_expires | |
| coupon_uses_2 | UNIQUE | 0 | coupon_uses | |
| coupon_restrict_2 | UNIQUE | 0 | coupon_restrict | |
| coupon_type_2 | UNIQUE | 0 | coupon_type | |
| coupon_id_4 | UNIQUE | 0 | coupon_id | |
| coupon_code_5 | UNIQUE | 0 | coupon_code | |
| coupon_percent_4 | UNIQUE | 0 | coupon_percent | |
| coupon_amount_4 | UNIQUE | 0 | coupon_amount | |
| coupon_expires_4 | UNIQUE | 0 | coupon_expires | |
| coupon_uses_4 | UNIQUE | 0 | coupon_uses | |
| coupon_restrict_4 | UNIQUE | 0 | coupon_restrict | |
| coupon_type_4 | UNIQUE | 0 | coupon_type | |
| coupon_restrict_5 | UNIQUE | 0 | coupon_restrict | |
| coupon_id_5 | UNIQUE | 0 | coupon_id | |
| coupon_expires_6 | UNIQUE | 0 | coupon_expires | |
| coupon_percent_6 | UNIQUE | 0 | coupon_percent | |
| coupon_amount_5 | UNIQUE | 0 | coupon_amount | |
| coupon_code_9 | UNIQUE | 0 | coupon_code | |
| coupon_uses_6 | UNIQUE | 0 | coupon_uses | |
| coupon_type_6 | UNIQUE | 0 | coupon_type | |
| coupon_expires_7 | UNIQUE | 0 | coupon_expires | |
| coupon_id_8 | UNIQUE | 0 | coupon_id | |
| coupon_restrict_8 | UNIQUE | 0 | coupon_restrict | |
| coupon_code_12 | UNIQUE | 0 | coupon_code | |
| 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_id_3 | INDEX | None | coupon_id | |
| coupon_code_4 | INDEX | None | coupon_code | |
| coupon_percent_3 | INDEX | None | coupon_percent | |
| coupon_amount_3 | INDEX | None | coupon_amount | |
| coupon_expires_3 | INDEX | None | coupon_expires | |
| coupon_uses_3 | INDEX | None | coupon_uses | |
| coupon_restrict_3 | INDEX | None | coupon_restrict | |
| coupon_type_3 | INDEX | None | coupon_type | |
| coupon_uses_5 | INDEX | None | coupon_uses | |
| coupon_type_5 | INDEX | None | coupon_type | |
| coupon_restrict_6 | INDEX | None | coupon_restrict | |
| coupon_expires_5 | INDEX | None | coupon_expires | |
| coupon_percent_5 | INDEX | None | coupon_percent | |
| coupon_code_7 | INDEX | None | coupon_code | |
| coupon_id_6 | INDEX | None | coupon_id | |
| coupon_amount_6 | INDEX | None | coupon_amount | |
| coupon_code_10 | INDEX | None | coupon_code | |
| coupon_id_7 | INDEX | None | coupon_id | |
| coupon_percent_7 | INDEX | None | coupon_percent | |
| coupon_expires_8 | INDEX | None | coupon_expires | |
| coupon_uses_7 | INDEX | None | coupon_uses | |
| coupon_restrict_7 | INDEX | None | coupon_restrict | |
| coupon_type_7 | INDEX | None | coupon_type | |
| coupon_code_3 | INDEX | None | coupon_code | |
| coupon_code_6 | INDEX | None | coupon_code | |
| coupon_code_8 | INDEX | None | coupon_code | |
| coupon_code_11 | INDEX | None | coupon_code | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||