P7: advanced_constraints.sql
| File advanced_constraints.sql, 408 bytes (added by , 2 weeks ago) |
|---|
| Line | |
|---|---|
| 1 | ALTER TABLE event_rsvp |
| 2 | ADD CONSTRAINT chk_rsvp_status |
| 3 | CHECK (status IN ('accepted', 'declined', 'pending')); |
| 4 | |
| 5 | ALTER TABLE attendance |
| 6 | ADD CONSTRAINT chk_attendance_status |
| 7 | CHECK (status IN ('attending', 'absent')); |
| 8 | |
| 9 | ALTER TABLE event_rsvp |
| 10 | ADD CONSTRAINT uq_guest_event_rsvp |
| 11 | UNIQUE (guest_id, event_id); |
| 12 | |
| 13 | ALTER TABLE attendance |
| 14 | ADD CONSTRAINT uq_guest_event_attendance |
| 15 | UNIQUE (guest_id, event_id); |
