QdGVQj6U

1CREATE SEQUENCE public.entity_id_sequence INCREMENT 1 START 1 MINVALUE 1;
2
3CREATE TABLE IF NOT EXISTS products
4(
5    id          BIGINT PRIMARY KEY,
6    name        VARCHAR(30)                       NOT NULL,
7    price       NUMERIC(15, 2)                    NOT NULL,
8    quantity    BIGINT                            NOT NULL,
9    category_id BIGINT REFERENCES categories (id) NOT NULL
10);
11
12
13CREATE TABLE IF NOT EXISTS orders
14(
15    id         BIGINT PRIMARY KEY,
16    user_id    BIGINT REFERENCES users (id) NOT NULL,
17    created_at date                         NOT NULL
18);
19
20
21CREATE TABLE IF NOT EXISTS order_entries
22(
23    product_id       BIGINT REFERENCES products (id) NOT NULL,
24    order_id         BIGINT REFERENCES orders (id)   NOT NULL,
25    product_quantity BIGINT                          NOT NULL,
26    price            NUMERIC(15, 2)                  NOT NULL,
27    total            NUMERIC(15, 2)                  NOT NULL
28);
29CREATE TABLE IF NOT EXISTS cart
30(
31    id               BIGINT PRIMARY KEY,
32    product_id       BIGINT REFERENCES products (id) NOT NULL,
33    product_quantity BIGINT                          NOT NULL,
34    user_id          BIGINT REFERENCES users (id)    NOT NULL
35);
36CREATE TABLE IF NOT EXISTS categories
37(
38    id        BIGINT PRIMARY KEY,
39    name      VARCHAR(30) NOT NULL,
40    parent_id BIGINT REFERENCES categories (id)
41);
42
43CREATE TABLE IF NOT EXISTS users
44(
45    id         BIGINT PRIMARY KEY,
46    username   VARCHAR(30) NOT NULL,
47    first_name VARCHAR(30) NOT NULL,
48    last_name  VARCHAR(30) NOT NULL,
49    password   VARCHAR(50) NOT NULL,
50    email      VARCHAR(50) NOT NULL,
51    role       VARCHAR(10) NOT NULL,
52    created_at date        NOT NULL
53);