QuackerAPI/drawSQL-pgsql-export-2023-11-12.sql at main · Dominguezd01/QuackerAPI · 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
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87

CREATE TABLE "quacks"(
    "id" SERIAL NOT NULL,
    "quack_id" VARCHAR(45) NOT NULL,
    "content" VARCHAR(255) NOT NULL,
    "creation_date" TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL DEFAULT 'NOW()',
    "parent_post_id" INTEGER NULL,
    "is_quote" BOOLEAN NOT NULL,
    "is_reply" BOOLEAN NOT NULL
);
ALTER TABLE
    "quacks" ADD PRIMARY KEY("id");

CREATE TABLE "users"(
    "id" SERIAL NOT NULL,
    "user_id" VARCHAR(255) NOT NULL,
    "user_name" VARCHAR(255) NOT NULL,
    "display_name" VARCHAR(255) NOT NULL,
    "password" VARCHAR(255) NOT NULL,
    "profile_picture" VARCHAR(255) NULL,
    "email" VARCHAR(255) NOT NULL,
    "is_active" BOOLEAN NOT NULl,
    "email_is_valid" BOOLEAN NOT NULL
);
ALTER TABLE
    "users" ADD PRIMARY KEY("id");
ALTER TABLE
    "users" ADD CONSTRAINT "users_user_id_unique" UNIQUE("user_id");
ALTER TABLE
    "users" ADD CONSTRAINT "users_user_name_unique" UNIQUE("user_name");
ALTER TABLE
    "users" ADD CONSTRAINT "users_email_unique" UNIQUE("email");


CREATE TABLE "user_quack_like"(
    "id" SERIAL NOT NULL,
    "post_id" INTEGER NOT NULL,
    "user_id" INTEGER NOT NULL
);
ALTER TABLE
    "user_quack_like" ADD PRIMARY KEY("id");


CREATE TABLE "requacks"(
    "id" SERIAL NOT NULL,
    "user_id" INTEGER NOT NULL,
    "post_id" INTEGER NOT NULL
);

ALTER TABLE
    "requacks" ADD PRIMARY KEY("id");


CREATE TABLE "user_quak"(
    "id" SERIAL NOT NULL,
    "post_id" INTEGER NOT NULL,
    "user_id" INTEGER NOT NULL
);
ALTER TABLE
    "user_quak" ADD PRIMARY KEY("id");


CREATE TABLE "user_follows"(
    "id" SERIAL NOT NULL,
    "user_id_following" INTEGER NOT NULL,
    "user_id_followed" INTEGER NOT NULL
);
ALTER TABLE
    "user_follows" ADD PRIMARY KEY("id");
ALTER TABLE
    "requacks" ADD CONSTRAINT "requacks_user_id_foreign" FOREIGN KEY("user_id") REFERENCES "users"("id");
ALTER TABLE
    "user_quack_like" ADD CONSTRAINT "user_quack_like_post_id_foreign" FOREIGN KEY("post_id") REFERENCES "quacks"("id");
ALTER TABLE
    "user_quak" ADD CONSTRAINT "user_quak_post_id_foreign" FOREIGN KEY("post_id") REFERENCES "quacks"("id");
ALTER TABLE
    "user_follows" ADD CONSTRAINT "user_follows_user_id_followed_foreign" FOREIGN KEY("user_id_followed") REFERENCES "users"("id");
ALTER TABLE
    "user_quack_like" ADD CONSTRAINT "user_quack_like_user_id_foreign" FOREIGN KEY("user_id") REFERENCES "users"("id");
ALTER TABLE
    "user_follows" ADD CONSTRAINT "user_follows_user_id_following_foreign" FOREIGN KEY("user_id_following") REFERENCES "users"("id");
ALTER TABLE
    "user_quak" ADD CONSTRAINT "user_quak_user_id_foreign" FOREIGN KEY("user_id") REFERENCES "users"("id");
ALTER TABLE
    "requacks" ADD CONSTRAINT "requacks_post_id_foreign" FOREIGN KEY("post_id") REFERENCES "quacks"("id");