컬럼 구조
id int
submission_id int
notification_type enum('email','dashboard')
recipient_id int
recipient_email varchar(255)
sent_at timestamp
status enum('sent','failed')
| id | submission_id | notification_type | recipient_id | recipient_email | sent_at | status |
|---|---|---|---|---|---|---|
| 33 | 7 | 71 | artist1@gmail.com | 2026-01-23 03:55:37 | sent | |
| 32 | 7 | NULL | prof2@gmail.com | 2026-01-23 03:52:58 | sent | |
| 31 | 7 | NULL | prof1@gmail.com | 2026-01-23 03:52:57 | sent | |
| 30 | 7 | NULL | staff1@gmail.com | 2026-01-23 03:52:56 | sent | |
| 29 | 7 | NULL | bdqueen@gmail.com | 2026-01-23 03:52:55 | sent | |
| 28 | 7 | NULL | admin@gmail.com | 2026-01-23 03:52:54 | sent | |
| 27 | 1 | 134 | artist@gmail.com | 2026-01-23 02:39:42 | sent | |
| 26 | 1 | 134 | artist@gmail.com | 2026-01-23 02:20:37 | sent | |
| 25 | 4 | 134 | artist@gmail.com | 2026-01-23 02:20:30 | sent | |
| 24 | 3 | 134 | artist@gmail.com | 2026-01-23 02:20:07 | sent | |
| 23 | 2 | 1 | admin@gmail.com | 2026-01-23 02:20:01 | sent | |
| 22 | 5 | 134 | artist@gmail.com | 2026-01-23 01:45:15 | sent | |
| 21 | 6 | 134 | artist@gmail.com | 2026-01-23 01:45:05 | sent | |
| 20 | 6 | NULL | prof2@gmail.com | 2026-01-23 01:42:01 | sent | |
| 19 | 6 | NULL | prof1@gmail.com | 2026-01-23 01:42:01 | sent | |
| 18 | 6 | NULL | staff1@gmail.com | 2026-01-23 01:42:01 | sent | |
| 17 | 6 | NULL | bdqueen@gmail.com | 2026-01-23 01:42:01 | sent | |
| 16 | 6 | NULL | admin@gmail.com | 2026-01-23 01:42:01 | sent | |
| 15 | 5 | NULL | prof2@gmail.com | 2026-01-23 01:39:11 | sent | |
| 14 | 5 | NULL | prof1@gmail.com | 2026-01-23 01:39:11 | sent |