type enum not null default "unspecified" *see above*
visibility enum[adminOnly, all] not null default "adminOnly"
content text not null *markdown text*
createdDate managed by Sequelize but this will be used in the app too
DB schema alteration — Account
create readNotificationIds json(array) null
New Backend APIs
GET /admin/notification ‐ Gets all notifications regardless of read status
POST /admin/notification – Create a new notification
GET /admin/notification/:id – Get single notification
PATCH /admin/notification/:id – Edit an existing notification
DELETE /admin/notification/:id – Delete an existing notification
POST /admin/notification/:id/read – Update read status of specified notification by adding notification ID in readNotificationIds of current authenticated account
Notification types
New DB schema — Notification
id
int not null primary key auto incrementtitle
varchar(256) not nulltype
enum not null default "unspecified" *see above*visibility
enum[adminOnly, all]
not null default "adminOnly"content
text not null *markdown text*createdDate
managed by Sequelize but this will be used in the app tooDB schema alteration — Account
readNotificationIds
json(array) nullNew Backend APIs
GET /admin/notification
‐ Gets all notifications regardless of read statusPOST /admin/notification
– Create a new notificationGET /admin/notification/:id
– Get single notificationPATCH /admin/notification/:id
– Edit an existing notificationDELETE /admin/notification/:id
– Delete an existing notificationPOST /admin/notification/:id/read
– Update read status of specified notification by adding notification ID inreadNotificationIds
of current authenticated account