Changes between Version 2 and Version 3 of Additional Integrity Constraints

Timestamp:

05/12/26 02:32:43 (2 weeks ago)

Author:

193284

Comment:

--

Additional Integrity Constraints

@@ -7 +7 @@
 === SQL Code ===
 
-{{collapse(View SQL Code)
-<syntaxhighlight lang="sql">
-PASTE SQL FROM advanced_constraints.sql
-</syntaxhighlight>
-}}
+<pre>
+ALTER TABLE event_rsvp
+ADD CONSTRAINT chk_rsvp_status
+CHECK (status IN ('accepted', 'declined', 'pending'));
+
+ALTER TABLE attendance
+ADD CONSTRAINT chk_attendance_status
+CHECK (status IN ('attending', 'absent'));
+
+ALTER TABLE event_rsvp
+ADD CONSTRAINT uq_guest_event_rsvp
+UNIQUE (guest_id, event_id);
+
+ALTER TABLE attendance
+ADD CONSTRAINT uq_guest_event_attendance
+UNIQUE (guest_id, event_id);
+</pre>