public.activity_log
zozocal@192.168.100.163:5432/zozocalpublic.activity_log
Inspect rows, columns, and indexes using PostgreSQL catalog metadata.
| Actions | id | restaurant_id | user_id | action | entity_type | entity_id | description | old_value | new_value | ip_address | created_at |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | NULL | create | reservation | 1 | Created reservation #B31BD9BE1B for Edward Honour, party of 2 on 2026-03-09 at 11:00am | NULL | NULL | 192.168.100.1 | 2026-03-07 01:24:35 | |
| 2 | 1 | NULL | status_change | reservation | 1 | Status changed from confirmed to seated for reservation #B31BD9BE1B | {"status":"confirmed"} | {"status":"seated"} | 192.168.100.1 | 2026-03-07 01:26:35 | |
| 3 | 1 | NULL | create | reservation | 2 | Created reservation #43F4B5B686 for John Smith, party of 2 on 2026-03-07 at 5:00pm | NULL | NULL | 192.168.100.1 | 2026-03-07 17:28:28 | |
| 4 | 1 | NULL | create | reservation | 3 | Walk-in seated: jeff lozinski, party of 2 | NULL | NULL | 192.168.100.1 | 2026-03-07 18:01:23 | |
| 5 | 1 | NULL | create | reservation | 4 | Created reservation #4ED146C1DE for lisa lozinski, party of 2 on 2026-03-07 at 7:30pm | NULL | NULL | 192.168.100.1 | 2026-03-07 18:04:51 | |
| 6 | 1 | NULL | status_change | reservation | 2 | Status changed from confirmed to seated for reservation #43F4B5B686 | {"status":"confirmed"} | {"status":"seated"} | 192.168.100.1 | 2026-03-07 21:40:55 | |
| 7 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 03:13:36 | |
| 8 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 03:13:46 | |
| 9 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 03:13:46 | |
| 10 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 03:15:43 | |
| 11 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 03:15:47 | |
| 12 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 03:15:47 | |
| 13 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 03:26:34 | |
| 14 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 03:26:39 | |
| 15 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 03:26:39 | |
| 16 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 03:31:39 | |
| 17 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 03:31:41 | |
| 18 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 03:31:50 | |
| 19 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 03:31:50 | |
| 20 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 03:32:04 | |
| 21 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 03:32:07 | |
| 22 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 03:32:45 | |
| 23 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 03:32:47 | |
| 24 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 03:37:48 | |
| 25 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 03:37:51 | |
| 26 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 03:38:47 | |
| 27 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 03:38:47 | |
| 28 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 13:42:43 | |
| 29 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 13:42:48 | |
| 30 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 13:43:19 | |
| 31 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 13:43:19 | |
| 32 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 13:52:52 | |
| 33 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 13:52:54 | |
| 34 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 13:53:20 | |
| 35 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 13:53:20 | |
| 36 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 13:53:36 | |
| 37 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 13:53:38 | |
| 38 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 13:54:06 | |
| 39 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 13:54:06 | |
| 40 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 13:57:20 | |
| 41 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 13:57:22 | |
| 42 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 13:58:00 | |
| 43 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 13:58:00 | |
| 44 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 14:09:19 | |
| 45 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 14:09:21 | |
| 46 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 14:09:22 | |
| 47 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 14:09:22 | |
| 48 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 14:11:26 | |
| 49 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 14:11:28 | |
| 50 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 14:12:37 | |
| 51 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 14:12:37 | |
| 52 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 14:13:21 | |
| 53 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 14:13:23 | |
| 54 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 14:13:52 | |
| 55 | 3 | NULL | voice_call_started | voice_call | NULL | Inbound call started from +12025700557 to +18473930142 (known guest: Edward Honour) | NULL | NULL | 192.168.100.1 | 2026-03-08 14:13:52 | |
| 56 | 3 | 3 | update | reservation | 6 | Edited reservation #83896B0249: date=2026-03-08, time=19:30, party=2 | {"date":"2026-03-08","time":"18:30:00","party_size":2} | {"date":"2026-03-08","time":"19:30","party_size":2} | 192.168.100.1 | 2026-03-08 14:39:00 | |
| 57 | 3 | 3 | update | reservation | 6 | Edited reservation #83896B0249: date=2026-03-08, time=19:30, party=2 | {"date":"2026-03-08","time":"19:30:00","party_size":2} | {"date":"2026-03-08","time":"19:30","party_size":2} | 192.168.100.1 | 2026-03-08 14:40:40 | |
| 58 | 3 | 3 | create | reservation | 7 | Walk-in seated: Walk In, party of 2 | NULL | NULL | 192.168.100.1 | 2026-03-08 14:49:44 | |
| 59 | 3 | 3 | create | reservation | 8 | Walk-in seated: New Customer, party of 2 | NULL | NULL | 192.168.100.1 | 2026-03-08 14:49:56 | |
| 60 | 3 | 3 | create | reservation | 9 | Walk-in seated: Anonymous, party of 2 | NULL | NULL | 192.168.100.1 | 2026-03-08 14:54:12 | |
| 61 | 3 | 3 | create | reservation | 10 | Walk-in seated: Anonymous, party of 2 | NULL | NULL | 192.168.100.1 | 2026-03-08 14:54:22 | |
| 62 | 3 | 3 | create | reservation | 11 | Walk-in seated: Anonymous, party of 2 | NULL | NULL | 192.168.100.1 | 2026-03-08 14:57:31 | |
| 63 | 3 | 3 | update | reservation | 10 | Table completed and opened | NULL | NULL | 192.168.100.1 | 2026-03-08 15:03:36 | |
| 64 | 3 | 3 | create | reservation | 12 | Walk-in seated: Anonymous, party of 2 | NULL | NULL | 192.168.100.1 | 2026-03-08 15:18:54 | |
| 65 | 3 | 3 | create | reservation | 13 | Created reservation #5FF94AF0EC for John Doe, party of 2 on 2026-03-08 at 11:00am | NULL | NULL | 192.168.100.1 | 2026-03-08 15:20:01 | |
| 66 | 3 | 3 | status_change | reservation | 13 | Status changed from confirmed to cancelled for reservation #5FF94AF0EC | {"status":"confirmed"} | {"status":"cancelled"} | 192.168.100.1 | 2026-03-08 23:18:36 | |
| 67 | 3 | 3 | update | reservation | 8 | Table completed and opened | NULL | NULL | 192.168.100.1 | 2026-03-08 23:29:34 | |
| 68 | 3 | 3 | update | reservation | 9 | Table completed and opened | NULL | NULL | 192.168.100.1 | 2026-03-08 23:29:38 | |
| 69 | 3 | 3 | update | reservation | 7 | Table completed and opened | NULL | NULL | 192.168.100.1 | 2026-03-08 23:29:43 | |
| 70 | 3 | 3 | update | reservation | 11 | Table completed and opened | NULL | NULL | 192.168.100.1 | 2026-03-08 23:29:46 | |
| 71 | 3 | 3 | update | reservation | 12 | Table completed and opened | NULL | NULL | 192.168.100.1 | 2026-03-08 23:29:50 | |
| 72 | 3 | 3 | status_change | reservation | 6 | Status changed from confirmed to cancelled for reservation #83896B0249 | {"status":"confirmed"} | {"status":"cancelled"} | 192.168.100.1 | 2026-03-08 23:29:59 | |
| 73 | 3 | 3 | create | reservation | 14 | Walk-in seated: Anonymous, party of 2 | NULL | NULL | 192.168.100.1 | 2026-03-08 23:30:14 | |
| 74 | 3 | 3 | create | reservation | 15 | Walk-in seated: Anonymous, party of 2 | NULL | NULL | 192.168.100.1 | 2026-03-08 23:30:15 | |
| 75 | 3 | 3 | create | reservation | 16 | Walk-in seated: Anonymous, party of 2 | NULL | NULL | 192.168.100.1 | 2026-03-08 23:30:17 | |
| 76 | 3 | 3 | create | reservation | 17 | Walk-in seated: Anonymous, party of 2 | NULL | NULL | 192.168.100.1 | 2026-03-08 23:30:18 | |
| 77 | 3 | 3 | create | reservation | 18 | Walk-in seated: Anonymous, party of 2 | NULL | NULL | 192.168.100.1 | 2026-03-08 23:30:19 | |
| 78 | 3 | 3 | create | reservation | 19 | Walk-in seated: Anonymous, party of 2 | NULL | NULL | 192.168.100.1 | 2026-03-08 23:30:22 | |
| 79 | 3 | 3 | create | reservation | 20 | Walk-in seated: Anonymous, party of 2 | NULL | NULL | 192.168.100.1 | 2026-03-08 23:30:24 | |
| 80 | 3 | 3 | create | reservation | 21 | Walk-in seated: Anonymous, party of 2 | NULL | NULL | 192.168.100.1 | 2026-03-08 23:30:25 | |
| 81 | 3 | 3 | create | waitlist | 1 | Added Ed (party of 2) to waitlist at position #1 | NULL | NULL | 192.168.100.1 | 2026-03-08 23:30:38 | |
| 82 | 3 | 3 | create | waitlist | 2 | Added John (party of 2) to waitlist at position #2 | NULL | NULL | 192.168.100.1 | 2026-03-08 23:32:04 | |
| 83 | 3 | 3 | notify | waitlist | 1 | Table ready for Ed — called/announced (call #1) | NULL | NULL | 192.168.100.1 | 2026-03-08 23:54:28 | |
| 84 | 3 | 3 | update | reservation | 14 | Table completed and opened | NULL | NULL | 192.168.100.1 | 2026-03-09 00:01:05 | |
| 85 | 3 | 3 | status_change | waitlist | 1 | Seated Ed (party of 2) from waitlist at 101 - Window 4-Top | NULL | NULL | 192.168.100.1 | 2026-03-09 00:03:59 | |
| 86 | 3 | 3 | create | waitlist | 3 | Added Steven (party of 2) to waitlist at position #3 | NULL | NULL | 192.168.100.1 | 2026-03-09 00:07:30 | |
| 87 | 3 | 3 | create | waitlist | 4 | Added Glen (party of 4) to waitlist at position #4 | NULL | NULL | 192.168.100.1 | 2026-03-09 00:08:15 | |
| 88 | 3 | 3 | status_change | waitlist | 2 | Waitlist: John marked as left | NULL | NULL | 192.168.100.1 | 2026-03-09 12:41:28 | |
| 89 | 3 | 3 | status_change | waitlist | 4 | Waitlist: Glen marked as left | NULL | NULL | 192.168.100.1 | 2026-03-09 12:41:31 | |
| 90 | 3 | 3 | status_change | waitlist | 3 | Waitlist: Steven marked as left | NULL | NULL | 192.168.100.1 | 2026-03-09 12:41:34 | |
| 91 | 3 | 3 | create | reservation | 23 | Walk-in seated: Anonymous, party of 2 | NULL | NULL | 192.168.100.1 | 2026-03-09 12:42:48 | |
| 92 | 3 | 3 | create | reservation | 24 | Walk-in seated: Anonymous, party of 2 | NULL | NULL | 192.168.100.1 | 2026-03-09 19:34:04 | |
| 93 | 3 | 3 | create | reservation | 25 | Created reservation #E447060174 for Edward Honour, party of 2 on 2026-03-09 at 11:00am | NULL | NULL | 192.168.100.1 | 2026-03-09 19:55:03 | |
| 94 | 3 | 3 | create | reservation | 26 | Created reservation #290603E03A for Jef Loz, party of 2 on 2026-03-09 at 2:30pm | NULL | NULL | 192.168.100.1 | 2026-03-09 19:59:51 | |
| 95 | 3 | 3 | check_in | reservation | 25 | Guest checked in | NULL | NULL | 192.168.100.1 | 2026-03-09 20:11:39 | |
| 96 | 3 | 3 | create | waitlist | 5 | Added Mary (party of 2) to waitlist at position #1 | NULL | NULL | 192.168.100.1 | 2026-03-09 20:12:07 | |
| 97 | 3 | 3 | status_change | reservation | 25 | Status changed from confirmed to seated for reservation #E447060174 | {"status":"confirmed"} | {"status":"seated"} | 192.168.100.1 | 2026-03-09 20:13:53 | |
| 98 | 3 | 3 | check_in | reservation | 26 | Guest checked in | NULL | NULL | 192.168.100.1 | 2026-03-09 20:19:23 | |
| 99 | 3 | 3 | notify | reservation | 26 | Table ready for Jef Loz — SMS failed | NULL | NULL | 192.168.100.1 | 2026-03-09 20:19:26 | |
| 100 | 3 | 3 | notify | reservation | 26 | Table ready for Jef Loz — SMS failed | NULL | NULL | 192.168.100.1 | 2026-03-09 20:19:27 |