Actions
Activity #3531
openFeature #3752: Design of the web framework for Data Centre Software
Feature #1850: Design and Development for web based ANRS
Module #3527: Development for in-app real-time notifications
Create Notification Table in Oracle
Start date:
04/25/2025
Due date:
% Done:
100%
Estimated time:
Planned Due Date:
04/28/2025
Description
CREATE TABLE notifications (
notifi_id NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY PRIMARY KEY,
user_id NUMBER NOT NULL,
type VARCHAR2, //'USER_ADD' for user add
message VARCHAR2, 'The notification message to show'
data CLOB, -- optional for extra JSON data
is_read CHAR DEFAULT 'N', -- 'Y' or 'N'
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
Updated by Siji Mathew over 1 year ago
- Status changed from New to Resolved
- % Done changed from 0 to 100
Actions