PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 11 hours 35 minutes 15 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
2 / 1 024 max
Total
66 903
Rejected
0
llm:a18d2ae6029fbfcaa7e4b4f8aa12ef7b863508d7dbabf26a700c013d97b2cc93
Edit
```json
{
"classifications": [
{
"column": "id",
"label": "primary_key",
"confidence": 1.0,
"reason": "100% distinct (724/724), zero nulls, VARCHAR with 'nf_' prefix pattern indicating unique identifier"
},
{
"column": "dataset_id",
"label": "foreign_key",
"confidence": 0.95,
"reason": "76 distinct values in 724 rows (10.5%), zero nulls, 'd_' prefix suggests reference to datasets table"
},
{
"column": "batch_id",
"label": "foreign_key",
"confidence": 0.95,
"reason": "76 distinct values in 724 rows (10.5%), zero nulls, 'batch_' prefix suggests reference to batches table"
},
{
"column": "probe_kind",
"label": "none",
"confidence": 0.99,
"reason": "Only 8 distinct values, categorical attribute describing probe type"
},
{
"column": "probe_run_id",
"label": "foreign_key",
"confidence": 0.95,
"reason": "197 distinct values in 724 rows (27.2%), zero nulls, 'npr_' prefix suggests reference to probe runs table"
},
{
"column": "fingerprint",
"label": "near_key",
"confidence": 0.98,
"reason": "659 distinct values in 724 rows (91.0%), zero nulls, high but not 100% distinct"
},
{
"column": "kind",
"label": "none",
"confidence": 0.99,
"reason": "Only 8 distinct values, categorical attribute (duplicate of probe_kind)"
},
{
"column": "severity",
"label": "none",
"confidence": 0.99,
"reason": "Only 3 distinct values (high/low/medium), categorical attribute"
},
{
"column": "target_table",
"label": "none",
"confidence": 1.0,
"reason": "100% null, no data present"
},
{
"column": "target_column",
"label": "none",
"confidence": 1.0,
"reason": "100% null, no data present"
},
{
"column": "summary",
"label": "none",
"confidence": 0.99,
"reason": "Text description field, 665 distinct values but not a key"
},
{
"column": "evidence_json",
"label": "none",
"confidence": 0.99,
"reason": "JSON blob field containing evidence data, not a key despite high distinctness"
},
{
"column": "status",
"label": "none",
"confidence": 0.99,
"reason": "Only 2 distinct values (open/resolved), categorical status field"
},
{
"column": "first_seen_at",
"label": "none",
"confidence": 0.99,
"reason": "Timestamp field, 210 distinct values but temporal attribute not a key"
},
{
"column": "last_seen_at",
"label": "none",
"confidence": 0.99,
"reason": "Timestamp field, 212 distinct values but temporal attribute not a key"
},
{
"column": "resolved_at",
"label": "none",
"confidence": 0.99,
"reason": "Timestamp field with 90.2% nulls, temporal attribute not a key"
},
{
"column": "confidence",
"label": "none",
"confidence": 0.99,
"reason": "Only 3 distinct numeric values (0.25, 0.95, 1.0), measure attribute"
},
{
"column": "recommended_action",
"label": "none",
"confidence": 0.99,
"reason": "Text description field, 536 distinct values but not a key"
},
{
"column": "falsifier",
"label": "none",
"confidence": 0.99,
"reason": "Text description field, 572 distinct values but not a key"
},
{
"column": "source_table",
"label": "none",
"confidence": 0.95,
"reason": "129 distinct values, appears to be table name reference but not a formal foreign key"
},
{
"column": "group_axes",
"label": "none",
"confidence": 0.99,
"reason": "194 distinct values with 44.8% nulls, categorical attribute"
},
{
"column": "measure",
"label": "none",
"confidence": 0.99,
"reason": "278 distinct values with 0.8% nulls, categorical attribute describing measure type"
},
{
"column": "reducer",
"label": "none",
"confidence": 0.99,
"reason": "Only 2 distinct values (mean/sum) with 50.1% nulls, categorical attribute"
},
{
"column": "reducer_permitted_by",
"label": "none",
"confidence": 0.99,
"reason": "Only 3 distinct values with 50.1% nulls, categorical attribute"
}
]
}
```