PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 13 hours 51 minutes 26 seconds
Memory
Total
512MB
Used
13,33MB (2.6%)
Free
498,67MB
Keys
Current
10 166
Total (since start)
11 096
Evictions
0
Reclaimed
157
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
3 / 1 024 max
Total
69 274
Rejected
0
llm:9270f008d5555acd234fcc14d3451c9ea2de90e48871a443fca49f07503fd83f
Edit
```json
{
"classifications": [
{
"column": "X",
"label": "primary_key",
"confidence": 1.0,
"reason": "100% distinct (7851/7851), zero nulls, sequential ID from 1 to 7851"
},
{
"column": "Date",
"label": "none",
"confidence": 1.0,
"reason": "Only 29 distinct values across 7851 rows, represents match dates"
},
{
"column": "Time",
"label": "none",
"confidence": 1.0,
"reason": "262 distinct values, represents match times, not a key"
},
{
"column": "Player1",
"label": "foreign_key",
"confidence": 0.95,
"reason": "551 distinct players across 7851 matches, references player entity"
},
{
"column": "Player2",
"label": "foreign_key",
"confidence": 0.95,
"reason": "544 distinct players across 7851 matches, references player entity"
},
{
"column": "Sets_P1",
"label": "none",
"confidence": 1.0,
"reason": "Only 4 distinct values (0-3), represents sets won by Player1"
},
{
"column": "Sets_P2",
"label": "none",
"confidence": 1.0,
"reason": "Only 4 distinct values (0-3), represents sets won by Player2"
},
{
"column": "P1_G1",
"label": "none",
"confidence": 1.0,
"reason": "Game scores (0-21), only 22 distinct values"
},
{
"column": "P2_G1",
"label": "none",
"confidence": 1.0,
"reason": "Game scores (0-23), only 23 distinct values"
},
{
"column": "P1_G2",
"label": "none",
"confidence": 1.0,
"reason": "Game scores (0-26), only 22 distinct values"
},
{
"column": "P2_G2",
"label": "none",
"confidence": 1.0,
"reason": "Game scores (0-24), only 22 distinct values"
},
{
"column": "P1_G3",
"label": "none",
"confidence": 1.0,
"reason": "Game scores (0-22), only 22 distinct values"
},
{
"column": "P2_G3",
"label": "none",
"confidence": 1.0,
"reason": "Game scores (0-20), only 21 distinct values"
},
{
"column": "P1_G4",
"label": "none",
"confidence": 1.0,
"reason": "Game scores with 30.6% nulls, only 23 distinct values"
},
{
"column": "P2_G4",
"label": "none",
"confidence": 1.0,
"reason": "Game scores with 30.6% nulls, only 22 distinct values"
},
{
"column": "P1_G5",
"label": "none",
"confidence": 1.0,
"reason": "Game scores with 67.9% nulls, only 21 distinct values"
},
{
"column": "P2_G5",
"label": "none",
"confidence": 1.0,
"reason": "Game scores with 67.9% nulls, only 19 distinct values"
},
{
"column": "HomeWinner",
"label": "none",
"confidence": 1.0,
"reason": "Binary flag (0/1), only 2 distinct values"
}
]
}
```