PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 5 hours 52 minutes 26 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
61 297
Rejected
0
llm:e84342cc1b19ca5440e019419287f2f246bfc35e42df9e2f68b063b4ca03d6f1
Edit
```json
{
"classifications": [
{
"column": "id",
"label": "primary_key",
"confidence": 1.0,
"reason": "100% distinct (116/116), zero nulls, BIGINT type - perfect primary key"
},
{
"column": "jobs_id",
"label": "foreign_key",
"confidence": 0.95,
"reason": "100% distinct but named with _id suffix suggesting reference to jobs table; likely 1:1 relationship"
},
{
"column": "dataset_id",
"label": "foreign_key",
"confidence": 0.95,
"reason": "75 distinct in 116 rows (65%), _id suffix, references datasets table"
},
{
"column": "batch_id",
"label": "foreign_key",
"confidence": 0.95,
"reason": "113 distinct in 116 rows (97%), _id suffix, references batches table"
},
{
"column": "overall_score",
"label": "none",
"confidence": 1.0,
"reason": "Metric value (0.4-1.0), 38 distinct values, not a key"
},
{
"column": "overall_pct",
"label": "none",
"confidence": 1.0,
"reason": "100% null, no data present"
},
{
"column": "overall_rag",
"label": "none",
"confidence": 1.0,
"reason": "Status indicator (red/amber/green), 3 distinct values"
},
{
"column": "referential_integrity",
"label": "none",
"confidence": 1.0,
"reason": "Metric value (0.0-1.0), 6 distinct values, not a key"
},
{
"column": "referential_integrity_pct",
"label": "none",
"confidence": 1.0,
"reason": "100% null, no data present"
},
{
"column": "referential_integrity_rag",
"label": "none",
"confidence": 1.0,
"reason": "Status indicator (red/green), 2 distinct values, 90.5% null"
},
{
"column": "data_completeness",
"label": "none",
"confidence": 1.0,
"reason": "Metric value (0.62-1.0), 37 distinct values, not a key"
},
{
"column": "data_completeness_pct",
"label": "none",
"confidence": 1.0,
"reason": "100% null, no data present"
},
{
"column": "data_completeness_rag",
"label": "none",
"confidence": 1.0,
"reason": "Status indicator (red/amber/green), 3 distinct values"
},
{
"column": "table_concentration",
"label": "none",
"confidence": 1.0,
"reason": "Metric value (0.20-1.0), 20 distinct values, not a key"
},
{
"column": "table_concentration_pct",
"label": "none",
"confidence": 1.0,
"reason": "100% null, no data present"
},
{
"column": "table_concentration_rag",
"label": "none",
"confidence": 1.0,
"reason": "Status indicator (red/amber/green), 3 distinct values"
},
{
"column": "total_rows",
"label": "none",
"confidence": 1.0,
"reason": "Metric value (52-16.8M), 61 distinct values, not a key"
},
{
"column": "total_rows_label",
"label": "none",
"confidence": 1.0,
"reason": "100% null, no data present"
},
{
"column": "subtitles_json",
"label": "none",
"confidence": 1.0,
"reason": "JSON text field with descriptions, 73 distinct values, 3.4% null"
},
{
"column": "composite_breakdown_json",
"label": "none",
"confidence": 1.0,
"reason": "JSON text field with metric breakdowns, 14 distinct values, 71.6% null"
}
]
}
```