Yx2J0WR1

1CREATE TABLE IF NOT EXISTS addresses (
2    id                     UUID              NOT NULL PRIMARY KEY,
3    dadata_value           VARCHAR(250)      NOT NULL,
4    fias                   VARCHAR(37)       NOT NULL
5);
6
7CREATE TABLE IF NOT EXISTS codes (
8    id                     UUID              NOT NULL PRIMARY KEY,
9    address                UUID              NOT NULL REFERENCES addresses(id),
10    entrance               VARCHAR(10)       NULL,
11    code                   VARCHAR(10)       NOT NULL
12);
13
14CREATE TABLE IF NOT EXISTS users (
15    id                     UUID              NOT NULL PRIMARY KEY,
16    telegram_chat_id       BIGINT            NOT NULL
17);
18
19CREATE UNIQUE INDEX IF NOT EXISTS users_telegram_chat_id ON users (telegram_chat_id);
20
21CREATE TABLE IF NOT EXISTS code_ratings (
22    code_id                UUID              NOT NULL PRIMARY KEY,
23    rating                 INT               NOT NULL
24);
25
26CREATE TABLE IF NOT EXISTS user_code_ratings (
27    code_id                UUID              NOT NULL,
28    user_id                UUID              NOT NULL,
29    rating                 INT               NOT NULL,
30
31    PRIMARY KEY (code_id, user_id)
32);
33
34CREATE TABLE IF NOT EXISTS user_codes (
35    code_id                UUID              NOT NULL,
36    user_id                UUID              NOT NULL,
37    
38    PRIMARY KEY (code_id, user_id)
39);