SyNZz91D

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