PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 18 hours 5 minutes 22 seconds
Memory
Total
512MB
Used
8,23MB (1.61%)
Free
503,77MB
Keys
Current
6 302
Total (since start)
11 098
Evictions
0
Reclaimed
298
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
3 / 1 024 max
Total
71 871
Rejected
0
llm:90daaf658d4be54a907bcce9da895e8dd71aab02c5faabf24365400156c93fc5
Edit
```json
{
"classifications": [
{
"column": "avail_id",
"label": "primary_key",
"confidence": 1.0,
"reason": "100% distinct (117424/117424), zero nulls, sequential ID pattern"
},
{
"column": "beer_id",
"label": "foreign_key",
"confidence": 0.95,
"reason": "References beer table, 64% distinct, zero nulls, repeating values expected"
},
{
"column": "place_id",
"label": "foreign_key",
"confidence": 0.95,
"reason": "References place table, 9% distinct with 3.5% nulls, typical FK pattern"
},
{
"column": "postal_code",
"label": "none",
"confidence": 0.9,
"reason": "Descriptive attribute, not a key; 8.4% nulls"
},
{
"column": "state_id",
"label": "foreign_key",
"confidence": 0.95,
"reason": "References state table, low cardinality (372 values), 10.7% nulls"
},
{
"column": "country_id",
"label": "foreign_key",
"confidence": 0.95,
"reason": "References country table, low cardinality (111 values), zero nulls"
},
{
"column": "created_at",
"label": "none",
"confidence": 1.0,
"reason": "Timestamp attribute, not a key despite high distinctness"
},
{
"column": "user_id",
"label": "foreign_key",
"confidence": 0.95,
"reason": "References user table, low cardinality (1025 values), minimal nulls"
},
{
"column": "is_in_bottle",
"label": "none",
"confidence": 1.0,
"reason": "Boolean flag attribute, not a key"
},
{
"column": "is_on_tap",
"label": "none",
"confidence": 1.0,
"reason": "Boolean flag attribute, not a key"
},
{
"column": "is_out",
"label": "none",
"confidence": 1.0,
"reason": "Boolean flag attribute, not a key"
}
]
}
```