PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 10 hours 41 minutes 19 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
66 182
Rejected
0
llm:6566dec72ae1a40d09569b10c29f93533cc4b20a804de415ef1e33bcb61bf72c
Edit
```json
{
"classifications": [
{
"column": "web-scraper-order",
"label": "primary_key",
"confidence": 1.0,
"reason": "100% distinct (30/30), zero nulls, uniquely identifies each row"
},
{
"column": "web-scraper-start-url",
"label": "none",
"confidence": 1.0,
"reason": "Single constant value, no identifying or joining capability"
},
{
"column": "MatchLink",
"label": "none",
"confidence": 1.0,
"reason": "Single constant value 'bout', no identifying or joining capability"
},
{
"column": "MatchLink-href",
"label": "near_key",
"confidence": 0.95,
"reason": "100% distinct (30/30), zero nulls, could be alternate primary key or foreign key to match table"
},
{
"column": "f_boxer",
"label": "none",
"confidence": 0.9,
"reason": "Only 5 distinct values in 30 rows, represents boxer name but not a key"
},
{
"column": "s_boxer",
"label": "none",
"confidence": 0.9,
"reason": "26 distinct values in 30 rows (87%), represents opponent name but not unique enough"
},
{
"column": "f_boxer_result",
"label": "none",
"confidence": 1.0,
"reason": "Match result attribute, only 6 distinct values"
},
{
"column": "f_boxer_stance",
"label": "none",
"confidence": 1.0,
"reason": "Single constant value 'orthodox', attribute not key"
},
{
"column": "f_boxer_age",
"label": "none",
"confidence": 1.0,
"reason": "Age attribute, 13 distinct values, not a key"
},
{
"column": "f_boxer_height",
"label": "none",
"confidence": 1.0,
"reason": "Height attribute, only 5 distinct values"
},
{
"column": "f_boxer_reach",
"label": "none",
"confidence": 1.0,
"reason": "Reach attribute, only 5 distinct values"
},
{
"column": "f_boxer_won",
"label": "none",
"confidence": 1.0,
"reason": "Win count attribute, 28 distinct but represents cumulative stat"
},
{
"column": "f_boxer_lost",
"label": "none",
"confidence": 1.0,
"reason": "Loss count attribute, only 4 distinct values"
},
{
"column": "f_boxer_drawn",
"label": "none",
"confidence": 1.0,
"reason": "Draw count attribute, only 2 distinct values"
},
{
"column": "f_boxer_KOs",
"label": "none",
"confidence": 1.0,
"reason": "KO count attribute, 23 distinct values but not a key"
},
{
"column": "f_boxer_ranking",
"label": "none",
"confidence": 1.0,
"reason": "Ranking attribute with nulls (6.7%), only 3 distinct values"
},
{
"column": "s_boxer_ranking",
"label": "none",
"confidence": 1.0,
"reason": "Ranking attribute with high null rate (56.7%), only 9 distinct values"
},
{
"column": "s_boxer_age",
"label": "none",
"confidence": 1.0,
"reason": "Age attribute, 18 distinct values, not a key"
},
{
"column": "s_boxer_stance",
"label": "none",
"confidence": 1.0,
"reason": "Stance attribute, only 3 distinct values"
},
{
"column": "s_boxer_reach",
"label": "none",
"confidence": 1.0,
"reason": "Reach attribute, only 6 distinct values"
},
{
"column": "s_boxer_height",
"label": "none",
"confidence": 1.0,
"reason": "Height attribute, 16 distinct values, not a key"
},
{
"column": "s_boxer_won",
"label": "none",
"confidence": 1.0,
"reason": "Win count attribute, 21 distinct values but not a key"
},
{
"column": "s_boxer_lost",
"label": "none",
"confidence": 1.0,
"reason": "Loss count attribute, 13 distinct values, not a key"
},
{
"column": "s_boxer_drawn",
"label": "none",
"confidence": 1.0,
"reason": "Draw count attribute, only 4 distinct values"
},
{
"column": "s_boxer_KOs",
"label": "none",
"confidence": 1.0,
"reason": "KO count attribute, 18 distinct values but not a key"
},
{
"column": "rounds",
"label": "none",
"confidence": 1.0,
"reason": "Match details attribute, 21 distinct values but not a key"
}
]
}
```