pf_3041_03_create_table_dma_message_user_rel.sql
1.52 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
-- Table: public.dma_message_user_rel
-- DROP TABLE public.dma_message_user_rel;
CREATE TABLE public.dma_message_user_rel
(
id integer NOT NULL DEFAULT nextval('dma_message_user_rel_id_seq'::regclass),
"messageId" integer NOT NULL,
"userId" integer NOT NULL,
read boolean DEFAULT false,
delete boolean DEFAULT false,
"createdDate" timestamp without time zone NOT NULL DEFAULT now(),
"updatedDate" timestamp without time zone NOT NULL DEFAULT now(),
delivered boolean DEFAULT false,
"deliveredAtTime" timestamp without time zone,
"readAtTime" timestamp without time zone,
blocked boolean DEFAULT false,
"blockedAtTime" timestamp without time zone,
"deleteAtTime" timestamp without time zone,
CONSTRAINT dma_message_user_rel_pk PRIMARY KEY (id),
CONSTRAINT dma_message_user_rel_dma_message_fk FOREIGN KEY ("messageId")
REFERENCES public.dma_message (id) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE NO ACTION,
CONSTRAINT dma_message_user_rel_wd_user_fk FOREIGN KEY ("userId")
REFERENCES public.wd_user (id) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE NO ACTION
)
WITH (
OIDS = FALSE
)
TABLESPACE pg_default;
ALTER TABLE public.dma_message_user_rel
OWNER to wdchat;
-- Index: dma_message_user_rel_constain_unique
-- DROP INDEX public.dma_message_user_rel_constain_unique;
CREATE UNIQUE INDEX dma_message_user_rel_constain_unique
ON public.dma_message_user_rel USING btree
("messageId" DESC, "userId" DESC)
TABLESPACE pg_default;