PHPMem v2.0.1
Version
1.6.45
Uptime
15 days 12 hours 54 minutes 39 seconds
Memory
Total
512MB
Used
9,60MB (1.88%)
Free
502,40MB
Keys
Current
11 838
Total (since start)
35 066
Evictions
0
Reclaimed
734
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
14 / 1 024 max
Total
174 073
Rejected
0
llm:f7062a36ca4fd5240f7fbf3e62764765275721e895846fc4215f89e15816838a
Edit
```json
{
"classifications": [
{"column": "STUDYID", "label": "foreign_key", "confidence": 0.95, "reason": "Single value identifier referencing study; typical foreign key to study table"},
{"column": "DOMAIN", "label": "none", "confidence": 0.99, "reason": "Single constant value 'AE' indicating domain type, not a key"},
{"column": "USUBJID", "label": "foreign_key", "confidence": 0.98, "reason": "225 distinct values in 1191 rows (18.9% distinct); subject identifier that repeats, references subject table"},
{"column": "AESEQ", "label": "primary_key", "confidence": 0.92, "reason": "Sequence number; combined with USUBJID forms composite primary key for adverse events"},
{"column": "AESPID", "label": "none", "confidence": 0.85, "reason": "33 distinct sponsor-defined IDs in 1191 rows; repeating identifier but not a key"},
{"column": "AETERM", "label": "none", "confidence": 0.99, "reason": "Adverse event term description; 242 distinct descriptive values"},
{"column": "AELLT", "label": "none", "confidence": 0.99, "reason": "Lowest level term; 326 distinct descriptive values"},
{"column": "AELLTCD", "label": "none", "confidence": 0.99, "reason": "Single missing value placeholder; no key characteristics"},
{"column": "AEDECOD", "label": "none", "confidence": 0.99, "reason": "Decoded term; 242 distinct descriptive values"},
{"column": "AEPTCD", "label": "none", "confidence": 0.99, "reason": "Single missing value placeholder; no key characteristics"},
{"column": "AEHLT", "label": "none", "confidence": 0.99, "reason": "High level term codes; 242 distinct descriptive values"},
{"column": "AEHLTCD", "label": "none", "confidence": 0.99, "reason": "Single missing value placeholder; no key characteristics"},
{"column": "AEHLGT", "label": "none", "confidence": 0.99, "reason": "High level group term; 242 distinct descriptive values"},
{"column": "AEHLGTCD", "label": "none", "confidence": 0.99, "reason": "Single missing value placeholder; no key characteristics"},
{"column": "AEBODSYS", "label": "none", "confidence": 0.99, "reason": "Body system classification; 23 distinct categorical values"},
{"column": "AEBDSYCD", "label": "none", "confidence": 0.99, "reason": "Single missing value placeholder; no key characteristics"},
{"column": "AESOC", "label": "none", "confidence": 0.99, "reason": "System organ class; 23 distinct categorical values"},
{"column": "AESOCCD", "label": "none", "confidence": 0.99, "reason": "Single missing value placeholder; no key characteristics"},
{"column": "AESEV", "label": "none", "confidence": 0.99, "reason": "Severity with 3 values (MILD/MODERATE/SEVERE); categorical attribute"},
{"column": "AESER", "label": "none", "confidence": 0.99, "reason": "Serious flag with 2 values (Y/N); boolean attribute"},
{"column": "AEACN", "label": "none", "confidence": 0.99, "reason": "Single missing value placeholder; no key characteristics"},
{"column": "AEREL", "label": "none", "confidence": 0.99, "reason": "Relationship assessment; 5 distinct categorical values"},
{"column": "AEOUT", "label": "none", "confidence": 0.99, "reason": "Outcome with 3 values; categorical attribute"},
{"column": "AESCAN", "label": "none", "confidence": 0.99, "reason": "Scan flag with 2 values (Y/N); boolean attribute"},
{"column": "AESCONG", "label": "none", "confidence": 0.99, "reason": "Single value 'N'; constant boolean attribute"},
{"column": "AESDISAB", "label": "none", "confidence": 0.99, "reason": "Disability flag with 2 values (Y/N); boolean attribute"},
{"column": "AESDTH", "label": "none", "confidence": 0.99, "reason": "Death flag with 2 values (Y/N); boolean attribute"},
{"column": "AESHOSP", "label": "none", "confidence": 0.99, "reason": "Hospitalization flag with 2 values (Y/N); boolean attribute"},
{"column": "AESLIFE", "label": "none", "confidence": 0.99, "reason": "Life threatening flag with 2 values (Y/N); boolean attribute"},
{"column": "AESOD", "label": "none", "confidence": 0.99, "reason": "Single value 'N'; constant boolean attribute"},
{"column": "AEDTC", "label": "none", "confidence": 0.99, "reason": "Date/time of event; 453 distinct dates, temporal attribute"},
{"column": "AESTDTC", "label": "none", "confidence": 0.99, "reason": "Start date/time; 438 distinct values, temporal attribute"},
{"column": "AEENDTC", "label": "none", "confidence": 0.99, "reason": "End date/time; 281 distinct values, temporal attribute"},
{"column": "AESTDY", "label": "none", "confidence": 0.99, "reason": "Start study day; 173 distinct numeric values, temporal attribute"},
{"column": "AEENDY", "label": "none", "confidence": 0.99, "reason": "End study day; 146 distinct values, temporal attribute"}
]
}
```