PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 6 hours 50 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
3 / 1 024 max
Total
62 184
Rejected
0
llm:53ecafed4eb4fcb48529ec1a3f51c0b69bdb984c3c154e55437f4136c3ffc2dc
Edit
```json
{
"classifications": [
{
"column": "job_id",
"role": "identifier",
"confidence": 1.0,
"reason": "Primary key with unique values (15000 distinct in 15000 rows) in format AI00001"
},
{
"column": "job_title",
"role": "dimension",
"confidence": 1.0,
"reason": "Low cardinality (20 distinct) categorical field used for grouping and filtering"
},
{
"column": "salary_usd",
"role": "measure",
"confidence": 1.0,
"reason": "Numeric quantity to aggregate (sum/avg), ranges from 32519 to 399095"
},
{
"column": "salary_currency",
"role": "dimension",
"confidence": 1.0,
"reason": "Low cardinality (3 values: EUR, GBP, USD) categorical field for grouping"
},
{
"column": "experience_level",
"role": "dimension",
"confidence": 1.0,
"reason": "Low cardinality (4 codes: EN, EX, MI, SE) categorical field for filtering/grouping"
},
{
"column": "employment_type",
"role": "dimension",
"confidence": 1.0,
"reason": "Low cardinality (4 codes: CT, FL, FT, PT) categorical field for grouping"
},
{
"column": "company_location",
"role": "dimension",
"confidence": 1.0,
"reason": "Medium cardinality (20 countries) categorical field for geographic grouping"
},
{
"column": "company_size",
"role": "dimension",
"confidence": 1.0,
"reason": "Low cardinality (3 values: L, M, S) categorical field for grouping"
},
{
"column": "employee_residence",
"role": "dimension",
"confidence": 1.0,
"reason": "Medium cardinality (20 countries) categorical field for geographic grouping"
},
{
"column": "remote_ratio",
"role": "dimension",
"confidence": 1.0,
"reason": "Low cardinality (3 values: 0, 50, 100) categorical percentage used for grouping"
},
{
"column": "required_skills",
"role": "attribute",
"confidence": 1.0,
"reason": "High cardinality (13663 distinct) free-form text listing skills, displayed but not aggregated"
},
{
"column": "education_required",
"role": "dimension",
"confidence": 1.0,
"reason": "Low cardinality (4 values: Associate, Bachelor, Master, PhD) categorical field for grouping"
},
{
"column": "years_experience",
"role": "measure",
"confidence": 0.95,
"reason": "Numeric quantity (0-19) typically aggregated with avg/sum for analysis"
},
{
"column": "industry",
"role": "dimension",
"confidence": 1.0,
"reason": "Medium cardinality (15 industries) categorical field for grouping"
},
{
"column": "posting_date",
"role": "dimension",
"confidence": 1.0,
"reason": "Date field (486 distinct dates) used for time-based grouping and filtering"
},
{
"column": "application_deadline",
"role": "dimension",
"confidence": 1.0,
"reason": "Date field (543 distinct dates) used for time-based grouping and filtering"
},
{
"column": "job_description_length",
"role": "measure",
"confidence": 1.0,
"reason": "Numeric quantity (500-2499) to aggregate for analysis of description sizes"
},
{
"column": "benefits_score",
"role": "measure",
"confidence": 1.0,
"reason": "Numeric score (5.0-10.0) to aggregate with avg/sum for benefits analysis"
},
{
"column": "company_name",
"role": "dimension",
"confidence": 0.95,
"reason": "Low cardinality (16 companies) used for grouping, though could be attribute if display-only"
}
]
}
```