[postgres] #pgsql

notification.sql

CREATE TABLE notification (
	"id" VARCHAR(32),
	"action_type" SMALLINT NOT NULL,
	"obj_type" VARCHAR(16) NOT NULL,
	"obj" VARCHAR(32) NOT NULL,
	"actor" VARCHAR(32) NOT NULL,
	"create_at" timestamp DEFAULT (now() at time zone 'utc'),
	"updated_at" timestamp DEFAULT (now() at time zone 'utc'),
	"status" SMALLINT NOT NULL DEFAULT 1,
	PRIMARY KEY ("id"),
	CONSTRAINT actor_fk FOREIGN KEY (actor) REFERENCES "user" (id)
);