PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 8 hours 13 minutes 59 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
63 384
Rejected
0
llm:6a378e7cc5d8817badc0a7bfc8a154aceb08fe1ad8872de74d05d7103ceb8d84
Edit
```json
{
"classifications": [
{
"column": "rating_id",
"label": "primary_key",
"confidence": 1.0,
"reason": "100% distinct (385707/385707), zero nulls, sequential integers 0-385706"
},
{
"column": "user_id",
"label": "foreign_key",
"confidence": 1.0,
"reason": "References users table, 28190 distinct values across 385707 rows (7.3%), zero nulls"
},
{
"column": "place_id",
"label": "foreign_key",
"confidence": 1.0,
"reason": "References places table, 65690 distinct values across 385707 rows (17%), has 5.3% nulls"
},
{
"column": "ambiance",
"label": "none",
"confidence": 1.0,
"reason": "Rating dimension with 5 distinct values (1-5 scale)"
},
{
"column": "service",
"label": "none",
"confidence": 1.0,
"reason": "Rating dimension with 10 distinct values (1-10 scale)"
},
{
"column": "selection",
"label": "none",
"confidence": 1.0,
"reason": "Rating dimension with 15 distinct values (1-15 scale)"
},
{
"column": "food",
"label": "none",
"confidence": 1.0,
"reason": "Rating dimension with 11 distinct values (0-10 scale)"
},
{
"column": "value",
"label": "none",
"confidence": 1.0,
"reason": "Rating dimension with 11 distinct values (0-10 scale)"
},
{
"column": "overall",
"label": "none",
"confidence": 1.0,
"reason": "Rating dimension with 20 distinct values (1-20 scale)"
},
{
"column": "total_score",
"label": "none",
"confidence": 1.0,
"reason": "Calculated/aggregate score with 91 distinct values (8-100 range)"
},
{
"column": "comments",
"label": "none",
"confidence": 1.0,
"reason": "Free-text field with 359406 distinct values, 1.8% nulls"
},
{
"column": "created_at",
"label": "none",
"confidence": 1.0,
"reason": "Timestamp field, 385506 distinct (99.9%) but not a key - audit column"
},
{
"column": "updated_at",
"label": "none",
"confidence": 1.0,
"reason": "Timestamp field with 67.2% nulls, 126627 distinct - audit column"
}
]
}
```