컬럼 구조
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 |
|---|---|---|---|---|---|---|
| 13 | 5 | NULL | staff1@gmail.com | 2026-01-23 01:39:11 | sent | |
| 12 | 5 | NULL | bdqueen@gmail.com | 2026-01-23 01:39:11 | sent | |
| 11 | 5 | NULL | admin@gmail.com | 2026-01-23 01:39:11 | sent | |
| 10 | 4 | NULL | prof2@gmail.com | 2026-01-23 01:37:13 | sent | |
| 9 | 4 | NULL | prof1@gmail.com | 2026-01-23 01:37:13 | sent | |
| 8 | 4 | NULL | staff1@gmail.com | 2026-01-23 01:37:13 | sent | |
| 7 | 4 | NULL | bdqueen@gmail.com | 2026-01-23 01:37:12 | sent | |
| 6 | 4 | NULL | admin@gmail.com | 2026-01-23 01:37:12 | sent | |
| 5 | 3 | NULL | prof2@gmail.com | 2026-01-23 01:35:52 | sent | |
| 4 | 3 | NULL | prof1@gmail.com | 2026-01-23 01:35:52 | sent | |
| 3 | 3 | NULL | staff1@gmail.com | 2026-01-23 01:35:52 | sent | |
| 2 | 3 | NULL | bdqueen@gmail.com | 2026-01-23 01:35:52 | sent | |
| 1 | 3 | NULL | admin@gmail.com | 2026-01-23 01:35:52 | sent |