PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 11 hours 37 minutes 23 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
67 058
Rejected
0
llm:3647f29e8418f543c540a11cc3abe48d541f4f36753ee56309d3808e4bc5d862
Edit
```json
{
"classifications": [
{
"column": "avail_id",
"role": "identifier",
"confidence": 1.0,
"reason": "Primary key with unique values (117424 distinct in 117424 rows), sequential integers 0-117423"
},
{
"column": "beer_id",
"role": "identifier",
"confidence": 1.0,
"reason": "Foreign key referencing beer table, used for JOINs"
},
{
"column": "place_id",
"role": "identifier",
"confidence": 1.0,
"reason": "Foreign key referencing place table, used for JOINs"
},
{
"column": "postal_code",
"role": "dimension",
"confidence": 0.95,
"reason": "Geographic grouping/filtering dimension with 7291 distinct values"
},
{
"column": "state_id",
"role": "identifier",
"confidence": 1.0,
"reason": "Foreign key referencing state table (372 distinct states)"
},
{
"column": "country_id",
"role": "identifier",
"confidence": 1.0,
"reason": "Foreign key referencing country table (111 distinct countries)"
},
{
"column": "created_at",
"role": "dimension",
"confidence": 1.0,
"reason": "Timestamp for temporal grouping, filtering, and slicing"
},
{
"column": "user_id",
"role": "identifier",
"confidence": 1.0,
"reason": "Foreign key referencing user table, used for JOINs"
},
{
"column": "is_in_bottle",
"role": "dimension",
"confidence": 1.0,
"reason": "Boolean flag for filtering and grouping availability by bottle format"
},
{
"column": "is_on_tap",
"role": "dimension",
"confidence": 1.0,
"reason": "Boolean flag for filtering and grouping availability by tap format"
},
{
"column": "is_out",
"role": "dimension",
"confidence": 1.0,
"reason": "Boolean flag for filtering and grouping by stock status"
}
]
}
```