PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 6 hours 21 minutes 52 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
61 529
Rejected
0
llm:9eb2802b0f7b7a09ee91fe46faf7145ec761f7151abe74b6cd36d5283ef54ad3
Edit
```json
{
"classifications": [
{"column": "brewer_id", "role": "identifier", "confidence": 1.0, "reason": "Primary key with unique values per row"},
{"column": "name", "role": "attribute", "confidence": 0.95, "reason": "Brewer name for display, high cardinality descriptive text"},
{"column": "description", "role": "attribute", "confidence": 1.0, "reason": "Free-form descriptive text, 79% null, never aggregated"},
{"column": "name_plain", "role": "attribute", "confidence": 0.95, "reason": "Plain text version of name for display"},
{"column": "address", "role": "attribute", "confidence": 1.0, "reason": "Free-form address text for display"},
{"column": "city", "role": "dimension", "confidence": 0.9, "reason": "Geographic dimension for grouping/filtering, 24k distinct values"},
{"column": "state_id", "role": "identifier", "confidence": 0.95, "reason": "Foreign key to states table, 612 distinct values"},
{"column": "country_id", "role": "identifier", "confidence": 0.95, "reason": "Foreign key to countries table, 229 distinct values"},
{"column": "zip_code", "role": "dimension", "confidence": 0.85, "reason": "Geographic code for filtering/grouping, high cardinality"},
{"column": "type_id", "role": "identifier", "confidence": 0.9, "reason": "Foreign key to brewer types, 8 distinct values"},
{"column": "website", "role": "attribute", "confidence": 1.0, "reason": "URL for display, not for grouping or aggregation"},
{"column": "facebook", "role": "attribute", "confidence": 1.0, "reason": "Social media handle for display"},
{"column": "twitter", "role": "attribute", "confidence": 1.0, "reason": "Social media handle for display"},
{"column": "email", "role": "attribute", "confidence": 1.0, "reason": "Contact email for display"},
{"column": "phone", "role": "attribute", "confidence": 1.0, "reason": "Contact phone for display"},
{"column": "barrels", "role": "measure", "confidence": 0.7, "reason": "Numeric quantity (all zeros in sample, but conceptually a measure)"},
{"column": "opened_at", "role": "dimension", "confidence": 0.95, "reason": "Date dimension for filtering and time-based grouping"},
{"column": "created_at", "role": "dimension", "confidence": 0.95, "reason": "Timestamp dimension for filtering and time-based analysis"},
{"column": "created_by", "role": "identifier", "confidence": 0.95, "reason": "Foreign key to user/creator, 5663 distinct values"},
{"column": "updated_at", "role": "dimension", "confidence": 0.95, "reason": "Timestamp dimension for filtering and time-based analysis"},
{"column": "beer_jobber_id", "role": "identifier", "confidence": 0.95, "reason": "Foreign key to beer jobber entity, 66 distinct values"},
{"column": "has_logo", "role": "dimension", "confidence": 0.95, "reason": "Boolean flag for filtering/grouping"},
{"column": "view_count", "role": "measure", "confidence": 1.0, "reason": "Numeric metric to aggregate (sum/avg views)"},
{"column": "score", "role": "measure", "confidence": 1.0, "reason": "Numeric score to aggregate (sum/avg)"},
{"column": "is_out_of_business", "role": "dimension", "confidence": 0.95, "reason": "Boolean flag for filtering/grouping"},
{"column": "out_of_business_date", "role": "dimension", "confidence": 0.95, "reason": "Date dimension for filtering and time-based grouping"},
{"column": "is_retired", "role": "dimension", "confidence": 0.95, "reason": "Boolean flag for filtering/grouping"},
{"column": "area_code", "role": "dimension", "confidence": 0.85, "reason": "Numeric code for geographic grouping/filtering"},
{"column": "hours", "role": "attribute", "confidence": 1.0, "reason": "Free-form operating hours text for display"},
{"column": "metro_id", "role": "identifier", "confidence": 0.95, "reason": "Foreign key to metro area, 68 distinct values"},
{"column": "region_id", "role": "identifier", "confidence": 0.95, "reason": "Foreign key to region, 793 distinct values"},
{"column": "admin_note", "role": "attribute", "confidence": 1.0, "reason": "Free-form administrative notes for display"},
{"column": "msrepl_tran_version", "role": "identifier", "confidence": 1.0, "reason": "Replication version GUID, unique per row"},
{"column": "updated_by", "role": "identifier", "confidence": 0.95, "reason": "Foreign key to user who updated, 902 distinct values"}
]
}
```