1
2
3
4
5
6
7
8
9
10
11
12
13
| -- 建立小鈴鐺通知的table
|
| CREATE TABLE public.personal_notification (
| id bigserial NOT NULL,
| title varchar NULL,
| "content" varchar NOT NULL,
| notification_type varchar NOT NULL,
| owner_role varchar NOT NULL,
| owner_id bigserial NOT NULL,
| created_date timestamp NOT NULL,
| read_date timestamp NULL,
| CONSTRAINT personal_notification_pkey PRIMARY KEY (id)
| );
|
|
