public.settings
zozocal@192.168.100.163:5432/zozocalpublic.settings
Inspect rows, columns, and indexes using PostgreSQL catalog metadata.
| Actions | id | restaurant_id | setting_key | setting_value | category | description | created_at | updated_at |
|---|---|---|---|---|---|---|---|---|
| 1 | 1 | time_slot_interval | 30 | reservations | Booking time slot interval in minutes | 2026-03-05 23:18:40 | 2026-03-05 23:18:40 | |
| 2 | 1 | advance_booking_min_hours | 2 | reservations | Minimum hours in advance for booking | 2026-03-05 23:18:40 | 2026-03-05 23:18:40 | |
| 3 | 1 | advance_booking_max_days | 60 | reservations | Maximum days in advance for booking | 2026-03-05 23:18:40 | 2026-03-05 23:18:40 | |
| 4 | 1 | same_day_cutoff_time | 20:00 | reservations | Latest time for same-day online booking | 2026-03-05 23:18:40 | 2026-03-05 23:18:40 | |
| 5 | 1 | max_online_party_size | 8 | reservations | Max party size for online booking; larger requires phone | 2026-03-05 23:18:40 | 2026-03-05 23:18:40 | |
| 6 | 1 | default_buffer_minutes | 15 | reservations | Default buffer between seatings | 2026-03-05 23:18:40 | 2026-03-05 23:18:40 | |
| 7 | 1 | max_covers_per_slot | 0 | reservations | 0 = no limit; otherwise max covers per time slot | 2026-03-05 23:18:40 | 2026-03-05 23:18:40 | |
| 8 | 1 | online_table_hold_percent | 80 | reservations | Percent of tables available for online booking | 2026-03-05 23:18:40 | 2026-03-05 23:18:40 | |
| 9 | 1 | cancellation_policy | Cancellations must be made at least 2 hours before the reservation time. | reservations | Cancellation policy text shown to guests | 2026-03-05 23:18:40 | 2026-03-05 23:18:40 | |
| 10 | 1 | deposit_required_party_size | 0 | reservations | 0 = no deposit; otherwise min party size requiring deposit | 2026-03-05 23:18:40 | 2026-03-05 23:18:40 | |
| 11 | 1 | deposit_amount | 0.00 | reservations | Deposit amount per person | 2026-03-05 23:18:40 | 2026-03-05 23:18:40 | |
| 12 | 1 | reminder_hours_before | 24 | notifications | Hours before reservation to send reminder | 2026-03-05 23:18:40 | 2026-03-05 23:18:40 | |
| 13 | 1 | reminder_enabled | 1 | notifications | Enable/disable reminder notifications | 2026-03-05 23:18:40 | 2026-03-05 23:18:40 | |
| 14 | 1 | confirmation_email_enabled | 1 | notifications | Send confirmation email on booking | 2026-03-05 23:18:40 | 2026-03-05 23:18:40 | |
| 15 | 1 | confirmation_sms_enabled | 0 | notifications | Send confirmation SMS on booking | 2026-03-05 23:18:40 | 2026-03-05 23:18:40 | |
| 16 | 1 | sms_provider | (empty) | notifications | SMS provider: twilio, vonage, or empty for disabled | 2026-03-05 23:18:40 | 2026-03-05 23:18:40 | |
| 17 | 1 | sms_api_key | (empty) | notifications | SMS provider API key | 2026-03-05 23:18:40 | 2026-03-05 23:18:40 | |
| 18 | 1 | sms_api_secret | (empty) | notifications | SMS provider API secret | 2026-03-05 23:18:40 | 2026-03-05 23:18:40 | |
| 19 | 1 | sms_from_number | (empty) | notifications | SMS sender phone number | 2026-03-05 23:18:40 | 2026-03-05 23:18:40 | |
| 35 | 3 | time_slot_interval | 30 | general | NULL | 2026-03-07 23:48:41 | 2026-03-07 23:48:41 | |
| 36 | 3 | default_turn_time | 90 | general | NULL | 2026-03-07 23:48:41 | 2026-03-07 23:48:41 | |
| 37 | 3 | buffer_time | 15 | general | NULL | 2026-03-07 23:48:41 | 2026-03-07 23:48:41 | |
| 38 | 3 | max_party_size | 12 | general | NULL | 2026-03-07 23:48:41 | 2026-03-07 23:48:41 | |
| 39 | 3 | max_online_party_size | 8 | general | NULL | 2026-03-07 23:48:41 | 2026-03-07 23:48:41 | |
| 40 | 3 | advance_booking_min_hours | 2 | general | NULL | 2026-03-07 23:48:41 | 2026-03-07 23:48:41 | |
| 41 | 3 | advance_booking_max_days | 30 | general | NULL | 2026-03-07 23:48:41 | 2026-03-07 23:48:41 | |
| 42 | 3 | same_day_cutoff_hours | 1 | general | NULL | 2026-03-07 23:48:41 | 2026-03-07 23:48:41 | |
| 43 | 3 | max_covers_per_slot | 0 | general | NULL | 2026-03-07 23:48:41 | 2026-03-07 23:48:41 | |
| 44 | 3 | online_table_hold_percent | 70 | general | NULL | 2026-03-07 23:48:41 | 2026-03-07 23:48:41 | |
| 45 | 3 | confirmation_email_enabled | 1 | general | NULL | 2026-03-07 23:48:41 | 2026-03-07 23:48:41 | |
| 46 | 3 | reminder_email_enabled | 1 | general | NULL | 2026-03-07 23:48:41 | 2026-03-07 23:48:41 | |
| 47 | 3 | reminder_hours_before | 24 | general | NULL | 2026-03-07 23:48:41 | 2026-03-07 23:48:41 | |
| 48 | 3 | cancellation_email_enabled | 1 | general | NULL | 2026-03-07 23:48:41 | 2026-03-07 23:48:41 | |
| 49 | 3 | cancellation_policy | Please cancel at least 2 hours before your reservation time. | general | NULL | 2026-03-07 23:48:41 | 2026-03-07 23:48:41 | |
| 50 | 1 | retell_api_key | key_ff41192a479846a883eeceada1e3 | general | NULL | 2026-03-08 03:19:55 | 2026-03-08 03:20:20 | |
| 51 | 1 | retell_agent_id | agent_34e6ac5fc8792f0d02ccea1e9a | general | NULL | 2026-03-08 03:19:55 | 2026-03-08 03:21:06 | |
| 52 | 3 | meal_pct_seated | 0 | operations | Meal progress % for Seated status | 2026-03-08 15:13:19 | 2026-03-08 15:13:19 | |
| 53 | 3 | meal_pct_ordering | 20 | operations | Meal progress % for Ordering status | 2026-03-08 15:13:19 | 2026-03-08 15:13:19 | |
| 54 | 3 | meal_pct_eating | 40 | operations | Meal progress % for Eating status | 2026-03-08 15:13:19 | 2026-03-08 15:13:19 | |
| 55 | 3 | meal_pct_check_dropped | 80 | operations | Meal progress % for Check Dropped status | 2026-03-08 15:13:19 | 2026-03-08 15:13:19 | |
| 56 | 3 | meal_pct_paid | 95 | operations | Meal progress % for Paid status | 2026-03-08 15:13:19 | 2026-03-08 15:13:19 | |
| 57 | 1 | mailersend_api_key | mlsn.db9fb0b36a03a33ff21f0307ce00567942f118fbdf8393d1a716eded216a5e98 | general | NULL | 2026-03-08 22:53:58 | 2026-03-08 22:53:58 | |
| 58 | 3 | mailersend_api_key | mlsn.db9fb0b36a03a33ff21f0307ce00567942f118fbdf8393d1a716eded216a5e98 | general | NULL | 2026-03-08 22:53:58 | 2026-03-08 22:53:58 | |
| 59 | 1 | notification_from_email | support@zozocal.com | general | NULL | 2026-03-08 23:00:15 | 2026-03-08 23:00:15 | |
| 76 | 5 | time_slot_interval | 30 | general | NULL | 2026-03-11 00:54:42 | 2026-03-11 00:54:42 | |
| 77 | 5 | default_turn_time | 90 | general | NULL | 2026-03-11 00:54:42 | 2026-03-11 00:54:42 | |
| 78 | 5 | buffer_time | 15 | general | NULL | 2026-03-11 00:54:42 | 2026-03-11 00:54:42 | |
| 79 | 5 | max_party_size | 12 | general | NULL | 2026-03-11 00:54:42 | 2026-03-11 00:54:42 | |
| 80 | 5 | max_online_party_size | 8 | general | NULL | 2026-03-11 00:54:42 | 2026-03-11 00:54:42 | |
| 81 | 5 | advance_booking_min_hours | 2 | general | NULL | 2026-03-11 00:54:42 | 2026-03-11 00:54:42 | |
| 82 | 5 | advance_booking_max_days | 30 | general | NULL | 2026-03-11 00:54:42 | 2026-03-11 00:54:42 | |
| 83 | 5 | same_day_cutoff_hours | 1 | general | NULL | 2026-03-11 00:54:42 | 2026-03-11 00:54:42 | |
| 84 | 5 | max_covers_per_slot | 0 | general | NULL | 2026-03-11 00:54:42 | 2026-03-11 00:54:42 | |
| 85 | 5 | online_table_hold_percent | 70 | general | NULL | 2026-03-11 00:54:42 | 2026-03-11 00:54:42 | |
| 86 | 5 | confirmation_email_enabled | 1 | general | NULL | 2026-03-11 00:54:42 | 2026-03-11 00:54:42 | |
| 87 | 5 | reminder_email_enabled | 1 | general | NULL | 2026-03-11 00:54:42 | 2026-03-11 00:54:42 | |
| 88 | 5 | reminder_hours_before | 24 | general | NULL | 2026-03-11 00:54:42 | 2026-03-11 00:54:42 | |
| 89 | 5 | cancellation_email_enabled | 1 | general | NULL | 2026-03-11 00:54:42 | 2026-03-11 00:54:42 | |
| 90 | 5 | cancellation_policy | Please cancel at least 2 hours before your reservation time. | general | NULL | 2026-03-11 00:54:42 | 2026-03-11 00:54:42 | |
| 106 | 8 | time_slot_interval | 30 | general | NULL | 2026-03-16 00:26:31 | 2026-03-16 00:26:31 | |
| 107 | 8 | default_turn_time | 90 | general | NULL | 2026-03-16 00:26:31 | 2026-03-16 00:26:31 | |
| 108 | 8 | buffer_time | 15 | general | NULL | 2026-03-16 00:26:31 | 2026-03-16 00:26:31 | |
| 109 | 8 | max_party_size | 12 | general | NULL | 2026-03-16 00:26:31 | 2026-03-16 00:26:31 | |
| 110 | 8 | max_online_party_size | 8 | general | NULL | 2026-03-16 00:26:31 | 2026-03-16 00:26:31 | |
| 111 | 8 | advance_booking_min_hours | 2 | general | NULL | 2026-03-16 00:26:31 | 2026-03-16 00:26:31 | |
| 112 | 8 | advance_booking_max_days | 30 | general | NULL | 2026-03-16 00:26:31 | 2026-03-16 00:26:31 | |
| 113 | 8 | same_day_cutoff_hours | 1 | general | NULL | 2026-03-16 00:26:31 | 2026-03-16 00:26:31 | |
| 114 | 8 | max_covers_per_slot | 0 | general | NULL | 2026-03-16 00:26:31 | 2026-03-16 00:26:31 | |
| 115 | 8 | online_table_hold_percent | 70 | general | NULL | 2026-03-16 00:26:31 | 2026-03-16 00:26:31 | |
| 116 | 8 | confirmation_email_enabled | 1 | general | NULL | 2026-03-16 00:26:31 | 2026-03-16 00:26:31 | |
| 117 | 8 | reminder_email_enabled | 1 | general | NULL | 2026-03-16 00:26:31 | 2026-03-16 00:26:31 | |
| 118 | 8 | reminder_hours_before | 24 | general | NULL | 2026-03-16 00:26:31 | 2026-03-16 00:26:31 | |
| 119 | 8 | cancellation_email_enabled | 1 | general | NULL | 2026-03-16 00:26:31 | 2026-03-16 00:26:31 | |
| 120 | 8 | cancellation_policy | Please cancel at least 2 hours before your reservation time. | general | NULL | 2026-03-16 00:26:31 | 2026-03-16 00:26:31 | |
| 136 | 10 | time_slot_interval | 30 | general | NULL | 2026-03-16 00:44:15 | 2026-03-16 00:44:15 | |
| 137 | 10 | default_turn_time | 90 | general | NULL | 2026-03-16 00:44:15 | 2026-03-16 00:44:15 | |
| 138 | 10 | buffer_time | 15 | general | NULL | 2026-03-16 00:44:15 | 2026-03-16 00:44:15 | |
| 139 | 10 | max_party_size | 12 | general | NULL | 2026-03-16 00:44:15 | 2026-03-16 00:44:15 | |
| 140 | 10 | max_online_party_size | 8 | general | NULL | 2026-03-16 00:44:15 | 2026-03-16 00:44:15 | |
| 141 | 10 | advance_booking_min_hours | 2 | general | NULL | 2026-03-16 00:44:15 | 2026-03-16 00:44:15 | |
| 142 | 10 | advance_booking_max_days | 30 | general | NULL | 2026-03-16 00:44:15 | 2026-03-16 00:44:15 | |
| 143 | 10 | same_day_cutoff_hours | 1 | general | NULL | 2026-03-16 00:44:15 | 2026-03-16 00:44:15 | |
| 144 | 10 | max_covers_per_slot | 0 | general | NULL | 2026-03-16 00:44:15 | 2026-03-16 00:44:15 | |
| 145 | 10 | online_table_hold_percent | 70 | general | NULL | 2026-03-16 00:44:15 | 2026-03-16 00:44:15 | |
| 146 | 10 | confirmation_email_enabled | 1 | general | NULL | 2026-03-16 00:44:15 | 2026-03-16 00:44:15 | |
| 147 | 10 | reminder_email_enabled | 1 | general | NULL | 2026-03-16 00:44:15 | 2026-03-16 00:44:15 | |
| 148 | 10 | reminder_hours_before | 24 | general | NULL | 2026-03-16 00:44:15 | 2026-03-16 00:44:15 | |
| 149 | 10 | cancellation_email_enabled | 1 | general | NULL | 2026-03-16 00:44:15 | 2026-03-16 00:44:15 | |
| 150 | 10 | cancellation_policy | Please cancel at least 2 hours before your reservation time. | general | NULL | 2026-03-16 00:44:15 | 2026-03-16 00:44:15 | |
| 155 | 12 | time_slot_interval | 30 | general | NULL | 2026-03-18 23:28:21 | 2026-03-18 23:28:21 | |
| 156 | 12 | default_turn_time | 90 | general | NULL | 2026-03-18 23:28:21 | 2026-03-18 23:28:21 | |
| 157 | 12 | buffer_time | 15 | general | NULL | 2026-03-18 23:28:21 | 2026-03-18 23:28:21 | |
| 158 | 12 | max_party_size | 12 | general | NULL | 2026-03-18 23:28:21 | 2026-03-18 23:28:21 | |
| 159 | 12 | max_online_party_size | 8 | general | NULL | 2026-03-18 23:28:21 | 2026-03-18 23:28:21 | |
| 160 | 12 | advance_booking_min_hours | 2 | general | NULL | 2026-03-18 23:28:21 | 2026-03-18 23:28:21 | |
| 161 | 12 | advance_booking_max_days | 30 | general | NULL | 2026-03-18 23:28:21 | 2026-03-18 23:28:21 | |
| 162 | 12 | same_day_cutoff_hours | 1 | general | NULL | 2026-03-18 23:28:21 | 2026-03-18 23:28:21 | |
| 163 | 12 | max_covers_per_slot | 0 | general | NULL | 2026-03-18 23:28:21 | 2026-03-18 23:28:21 | |
| 164 | 12 | online_table_hold_percent | 70 | general | NULL | 2026-03-18 23:28:21 | 2026-03-18 23:28:21 | |
| 165 | 12 | confirmation_email_enabled | 1 | general | NULL | 2026-03-18 23:28:21 | 2026-03-18 23:28:21 |