tDZn15he

1CREATE TABLE IF NOT EXISTS products
2(
3    id    SERIAL PRIMARY KEY AUTO_INCREMENT,
4    name  CHARACTER VARYING(30) NOT NULL,
5    price NUMERIC               NOT NULL,
6    count INTEGER
7);
8
9
10CREATE TABLE IF NOT EXISTS orders
11(
12    id         SERIAL PRIMARY KEY AUTO_INCREMENT,
13    user_id    INTEGER REFERENCES users (id) NOT NULL,
14    created_at date                          NOT NULL
15);
16
17
18CREATE TABLE IF NOT EXISTS order_entries
19(
20    product_id INTEGER REFERENCES products(id) NOT NULL,
21    order_id INTEGER REFERENCES orders(id) NOT NULL,
22    count INTEGER,
23    price NUMERIC NOT NULL,
24    amount NUMERIC
25);
26CREATE TABLE IF NOT EXISTS cart
27(
28    id         SERIAL PRIMARY KEY AUTO_INCREMENT,
29    product_id INTEGER REFERENCES products (id) NOT NULL,
30    count      INTEGER,
31    amount     NUMERIC                          NOT NULL
32
33);
34CREATE TABLE IF NOT EXISTS categories
35(
36    id         SERIAL PRIMARY KEY KEY AUTO_INCREMENT,
37    name       CHARACTER VARYING(30)            NOT NULL,
38    product_id INTEGER REFERENCES products (id) NOT NULL
39);
40
41CREATE TABLE IF NOT EXISTS users
42(
43    id         SERIAL PRIMARY KEY AUTO_INCREMENT,
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);