PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 8 hours 14 minutes 18 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 433
Rejected
0
llm:c95cb2cd95a3edc8106539b3870f14586b3bd6825a3a97292038eb686f0fdadc
Edit
```json
{
"table_name": "availability",
"table_type_tags": [
{"tag": "event", "confidence": 0.80},
{"tag": "dimension", "confidence": 0.25}
],
"primary_type": "event",
"insufficient_evidence": false,
"entity": {
"columns": ["beer_id", "place_id"],
"unique_per_row": false
},
"time_axis": {
"columns": ["created_at"],
"kind": "event_time"
},
"reasoning": "avail_id is unique per row (Uniqueness 1.000), but the composite entity (beer_id, place_id) repeats across rows — beer_id RPUV 1.56, place_id RPUV 10.80. The event timestamp created_at (Uniqueness 0.980, Monotonicity 0.980) orders these repeats. A row exists because a user reported a beer's availability at a place — the action is the report itself, recorded by user_id. The boolean flags (is_in_bottle, is_on_tap, is_out) describe the reported state but do not accumulate into a tracked balance; replaying rows does not reconstruct a meaningful entity state beyond 'last reported status'. This is a log of occurrence reports → event. The unique avail_id per report gives a weak secondary dimension reading (each report is a cataloged thing), but the repeating composite entity with timestamped actions is the stronger structure."
}
```