PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 5 hours 24 minutes 34 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
3 / 1 024 max
Total
60 784
Rejected
0
llm:bbf2b3844b7568d0b4f6453db661de0d8b7eb58bdc4c0407ff3faf70f258937e
Edit
```json
{
"classifications": [
{
"column": "rating_id",
"label": "primary_key",
"confidence": 1.0,
"reason": "100% distinct (14344128/14344128), zero nulls, sequential integers 0 to 14344127"
},
{
"column": "user_id",
"label": "foreign_key",
"confidence": 1.0,
"reason": "References users table, 215990 distinct values across 14M rows, zero nulls, values repeat"
},
{
"column": "beer_id",
"label": "foreign_key",
"confidence": 1.0,
"reason": "References beers table, 1063085 distinct values across 14M rows, minimal nulls, values repeat"
},
{
"column": "aroma",
"label": "none",
"confidence": 1.0,
"reason": "Rating score 0-10, only 11 distinct values"
},
{
"column": "flavor",
"label": "none",
"confidence": 1.0,
"reason": "Rating score 0-10, only 11 distinct values"
},
{
"column": "mouthfeel",
"label": "none",
"confidence": 1.0,
"reason": "Rating score 0-5, only 6 distinct values"
},
{
"column": "appearance",
"label": "none",
"confidence": 1.0,
"reason": "Rating score 0-5, only 6 distinct values"
},
{
"column": "overall",
"label": "none",
"confidence": 1.0,
"reason": "Rating score 0-20, only 21 distinct values"
},
{
"column": "total_score",
"label": "none",
"confidence": 1.0,
"reason": "Calculated score 0.1-5.0, only 75 distinct values"
},
{
"column": "comments",
"label": "none",
"confidence": 1.0,
"reason": "Free-text review field, 12M distinct but not a key"
},
{
"column": "created_at",
"label": "none",
"confidence": 1.0,
"reason": "Timestamp field, 14.3M distinct but not a key (99.8% distinct)"
},
{
"column": "updated_at",
"label": "none",
"confidence": 1.0,
"reason": "Timestamp field with 69.7% nulls, not a key"
},
{
"column": "description_score",
"label": "none",
"confidence": 1.0,
"reason": "Calculated metric with 35.6% nulls, only 9220 distinct values"
},
{
"column": "language",
"label": "none",
"confidence": 1.0,
"reason": "Language code, 82 distinct values, 20.7% nulls"
},
{
"column": "availability_id",
"label": "foreign_key",
"confidence": 0.7,
"reason": "References availability table, 107716 distinct values, but 99.2% nulls suggests optional relationship"
}
]
}
```