mysql.puroparty.com
puroparty
ads_ads
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: ads_ads
|
| Field | Type | Null | Default |
|---|---|---|---|
| ad_id | int(10) | No | |
| ad_status | tinyint(1) | No | 0 |
| ad_user_id | int(5) | No | 0 |
| ad_category | int(5) | No | 0 |
| ad_date_begin | varchar(10) | No | |
| ad_date_end | varchar(10) | No | |
| ad_type | tinyint(3) | No | 0 |
| ad_title | varchar(255) | No | |
| ad_description | text | No | |
| ad_image1 | varchar(255) | No | |
| ad_image2 | varchar(255) | No | |
| ad_image3 | varchar(255) | No | |
| ad_image4 | varchar(255) | No | |
| ad_image5 | varchar(255) | No | |
| ad_options | int(10) | No | 0 |
| ad_optional_1 | varchar(255) | No | |
| ad_optional_2 | varchar(255) | No | |
| ad_optional_3 | varchar(255) | No | |
| ad_optional_4 | varchar(255) | No | |
| ad_optional_5 | varchar(255) | No | |
| ad_type_optional1 | varchar(255) | No | |
| ad_type_optional2 | varchar(255) | No | |
| ad_type_optional3 | varchar(255) | No | |
| ad_type_optional4 | varchar(255) | No | |
| ad_type_optional5 | varchar(255) | No | |
| ad_type_optional6 | varchar(255) | No | |
| ad_type_optional7 | varchar(255) | No | |
| ad_type_optional8 | varchar(255) | No | |
| ad_type_optional9 | varchar(255) | No | |
| ad_type_optional10 | varchar(255) | No | |
| ad_price | varchar(255) | No | 0.00 |
| ad_condition | tinyint(4) | No | 0 |
| ad_views | int(4) | No | 0 |
| ad_address | varchar(255) | No | |
| ad_city | varchar(255) | No | |
| ad_state | varchar(255) | No | |
| ad_postal | varchar(255) | No | |
| ad_country | varchar(255) | No | |
| ad_city_code | int(11) | No | 0 |
| ad_state_code | int(4) | No | 0 |
| ad_country_code | int(3) | No | 0 |
| ad_fee | float(6,2) | No | 0.00 |
| ad_anon_name | varchar(255) | No | |
| ad_anon_email | varchar(255) | No |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 5 | ad_id | |
| ad_id_2 | UNIQUE | 5 | ad_id | |
| ad_title_2 | UNIQUE | 5 | ad_title | |
| ad_image1_2 | UNIQUE | 5 | ad_image1 | |
| ad_image2 | UNIQUE | 5 | ad_image2 | |
| ad_options_2 | UNIQUE | 5 | ad_options | |
| ad_views_2 | UNIQUE | 5 | ad_views | |
| ad_id | INDEX | None | ad_id | |
| ad_status | INDEX | None | ad_status | |
| ad_user_id | INDEX | None | ad_user_id | |
| ad_category | INDEX | None | ad_category | |
| ad_date_begin | INDEX | None | ad_date_begin | |
| ad_date_end | INDEX | None | ad_date_end | |
| ad_type | INDEX | None | ad_type | |
| ad_title | INDEX | None | ad_title | |
| ad_image1 | INDEX | None | ad_image1 | |
| ad_image2_2 | INDEX | None | ad_image2 | |
| ad_image3 | INDEX | None | ad_image3 | |
| ad_image4 | INDEX | None | ad_image4 | |
| ad_image5 | INDEX | None | ad_image5 | |
| ad_options | INDEX | None | ad_options | |
| ad_optional_1 | INDEX | None | ad_optional_1 | |
| ad_optional_2 | INDEX | None | ad_optional_2 | |
| ad_optional_3 | INDEX | None | ad_optional_3 | |
| ad_optional_4 | INDEX | None | ad_optional_4 | |
| ad_optional_5 | INDEX | None | ad_optional_5 | |
| ad_type_optional1 | INDEX | None | ad_type_optional1 | |
| ad_type_optional2 | INDEX | None | ad_type_optional2 | |
| ad_type_optional3 | INDEX | None | ad_type_optional3 | |
| ad_type_optional4 | INDEX | None | ad_type_optional4 | |
| ad_type_optional5 | INDEX | None | ad_type_optional5 | |
| ad_type_optional6 | INDEX | None | ad_type_optional6 | |
| ad_type_optional7 | INDEX | None | ad_type_optional7 | |
| ad_type_optional8 | INDEX | None | ad_type_optional8 | |
| ad_type_optional9 | INDEX | None | ad_type_optional9 | |
| ad_type_optional10 | INDEX | None | ad_type_optional10 | |
| ad_price | INDEX | None | ad_price | |
| ad_condition | INDEX | None | ad_condition | |
| ad_views | INDEX | None | ad_views | |
| ad_date_begin_2 | INDEX | None | ad_date_begin | |
| ad_date_end_2 | INDEX | None | ad_date_end | |
| ad_title_3 | INDEX | None | ad_title | |
| ad_description | INDEX | None | ad_description | |
| ad_image1_3 | INDEX | None | ad_image1 | |
| ad_image2_3 | INDEX | None | ad_image2 | |
| ad_image3_2 | INDEX | None | ad_image3 | |
| ad_image4_2 | INDEX | None | ad_image4 | |
| ad_image5_2 | INDEX | None | ad_image5 | |
| ad_optional_1_2 | INDEX | None | ad_optional_1 | |
| ad_optional_2_2 | INDEX | None | ad_optional_2 | |
| ad_optional_3_2 | INDEX | None | ad_optional_3 | |
| ad_optional_4_2 | INDEX | None | ad_optional_4 | |
| ad_optional_5_2 | INDEX | None | ad_optional_5 | |
| ad_type_optional1_2 | INDEX | None | ad_type_optional1 | |
| ad_type_optional2_2 | INDEX | None | ad_type_optional2 | |
| ad_type_optional3_2 | INDEX | None | ad_type_optional3 | |
| ad_type_optional4_2 | INDEX | None | ad_type_optional4 | |
| ad_type_optional5_2 | INDEX | None | ad_type_optional5 | |
| ad_type_optional6_2 | INDEX | None | ad_type_optional6 | |
| ad_type_optional7_2 | INDEX | None | ad_type_optional7 | |
| ad_type_optional8_2 | INDEX | None | ad_type_optional8 | |
| ad_type_optional9_2 | INDEX | None | ad_type_optional9 | |
| ad_type_optional10_2 | INDEX | None | ad_type_optional10 | |
| ad_price_2 | INDEX | None | ad_price | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||