public.email_templates
zozocal@192.168.100.163:5432/zozocalpublic.email_templates
Inspect rows, columns, and indexes using PostgreSQL catalog metadata.
| Actions | id | restaurant_id | template_key | subject | body_html | body_text | placeholders | is_active | created_at | updated_at |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | confirmation | Reservation Confirmed - {{restaurant_name}} | <h2>Your reservation is confirmed!</h2><p>Dear {{guest_name}},</p><p>We have confirmed your reservation:</p><ul><li><strong>Date:</strong> {{date}}</li><li><strong>Time:</strong> {{time}}</li><li><strong>Party Size:</strong> {{party_size}}</li><li><strong>Confirmation Code:</strong> {{confirmation_code}}</li></ul><p>To modify or cancel, visit: {{modify_url}}</p><p>See you soon!<br>{{restaurant_name}}</p> | Your reservation is confirmed! Dear {{guest_name}}, Date: {{date}} Time: {{time}} Party Size: {{party_size}} Confirmation Code: {{confirmation_code}} To modify or cancel, visit: {{modify_url}} See you soon! {{restaurant_name}} | ["guest_name","date","time","party_size","confirmation_code","modify_url","restaurant_name"] | 1 | 2026-03-05 23:19:35 | 2026-03-05 23:19:35 | |
| 2 | 1 | reminder | Reminder: Your Reservation Tomorrow - {{restaurant_name}} | <h2>Reservation Reminder</h2><p>Dear {{guest_name}},</p><p>This is a reminder of your upcoming reservation:</p><ul><li><strong>Date:</strong> {{date}}</li><li><strong>Time:</strong> {{time}}</li><li><strong>Party Size:</strong> {{party_size}}</li></ul><p>Need to make changes? Use your confirmation code <strong>{{confirmation_code}}</strong> at {{modify_url}}</p><p>We look forward to seeing you!<br>{{restaurant_name}}</p> | Reservation Reminder Dear {{guest_name}}, Date: {{date}} Time: {{time}} Party Size: {{party_size}} Confirmation Code: {{confirmation_code}} Need to make changes? Visit: {{modify_url}} We look forward to seeing you! {{restaurant_name}} | ["guest_name","date","time","party_size","confirmation_code","modify_url","restaurant_name"] | 1 | 2026-03-05 23:19:35 | 2026-03-05 23:19:35 | |
| 3 | 1 | cancellation | Reservation Cancelled - {{restaurant_name}} | <h2>Reservation Cancelled</h2><p>Dear {{guest_name}},</p><p>Your reservation has been cancelled:</p><ul><li><strong>Date:</strong> {{date}}</li><li><strong>Time:</strong> {{time}}</li><li><strong>Party Size:</strong> {{party_size}}</li></ul><p>If this was a mistake, please contact us at {{restaurant_phone}} or book a new reservation at {{booking_url}}</p><p>{{restaurant_name}}</p> | Reservation Cancelled Dear {{guest_name}}, Your reservation has been cancelled: Date: {{date}} Time: {{time}} Party Size: {{party_size}} If this was a mistake, contact us at {{restaurant_phone}} {{restaurant_name}} | ["guest_name","date","time","party_size","restaurant_phone","booking_url","restaurant_name"] | 1 | 2026-03-05 23:19:35 | 2026-03-05 23:19:35 | |
| 4 | 1 | waitlist_ready | Your Table is Ready! - {{restaurant_name}} | <h2>Your Table is Ready!</h2><p>Dear {{guest_name}},</p><p>Great news! A table is now available for your party of {{party_size}}.</p><p>Please return to the host stand within 10 minutes to be seated.</p><p>{{restaurant_name}}</p> | Your Table is Ready! Dear {{guest_name}}, A table is now available for your party of {{party_size}}. Please return to the host stand within 10 minutes. {{restaurant_name}} | ["guest_name","party_size","restaurant_name"] | 1 | 2026-03-05 23:19:35 | 2026-03-05 23:19:35 |