pf_3041_04_create_table_dma_message.sql
2.39 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
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
-- Table: public.dma_message
-- DROP TABLE public.dma_message;
CREATE TABLE public.dma_message
(
id integer NOT NULL DEFAULT nextval('dma_message_id_seq'::regclass),
key character varying(100) COLLATE pg_catalog."default",
"fromUserId" integer,
"toUserId" integer,
"contactIds" character varying(2000) COLLATE pg_catalog."default",
message character varying(4096) COLLATE pg_catalog."default",
sent boolean DEFAULT false,
delivered boolean DEFAULT false,
read boolean DEFAULT false,
"createdAtTime" bigint,
type integer,
source integer,
status integer NOT NULL DEFAULT 0,
paired_message_id integer,
"contentType" integer,
group_id integer,
group_name character varying(200) COLLATE pg_catalog."default",
from_user_name character varying(80) COLLATE pg_catalog."default",
metadata character varying(100) COLLATE pg_catalog."default",
delivered_time timestamp without time zone,
"createdDate" timestamp without time zone DEFAULT now(),
"updatedDate" timestamp without time zone DEFAULT now(),
"deviceKey" character varying(200) COLLATE pg_catalog."default",
shared boolean DEFAULT false,
"storeOnDevice" boolean DEFAULT false,
"sentToServer" boolean DEFAULT false,
"sendToDevice" boolean DEFAULT false,
"sentMessageTimeAtServer" integer,
"documentId" character varying COLLATE pg_catalog."default",
delete boolean DEFAULT false,
"paredUserId" character varying(100) COLLATE pg_catalog."default",
CONSTRAINT dma_message_pkey PRIMARY KEY (id),
CONSTRAINT dma_message_fromuserid_wd_user_fk FOREIGN KEY ("fromUserId")
REFERENCES public.wd_user (id) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE NO ACTION,
CONSTRAINT dma_message_togroupid_wd_group_fk FOREIGN KEY (group_id)
REFERENCES public.wd_group (id) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE NO ACTION,
CONSTRAINT dma_message_touserid_wd_user_fk FOREIGN KEY ("toUserId")
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
OWNER to wdchat;
-- Index: dma_message_idx_createdattime
-- DROP INDEX public.dma_message_idx_createdattime;
CREATE INDEX dma_message_idx_createdattime
ON public.dma_message USING btree
("createdAtTime")
TABLESPACE pg_default;