Changes between Initial Version and Version 1 of Additional Integrity Constraints

Timestamp:

05/12/26 01:38:06 (2 weeks ago)

Author:

193284

Comment:

--

Additional Integrity Constraints

@@ +1 @@
+= Additional Integrity Constraints =
+
+== Description ==
+
+This section documents additional CHECK and UNIQUE constraints implemented during the advanced database development phase.
+
+== SQL Code ==
+
+{{{
+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);
+}}}