PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 8 hours 15 minutes 5 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
63 530
Rejected
0
llm:c9a3b3c6ff89c43db24597e0d9ba50c029c46ee8463789592a8105df36a20f5d
Edit
```json
{
"classifications": [
{
"column": "brewer_id",
"label": "primary_key",
"confidence": 1.0,
"reason": "100% distinct (50013/50013), zero nulls, sequential integer ID"
},
{
"column": "name",
"label": "none",
"confidence": 1.0,
"reason": "Brewer name, 99.88% distinct but not a key field"
},
{
"column": "description",
"label": "none",
"confidence": 1.0,
"reason": "Text description with 79% nulls, not a key"
},
{
"column": "name_plain",
"label": "none",
"confidence": 1.0,
"reason": "Plain text name variant, 99.83% distinct but not a key"
},
{
"column": "address",
"label": "none",
"confidence": 1.0,
"reason": "Street address, not a key field"
},
{
"column": "city",
"label": "none",
"confidence": 1.0,
"reason": "City name, repeating values, not a key"
},
{
"column": "state_id",
"label": "foreign_key",
"confidence": 0.95,
"reason": "References states table, 612 distinct values with repetition"
},
{
"column": "country_id",
"label": "foreign_key",
"confidence": 0.95,
"reason": "References countries table, 229 distinct values with repetition"
},
{
"column": "zip_code",
"label": "none",
"confidence": 1.0,
"reason": "Postal code, not a key field"
},
{
"column": "type_id",
"label": "foreign_key",
"confidence": 0.95,
"reason": "References brewer types, only 8 distinct values with repetition"
},
{
"column": "website",
"label": "none",
"confidence": 1.0,
"reason": "URL field, not a key"
},
{
"column": "facebook",
"label": "none",
"confidence": 1.0,
"reason": "Social media handle, not a key"
},
{
"column": "twitter",
"label": "none",
"confidence": 1.0,
"reason": "Social media handle, not a key"
},
{
"column": "email",
"label": "none",
"confidence": 1.0,
"reason": "Email address, not a key"
},
{
"column": "phone",
"label": "none",
"confidence": 1.0,
"reason": "Phone number, not a key"
},
{
"column": "barrels",
"label": "none",
"confidence": 1.0,
"reason": "Single value (0.0), metric field, not a key"
},
{
"column": "opened_at",
"label": "none",
"confidence": 1.0,
"reason": "Opening date timestamp, not a key"
},
{
"column": "created_at",
"label": "none",
"confidence": 1.0,
"reason": "Record creation timestamp, audit field, not a key"
},
{
"column": "created_by",
"label": "foreign_key",
"confidence": 0.9,
"reason": "References user/account who created record, 5663 distinct values"
},
{
"column": "updated_at",
"label": "none",
"confidence": 1.0,
"reason": "Record update timestamp, audit field, not a key"
},
{
"column": "beer_jobber_id",
"label": "foreign_key",
"confidence": 0.9,
"reason": "References beer jobber entity, 66 distinct values with repetition"
},
{
"column": "has_logo",
"label": "none",
"confidence": 1.0,
"reason": "Boolean flag, single value (false), not a key"
},
{
"column": "view_count",
"label": "none",
"confidence": 1.0,
"reason": "Metric counter, not a key"
},
{
"column": "score",
"label": "none",
"confidence": 1.0,
"reason": "Numeric score metric, not a key"
},
{
"column": "is_out_of_business",
"label": "none",
"confidence": 1.0,
"reason": "Boolean flag, single value (false), not a key"
},
{
"column": "out_of_business_date",
"label": "none",
"confidence": 1.0,
"reason": "Date field with 88% nulls, not a key"
},
{
"column": "is_retired",
"label": "none",
"confidence": 1.0,
"reason": "Boolean flag, not a key"
},
{
"column": "area_code",
"label": "none",
"confidence": 1.0,
"reason": "Phone area code, not a key"
},
{
"column": "hours",
"label": "none",
"confidence": 1.0,
"reason": "Operating hours text, not a key"
},
{
"column": "metro_id",
"label": "foreign_key",
"confidence": 0.9,
"reason": "References metro area, 68 distinct values with repetition"
},
{
"column": "region_id",
"label": "foreign_key",
"confidence": 0.9,
"reason": "References region, 793 distinct values with repetition"
},
{
"column": "admin_note",
"label": "none",
"confidence": 1.0,
"reason": "Administrative notes text, not a key"
},
{
"column": "msrepl_tran_version",
"label": "none",
"confidence": 1.0,
"reason": "Replication GUID, 99.998% distinct but technical metadata, not a business key"
},
{
"column": "updated_by",
"label": "foreign_key",
"confidence": 0.85,
"reason": "References user who updated record, 902 distinct values, 32% nulls"
}
]
}
```