Wp0qASXm

1CREATE SEQUENCE public.hibernate_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                           NOT NULL,
8    quantity    BIGINT,
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    quantity   BIGINT,
26    price      NUMERIC                         NOT NULL,
27    total      NUMERIC
28);
29CREATE TABLE IF NOT EXISTS cart
30(
31    id                BIGINT PRIMARY KEY,
32    product_id        BIGINT REFERENCES products (id) NOT NULL,
33    products_quantity BIGINT,
34    total             NUMERIC                         NOT NULL
35
36);
37CREATE TABLE IF NOT EXISTS categories
38(
39    id   BIGINT PRIMARY KEY,
40    name VARCHAR(30) NOT NULL
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);