APIJSON/PostgreSQL/single/postgres_sys_Praise.sql at dependabot/maven/APIJSON-Java-Server/APIJSONBootOracle/com.alibaba-fastjson-1.2.25 · linuxnc/APIJSON · GitHub

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
create table "Praise"
(
    id         bigint not null
        constraint "Praise_pkey"
            primary key,
    "momentId" bigint not null,
    "userId"   bigint not null,
    date       timestamp(6)
);

comment on table "Praise" is '如果对Moment写安全要求高，可以将Moment内praiserUserIdList分离到Praise表中，作为userIdList。
权限注解也改下：
@MethodAccess(
		PUT = {OWNER, ADMIN}
		)
class Moment {
       …
}

@MethodAccess(
		PUT = {LOGIN, CONTACT, CIRCLE, OWNER, ADMIN}
		)
 class Praise {
       …
 }
';

comment on column "Praise".id is '动态id';

comment on column "Praise"."momentId" is '唯一标识';

comment on column "Praise"."userId" is '用户id';

comment on column "Praise".date is '点赞时间';

alter table "Praise"
    owner to postgres;

INSERT INTO sys."Praise" (id, "momentId", "userId", date) VALUES (1, 12, 82001, '2017-11-19 13:02:30.000000');
INSERT INTO sys."Praise" (id, "momentId", "userId", date) VALUES (2, 15, 82002, '2017-11-19 13:02:30.000000');
INSERT INTO sys."Praise" (id, "momentId", "userId", date) VALUES (3, 32, 82003, '2017-11-19 13:02:30.000000');
INSERT INTO sys."Praise" (id, "momentId", "userId", date) VALUES (4, 58, 82004, '2017-11-19 13:02:30.000000');
INSERT INTO sys."Praise" (id, "momentId", "userId", date) VALUES (5, 170, 82005, '2017-11-19 13:02:30.000000');
INSERT INTO sys."Praise" (id, "momentId", "userId", date) VALUES (6, 235, 82006, '2017-11-19 13:02:30.000000');
INSERT INTO sys."Praise" (id, "momentId", "userId", date) VALUES (7, 301, 82007, '2017-11-19 13:02:30.000000');
INSERT INTO sys."Praise" (id, "momentId", "userId", date) VALUES (8, 371, 82008, '2017-11-19 13:02:30.000000');
INSERT INTO sys."Praise" (id, "momentId", "userId", date) VALUES (9, 470, 82009, '2017-11-19 13:02:30.000000');
INSERT INTO sys."Praise" (id, "momentId", "userId", date) VALUES (10, 511, 82010, '2017-11-19 13:02:30.000000');
INSERT INTO sys."Praise" (id, "momentId", "userId", date) VALUES (11, 543, 82011, '2017-11-19 13:02:30.000000');
INSERT INTO sys."Praise" (id, "momentId", "userId", date) VALUES (12, 551, 82012, '2017-11-19 13:02:30.000000');
INSERT INTO sys."Praise" (id, "momentId", "userId", date) VALUES (13, 594, 82013, '2017-11-19 13:02:30.000000');
INSERT INTO sys."Praise" (id, "momentId", "userId", date) VALUES (14, 595, 82014, '2017-11-19 13:02:30.000000');
INSERT INTO sys."Praise" (id, "momentId", "userId", date) VALUES (15, 704, 82015, '2017-11-19 13:02:30.000000');
INSERT INTO sys."Praise" (id, "momentId", "userId", date) VALUES (16, 1491200468898, 82016, '2017-11-19 13:02:30.000000');
INSERT INTO sys."Praise" (id, "momentId", "userId", date) VALUES (17, 1491277116776, 82017, '2017-11-19 13:02:30.000000');
INSERT INTO sys."Praise" (id, "momentId", "userId", date) VALUES (18, 1493835799335, 82018, '2017-11-19 13:02:30.000000');