-- 建立小鈴鐺通知的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)
);
