PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 5 hours 25 minutes 49 seconds
Memory
Total
512MB
Used
13,32MB (2.6%)
Free
498,68MB
Keys
Current
10 162
Total (since start)
11 092
Evictions
0
Reclaimed
157
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
5 / 1 024 max
Total
60 855
Rejected
0
llm:813af10eba12491921e305a0a492caeaa5dffcd79c1d4b9f7dc59baa9a46912d
Edit
```json
{
"classifications": [
{"column": "place_id", "label": "primary_key", "confidence": 1.0, "reason": "100% distinct (86061/86061), zero nulls, sequential integer ID"},
{"column": "name", "label": "none", "confidence": 0.99, "reason": "95.7% distinct but not a key; descriptive attribute"},
{"column": "name_plain", "label": "none", "confidence": 0.99, "reason": "95.1% distinct but not a key; normalized name variant"},
{"column": "description", "label": "none", "confidence": 1.0, "reason": "Text field with 93% nulls; descriptive content"},
{"column": "type_id", "label": "foreign_key", "confidence": 1.0, "reason": "Only 8 distinct values; references place type lookup table"},
{"column": "address", "label": "none", "confidence": 0.99, "reason": "96.4% distinct but not a key; address attribute"},
{"column": "city", "label": "none", "confidence": 1.0, "reason": "Only 18904 distinct values; descriptive location field"},
{"column": "city_plain", "label": "none", "confidence": 1.0, "reason": "Only 18374 distinct values; normalized city name"},
{"column": "state_id", "label": "foreign_key", "confidence": 1.0, "reason": "583 distinct values; references state/province lookup table"},
{"column": "country_id", "label": "foreign_key", "confidence": 1.0, "reason": "205 distinct values; references country lookup table"},
{"column": "postal_code", "label": "none", "confidence": 1.0, "reason": "38561 distinct values; postal code attribute"},
{"column": "phone", "label": "none", "confidence": 0.99, "reason": "91.1% distinct but not a key; contact information"},
{"column": "website", "label": "none", "confidence": 1.0, "reason": "71.1% distinct; URL attribute"},
{"column": "facebook", "label": "none", "confidence": 1.0, "reason": "48.2% distinct; social media attribute"},
{"column": "twitter", "label": "none", "confidence": 1.0, "reason": "16.9% distinct; social media attribute"},
{"column": "rating_text", "label": "none", "confidence": 1.0, "reason": "Only 4 distinct values; categorical rating"},
{"column": "has_taps", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "has_bottles", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "has_wifi", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "has_togo", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "has_singles", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "has_seasonals", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "has_real_ales", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "has_rare_beers", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "has_macros", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "has_glassware", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "has_smoking", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "has_cigars", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "allows_children", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "takes_reservations", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "has_patio", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "has_tv", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "has_games", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "scene", "label": "none", "confidence": 1.0, "reason": "Text field with 94% nulls; descriptive content"},
{"column": "staff", "label": "none", "confidence": 1.0, "reason": "Text field with 95% nulls; descriptive content"},
{"column": "parking", "label": "none", "confidence": 1.0, "reason": "Text field with 94% nulls; descriptive content"},
{"column": "music", "label": "none", "confidence": 1.0, "reason": "Text field with 98% nulls; descriptive content"},
{"column": "events", "label": "none", "confidence": 1.0, "reason": "Text field with 98% nulls; descriptive content"},
{"column": "noise", "label": "none", "confidence": 1.0, "reason": "Text field with 99% nulls; descriptive content"},
{"column": "seating", "label": "none", "confidence": 1.0, "reason": "Text field with 99% nulls; descriptive content"},
{"column": "has_food", "label": "none", "confidence": 1.0, "reason": "Boolean flag; only one distinct value"},
{"column": "food_details", "label": "none", "confidence": 1.0, "reason": "Text field with 99% nulls; descriptive content"},
{"column": "comments", "label": "none", "confidence": 1.0, "reason": "Text field; descriptive content"},
{"column": "hours", "label": "none", "confidence": 1.0, "reason": "Text field; operating hours attribute"},
{"column": "created_by", "label": "foreign_key", "confidence": 0.95, "reason": "17752 distinct values; references user who created record"},
{"column": "updated_by", "label": "foreign_key", "confidence": 0.95, "reason": "5801 distinct values; references user who updated record"},
{"column": "created_at", "label": "none", "confidence": 1.0, "reason": "Timestamp; audit field"},
{"column": "phone_area_code", "label": "none", "confidence": 1.0, "reason": "720 distinct values; extracted phone component"},
{"column": "has_mail_order", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "has_intl_shipping", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "avg_rating", "label": "none", "confidence": 1.0, "reason": "Numeric metric; calculated average"},
{"column": "weighted_avg", "label": "none", "confidence": 1.0, "reason": "Numeric metric; calculated weighted average"},
{"column": "bay_mean", "label": "none", "confidence": 1.0, "reason": "Numeric metric; Bayesian mean calculation"},
{"column": "percentile", "label": "none", "confidence": 1.0, "reason": "Numeric metric; percentile ranking"},
{"column": "rating_count", "label": "none", "confidence": 1.0, "reason": "Numeric metric; count of ratings"},
{"column": "valid_rating_count", "label": "none", "confidence": 1.0, "reason": "Numeric metric; count of valid ratings"},
{"column": "updated_at", "label": "none", "confidence": 1.0, "reason": "Timestamp; audit field"},
{"column": "currency", "label": "none", "confidence": 1.0, "reason": "Only 2 distinct values with 99.99% nulls; currency code"},
{"column": "is_retired", "label": "none", "confidence": 1.0, "reason": "Boolean flag; status indicator"},
{"column": "is_geo_override", "label": "none", "confidence": 1.0, "reason": "Boolean flag; configuration indicator"},
{"column": "latitude", "label": "none", "confidence": 1.0, "reason": "Numeric coordinate; geographic attribute"},
{"column": "longitude", "label": "none", "confidence": 1.0, "reason": "Numeric coordinate; geographic attribute"},
{"column": "has_food_menu", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "has_beer_menu", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "has_pic", "label": "none", "confidence": 1.0, "reason": "Boolean flag; feature indicator"},
{"column": "has_flights", "label": "none", "confidence": 1.0, "reason": "Boolean flag; only one distinct value"},
{"column": "score", "label": "none", "confidence": 1.0, "reason": "Numeric metric; calculated score"},
{"column": "creator_id", "label": "none", "confidence": 0.9, "reason": "Only 1 distinct value (0); likely deprecated or unused foreign key"}
]
}
```