= Trigger Functions =

== Description ==

This section documents the PostgreSQL PL/pgSQL trigger functions implemented for automatic validation and conflict prevention.

The triggers are executed automatically during INSERT and UPDATE operations.

== 1. Venue Booking Conflict Prevention ==

=== Description ===

This trigger prevents overlapping venue bookings for the same venue and time interval.

=== SQL Code ===

{{collapse(View SQL Code)
<syntaxhighlight lang="sql">
PASTE SQL FROM advanced_triggers.sql
</syntaxhighlight>
}}

== 2. Photographer Booking Conflict Prevention ==

=== Description ===

This trigger prevents overlapping photographer bookings.

== 3. Band Booking Conflict Prevention ==

=== Description ===

This trigger prevents overlapping band reservations.

== 4. Attendance Consistency Validation ==

=== Description ===

This trigger validates attendance records against RSVP responses.