PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 5 hours 23 minutes 3 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 713
Rejected
0
llm:80bbf6c8d65188d71f61c7aeb0953f20cb8f14034a9ebecda91488aedb59dfc2
Edit
```json
{
"classifications": [
{"column": "beer_id", "role": "identifier", "confidence": 1.0, "reason": "Primary key with unique values per row"},
{"column": "name", "role": "attribute", "confidence": 1.0, "reason": "Descriptive beer name for display"},
{"column": "name_plain", "role": "attribute", "confidence": 1.0, "reason": "Plain text version of beer name for display"},
{"column": "brewer_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key to brewer table"},
{"column": "style_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key to style table"},
{"column": "alcohol_pct", "role": "measure", "confidence": 1.0, "reason": "Numeric percentage to aggregate (avg/sum)"},
{"column": "ibu", "role": "measure", "confidence": 1.0, "reason": "Numeric bitterness units to aggregate"},
{"column": "is_seasonal", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag to filter/group by"},
{"column": "description", "role": "attribute", "confidence": 1.0, "reason": "Long free-form text for display only"},
{"column": "created_at", "role": "dimension", "confidence": 1.0, "reason": "Timestamp for filtering and grouping"},
{"column": "created_by", "role": "identifier", "confidence": 1.0, "reason": "Foreign key to user who created"},
{"column": "view_count", "role": "measure", "confidence": 1.0, "reason": "Numeric count to aggregate"},
{"column": "avg_rating", "role": "measure", "confidence": 1.0, "reason": "Numeric rating to aggregate"},
{"column": "rating_count", "role": "measure", "confidence": 1.0, "reason": "Numeric count to aggregate"},
{"column": "Unrateable", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag (0/1) to filter/group by"},
{"column": "is_one_off", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag to filter/group by"},
{"column": "is_alias", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag to filter/group by"},
{"column": "real_avg_rating", "role": "measure", "confidence": 1.0, "reason": "Numeric rating to aggregate"},
{"column": "is_verified", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag to filter/group by"},
{"column": "is_retired", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag to filter/group by"},
{"column": "rating_std_dev", "role": "measure", "confidence": 1.0, "reason": "Numeric statistical measure to aggregate"},
{"column": "overall_percentile", "role": "measure", "confidence": 1.0, "reason": "Numeric percentile to aggregate"},
{"column": "style_percentile", "role": "measure", "confidence": 1.0, "reason": "Numeric percentile to aggregate"},
{"column": "tags", "role": "attribute", "confidence": 1.0, "reason": "Long HTML/text content for display"},
{"column": "last_9m_avg", "role": "measure", "confidence": 1.0, "reason": "Numeric average to aggregate"},
{"column": "last_9m_count", "role": "measure", "confidence": 1.0, "reason": "Numeric count to aggregate"},
{"column": "updated_by", "role": "identifier", "confidence": 1.0, "reason": "Foreign key to user who updated"},
{"column": "updated_at", "role": "dimension", "confidence": 1.0, "reason": "Timestamp for filtering and grouping"},
{"column": "admin_note", "role": "attribute", "confidence": 1.0, "reason": "Free-form text notes for display"},
{"column": "has_pic", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag to filter/group by"},
{"column": "straight_avg_rating", "role": "measure", "confidence": 1.0, "reason": "Numeric rating to aggregate"},
{"column": "straight_rating_count", "role": "measure", "confidence": 1.0, "reason": "Numeric count to aggregate"},
{"column": "year4_avg", "role": "measure", "confidence": 1.0, "reason": "Numeric average to aggregate"},
{"column": "year4_overall", "role": "measure", "confidence": 1.0, "reason": "Numeric percentile to aggregate"},
{"column": "year4_style", "role": "measure", "confidence": 1.0, "reason": "Numeric percentile to aggregate"},
{"column": "year4_count", "role": "measure", "confidence": 1.0, "reason": "Numeric count to aggregate"}
]
}
```