PHPMem v2.0.1
Version
1.6.45
Uptime
15 days 9 hours 5 minutes 9 seconds
Memory
Total
512MB
Used
24,01MB (4.69%)
Free
487,99MB
Keys
Current
27 650
Total (since start)
33 978
Evictions
0
Reclaimed
160
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
11 / 1 024 max
Total
170 279
Rejected
0
llm:f311d6bc153d430994dbf26e6d8edfa4587af450331c83d8c1241d563fcbcfee
Edit
```json
{
"classifications": [
{
"column": "Restaurant ID",
"label": "primary_key",
"confidence": 1.0,
"reason": "100% distinct (9551/9551), zero nulls, uniquely identifies each restaurant"
},
{
"column": "Restaurant Name",
"label": "none",
"confidence": 1.0,
"reason": "Only 78% distinct (7446/9551), not unique enough for key role"
},
{
"column": "Country Code",
"label": "foreign_key",
"confidence": 0.95,
"reason": "Low cardinality (15 values), repeating values, likely references country lookup table"
},
{
"column": "City",
"label": "none",
"confidence": 1.0,
"reason": "Descriptive attribute with 141 distinct values, not a key"
},
{
"column": "Address",
"label": "near_key",
"confidence": 0.9,
"reason": "93.4% distinct (8918/9551), close to unique but not verified as primary key"
},
{
"column": "Locality",
"label": "none",
"confidence": 1.0,
"reason": "Only 12.6% distinct (1208/9551), descriptive attribute"
},
{
"column": "Locality Verbose",
"label": "none",
"confidence": 1.0,
"reason": "Only 13.2% distinct (1265/9551), descriptive attribute"
},
{
"column": "Longitude",
"label": "none",
"confidence": 1.0,
"reason": "Geographic coordinate, 85% distinct but not a key field"
},
{
"column": "Latitude",
"label": "none",
"confidence": 1.0,
"reason": "Geographic coordinate, 90.8% distinct but not a key field"
},
{
"column": "Cuisines",
"label": "none",
"confidence": 1.0,
"reason": "Descriptive attribute with 1826 distinct values, not a key"
},
{
"column": "Average Cost for two",
"label": "none",
"confidence": 1.0,
"reason": "Numeric measure with only 140 distinct values, not a key"
},
{
"column": "Currency",
"label": "none",
"confidence": 1.0,
"reason": "Low cardinality (12 values), descriptive attribute"
},
{
"column": "Has Table booking",
"label": "none",
"confidence": 1.0,
"reason": "Boolean flag, only 2 distinct values"
},
{
"column": "Has Online delivery",
"label": "none",
"confidence": 1.0,
"reason": "Boolean flag, only 2 distinct values"
},
{
"column": "Is delivering now",
"label": "none",
"confidence": 1.0,
"reason": "Boolean flag, only 2 distinct values"
},
{
"column": "Switch to order menu",
"label": "none",
"confidence": 1.0,
"reason": "Boolean flag with only 1 distinct value"
},
{
"column": "Price range",
"label": "none",
"confidence": 1.0,
"reason": "Categorical attribute with only 4 distinct values"
},
{
"column": "Aggregate rating",
"label": "none",
"confidence": 1.0,
"reason": "Numeric measure with 33 distinct values, not a key"
},
{
"column": "Rating color",
"label": "none",
"confidence": 1.0,
"reason": "Categorical attribute with 6 distinct values"
},
{
"column": "Rating text",
"label": "none",
"confidence": 1.0,
"reason": "Categorical attribute with 6 distinct values"
},
{
"column": "Votes",
"label": "none",
"confidence": 1.0,
"reason": "Numeric measure with 1012 distinct values, not a key"
}
]
}
```