ClassMateBot/init.sql at main · SE21-Team2/ClassMateBot · 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
CREATE TABLE reminders (
    guild_id        BIGINT NOT NULL,
    author_id       BIGINT NOT NULL,
    course          VARCHAR NOT NULL,
    homework        VARCHAR NOT NULL,
    due_date        TIMESTAMP WITH TIME ZONE NOT NULL
);

CREATE TABLE group_members (
    guild_id        BIGINT NOT NULL,
    group_num       INTEGER NOT NULL,
    member_name     VARCHAR NOT NULL
);

CREATE TABLE project_groups (
    guild_id        BIGINT NOT NULL,
    project_num     INTEGER NOT NULL,
    group_num       INTEGER NOT NULL
);

CREATE TABLE name_mapping (
    guild_id        BIGINT NOT NULL,
    username        VARCHAR NOT NULL,
    real_name       VARCHAR NOT NULL
);

CREATE TABLE pinned_messages (
    guild_id        BIGINT NOT NULL,
    author_id       BIGINT NOT NULL,
    tag             VARCHAR NOT NULL,
    description     VARCHAR NOT NULL,
);

CREATE TABLE review_questions (
    guild_id        BIGINT NOT NULL,
    question        VARCHAR NOT NULL,
    answer          VARCHAR NOT NULL
);